Negative values change to positive in accounting format

Aspose.Cells Product Family
1

When I highlight cells that include negative values (such as -123), then right-click, choose format cells, and choose accounting format, the negative values show up as positive values. The negative sign is replaced by the $ sign. Please help with this issue.

2

Hi,

Thanks for your posting and considering Aspose.

It seems your issue is related to MS-Excel. MS-Excel shows -123 in accounting format as $(123). Here brackets mean the negative number.

If this issue is related to Aspose.Cells, then please provide more description and the sample code. We will look into it and help you asap.

3

I attached my aspose files. The aspose program is changing -123 to $123. Check the accounting format.png file attached. The sample in the png shows that -123 will change to $123. Thank you.

4

Hi Curt,

Thanks for your posting and using Aspose.Cells for GridDesktop.

We were able to observe this issue. The negative values change to positive in accounting format. We have logged this issue in our database. We will look into it and fix this issue. Once the issue is resolved or we have some other update for you, we will let you know asap/

This issue has been logged as CELLSNET-42166.

5

Hi,


It is to update you that we have fixed your issue now. A supported version (next version/fix) would be provided here soon.

Keep in touch.

Thank you.
6

Hi,

Thanks for using Aspose.Cells for GridDesktop.

We have fixed this issue.

Please download and try this fix: Aspose.Cells
for GridDesktop v3.0.0.2001 and let us know your feedback.

7

The issues you have found earlier (filed as CELLSNET-42166) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.