Export to excel

[G.hammad]

Hello,

i need to now why when export to excel the format of any value change! not keep as it!
is there any option must enabled to keep custom format for cell as is ?!

for example i have custom format for cross tab sum : #,##0.0000 and value = 19.2300
the value in excel sheet appear like this : 19.23 and if value = 0.0000 appear like this : 0 !

[HighAley]

Hello.

Sorry, but we couldn't reproduce the issue.
Could you specify what our component do you use?
Which version? What export settings do you use?

Thank you.

[G.hammad]

Hello,

I'm using this version: 2014.2.2000.0
using cross tab component with custom format
you can check it with the attached excel file where the custom format in my code is : #,##0.0000

[HighAley]

Hello.

We have reproduced the issue.
We need some time for analyzing.
We will let you know about result.

Thank you.

[G.hammad]

Hello,

ok i'm waiting your answer as soon as possible and thank you

[G.hammad]

Hello,

what happen with you ?! is there any way to solve this problem or not?!

thank you

[HighAley]

Hello.

We have made an improvement. Please, check our next prerelease build.

If you just need four decimal digits, it's better to set it in Number Format.

decimalDigits.png (8.51 KiB) Viewed 3403 times

In this case the report will be exported right with your current build.

Thank you.

[G.hammad]

Hello Aleksey,

thank you for your answer but in my case number of digit may change
based on what user select from decimal digit combo in screen...
so is there another way to do that ?!

[HighAley]

Hello.

Then, please, wait for our next prerelease build.
It will be available on Friday.

Thank you.