pivot4j icon indicating copy to clipboard operation
pivot4j copied to clipboard

Published 20 hours ago • verified publisher icon mysticfall

Some aggregation values shows with wrong number format.

Open mysticfall opened this issue 11 years ago • 4 comments

With some format string settings (i.e. "#,#"), aggregated values fail to displayed correctly due to difference between java.text.DecimalFormat and VisualBasic's format() rules.

We need to copy or reuse existing implementation like http://mondrian.pentaho.com/api/mondrian/util/Format.html.

mysticfall avatar May 23 '13 15:05 mysticfall

Is this also the reason why after exporting aggregated values to excel file they have "wrong" format? By "wrong" I mean they are not formatted the same way as other cells. It could be very uncomfortable to users when they want to do in Excel some operations on this aggregated values.

klaudiusz223 avatar May 29 '13 07:05 klaudiusz223

@klaudiusz223 Yes, it could be the same problem. By the way, could you give me the MDX that reproduces the problem please?

mysticfall avatar May 29 '13 08:05 mysticfall

But I think it's not connected with any particular MDX.

Some examples SELECT {[Measures].[Profit]} ON COLUMNS, {[Gender].[F], [Gender].[M]} ON ROWS FROM [Warehouse and Sales]

image

image

In Excel cells in gray are formatted as text cells in white are formatted as numbers

klaudiusz223 avatar May 29 '13 10:05 klaudiusz223

Ah, I see you were talking about a different bug from this one. Anyway I just fix that problem and committed the changes, so I guess we have no reason to be confused about it anymore :)

mysticfall avatar May 29 '13 10:05 mysticfall