Hi
I have a customer that relies heavy on aspose.
We have upgraded our solution from .net core 2.2 to 3.1.
But now we get a problem with concatenate
We have this fomular:
=+CONCATENATE(“OS21100000000000000000000000000”;$B$1;$B$2;87644014;$B$4;“0000000000000”)
Which generate this output in .net core 2.2:
OS2110000000000000000000000000000010008764401400000000000000
But in .net core 3 or 3.1 the formular is changed to:
=+CONCATENATE(“OS21100000000000000000000000000”;$B$1;$B$2;87644013,9999999;$B$4;“0000000000000”)
and out ends up as
OS2110000000000000000000000000000010087644013,99999990000000000000
It has then rounded the number instead of keeping the format.
The original file is the same.
It can be fixed by added “” around 87644014.
But the problem is that i may be written like that in several hundred excel files and it would be impossible to find and fix them all.
Is this some sort of bug or ?