on 04-17-2009 2:03 PM
Hello,
I've run into a problem with the spreadsheet component and numeric formatting of negative numbers in parenthesis.
In Excel columns of numbers that have negative values enclosed in parethesis have their decimal points line up with positive numbers. Excel's numeric formatting does this by putting a whitespace character at the end of formatted text of the cell for positive numbers.
The problem occurs with the spreadsheet control in that it is stripping any trailing whitespace from the cell text which is a big no-no. This is a clearly a bug as it destroys the numeric formating and causes the positive and negative numbers in the column to not line up by their decmal points.
Management is not happy about this and I've tried workarounds but the spreadsheet component always removes trailing whitespace. Business accounting always done with negative numbers in parenthesis so using minus signs instead of parenthesis for negative numbers is not an option.
Is there any known workaround for this problem?
Can this problem be fixed in a future hot fix or with an improved add-on component?
Thanks,
Dave Reed
Hi
There are some bugs with number formatting in the Spreadsheet Component.
If you use a number format like #,##0;[Red]-#,##0;0 the spreadsheet component correctly displays the data as positive values are in your default colour and negative values are in Red. However if the data changes and the negative number becomes positive the number still displays in Red in the component.
SAP - can these issues be added to the enhancement list please?
Best Regards
Charles
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm not sure if you understood the exact nature of this problem. The problem not with colors. The problem is with the horizontal alignment of numbers for which negative numbers are display enclosed in parenthesis, for example -5.0 appears as (5.0).
In Excel a column of numbers formatted to show negative numbers in parethesis will horzontally right align so that all numbers line up by the decimal point. The XCelsius spreadsheet component does not mainain this formatting correctly.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.