Page 1 of 1

Export to excel

Posted: Sun Mar 01, 2015 9:40 am
by 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 !

Re: Export to excel

Posted: Mon Mar 02, 2015 7:09 am
by 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.

Re: Export to excel

Posted: Mon Mar 02, 2015 8:43 am
by 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

Re: Export to excel

Posted: Mon Mar 02, 2015 11:10 am
by HighAley
Hello.

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

Thank you.

Re: Export to excel

Posted: Tue Mar 03, 2015 11:26 am
by G.hammad
Hello,

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

Re: Export to excel

Posted: Tue Mar 10, 2015 9:51 am
by G.hammad
Hello,

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

thank you

Re: Export to excel

Posted: Wed Mar 11, 2015 12:42 pm
by 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
decimalDigits.png (8.51 KiB) Viewed 3398 times
In this case the report will be exported right with your current build.

Thank you.

Re: Export to excel

Posted: Wed Mar 11, 2015 1:15 pm
by 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 ?!

Re: Export to excel

Posted: Wed Mar 11, 2015 1:34 pm
by HighAley
Hello.

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

Thank you.