CODEWITHSUNDEEP
pentahopentaho-report-designer
asarapure
asarapure

Reputation: 605

Excel export from Pentaho Report Designer missing commas

Using Report Designer, when I preview the data in a PDF, the number formatting for PDF is correct in which there is a thousands separator--a comma after 3 digits--but the Excel output has it missing.

Excel - 857320
PDF - 857,320

What changes can be made to the attributes so that the comma is present for the Excel export as well?

Upvotes: 1

Views: 551

Answers (1)

asarapure
asarapure

Reputation: 605

Selecting #,##0 in format of the attributes of number-field gets the comma after 3 digits. It seems in pdf it would work even without this format specification but for excel export it needs to be there.

Upvotes: 1

Related Questions