Inexplicable change in the handling of numbers in string functions

Aspose.Cells Product Family
1

Recently upgraded from cells for java 20.11 to 23.4. We have workbooks with numerical cells which we are then using as inputs for a string function, for example, given the numerical cell value…

12345678912.2635

…with a cell number format in the sheet that respects all the digits, we use that call as an input to…

=right(, 6)

…and with 20.11 we get the result “2.2635”. Unsurprising. But, with 23.4 we get “635E10”. Clearly, the numerical format is being ignored, and the number converted to 1.23456789122635E10 before being fed into the right function. The scientific notation is a valid and equivalent number, but not how excel expresses the number with its format, nor does the right function match the return in excel in version 23.4.

I think you have a bug and the change is certainly affecting us.

2

@dberkman
We have created a sample file that can reproduce the issue through testing. (12.5 KB)

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSJAVA-45475
3

Thank you. As a free support customer we realize we’re in a queue. Fortunately, none of your paid support customers have reported this issue yet, and I’m sure that means it’s unlikely to come up and harm their business operations in any meaningful way. So, yup, patiently awaiting in the queue…

All attempts at provoking favoritism aside, we do appreciate your attention in this matter.

4

@dberkman,

Yes, none of our paid support clients has posted such an issue. Anyways, we will surely evaluate your issue in details and try to figure it out soon. Once we have an update on it, we will let you know here.

Thanks for being patient.

5

@dberkman,

We are pleased to inform you that your issue has been resolved. The fix will be included in our upcoming release (Aspose.Cells v23.7) that we plan to release in the first half of July 2023. You will be notified when the next version is released.

6

The issues you have found earlier (filed as CELLSJAVA-45475) have been fixed in Aspose.Cells for Java 23.7.