Excel export of numbers with "reverse sign" format

[Mountaine]

Using CR9, when I go into the format editor for a numeric field, and check the "reverse sign" option, and then export to excel (yes, even using the MS Excel 97-2000 data only choice, with "export object formatting" checked), the result in Excel is incorrect. Numbers that show on the Crystal report as positive are showing up in Excel inside parentheses, and numbers that show in Crystal as negative (formatted to display inside parentheses) are showing up in Excel with minus signs! Desperately seeking a solution, since this is affecting dozens of reports, with dozens of objects on each report... Hoping for words of wisdom (hoping I don't just get words of consolation!), Mort Jonas mjonas@madison.main.nc.us

 

[synapsevampire]

Try applying the appropriate service pack:

http://support.businessobjects.com/fix/hot/si75/default.asp

Exporting is never an exact science, but it sounds like a bug or you've incorrectly overridden the formatting of these numbers.

Very odd that both pos and neg are exporting as negatively formatted, in two different ways, sounds like something is confused, could it be that you used code in the formatting and reversed it for the pos?

-k

 

[Mountaine]

Thanks k. Since the problem is showing up both in CR9 and CE9, I don't think it's service pack related. I've done further investigation and noted that when the signs are reversed in Crystal, the Excel export shows all the numbers with "custom formats" that start with minus signs. So the numbers that should show positive are formatted there with minus signs, and the numbers that should show negative are showing with parentheses. And they don't add up right. Aargh!

 

[synapsevampire]

Generally problems in CR are reflected in CE, so it's worth trying the SP.

If you're not using code then I'm at a loss, I can export numerics without that issue using CE 9.

-k