Export to excel

[MayilVahanan]

Hi

Can you please suggest its bug or not.

While export to excel the pivot/straight table, number is converted to text format in dimension.

In attached file, am using aggr() function in dimension.

Edit:

Please find the attached file

[Gysbert_Wassenaar]

Looks like a bug to me. Afaict a calculated dimension is always converted to text.

[MayilVahanan]

Hi

So we can't able to modify it as number format in dimension level using aggr function?

[#4]

i think this is not a bug, because when you export a pie chart , bar chart or any other type chart, the image of chart will be converted to text format in excel

[Gysbert_Wassenaar]

I don't think so. You'll need to either fix the format in Excel or use a macro to export to excel and also fix the format in the macro.

[MayilVahanan]

Hi lssosorio

Yes i agree tat, but actually its a number format. but how its convert the number to text format, is there any reason?

[MayilVahanan]

Hi

We can go with macro, but its not work in access point except internet explorer?

Edit:

Fix the format in Excel -> its manual work, am correct?

[Gysbert_Wassenaar]

Yes, manual work. Unless you create a VBA macro in Excel to do it, but that's complicated.

[#9]

I cant imagine any reason for this, but if you click with right button,  copy to clipboard -> Object , open the excel and then CTRL+V , after this,  you can be able to alter the values.

[MayilVahanan]

Hi Leonardo Osorio and G Wassenaar

Thanks for your reply folks.