Aspose.Cells unable to calculate VALUE function

Aspose.Cells Product Family
1

We are calculating an Excel workbook using Aspose.Cells, in one of the cells we have a =VALUE(LEFT(string, index)) formula that shows the #NAME? error in the resulting/saved excel file. However, if I manually select the cell and exit it again the error goes away. Any idea how we can resolve this. I tried to create a simple test workbook, here are the results.

|Cell| Typed Value|Value in Resulting Workbook|Value after exiting cell|
|A1| 33 1/3% Joint & Survivor|33 1/3% Joint & Survivor|33 1/3% Joint & Survivor|
|A2| =LEFT(A1, FIND("%",A1)-1)|33 1/3|33 1/3|
|A3| =VALUE(LEFT(A1, FIND("%",A1)-1))|#VALUE!|33.33333333|
|A4| =VALUE(33 1/3)|33.33333333|33.33333333|
|A5| =VALUE("33 1/3")|#VALUE!|33.33333333|
|A6| =VALUE(LEFT(A1, FIND("%",A1)-1))/100|#VALUE!|0.333333333|

2

@sajad.deyargaroo

Do you mean the “#VALUE!” error or “#NAME?” error? According to the given results, we think it is “#VALUE!” error. If so, it is because currently we do not support parsing the “fraction” values into numeric. We have opened the following new ticket in our internal issue tracking system and will deliver its fix according to the terms mentioned in Free Support Policies.

Issue ID: CELLSNET-57287

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

If you are getting #NAME? error, please provide us your sample code to reproduce the issue and we will look into it soon.

3

Yes, it is “#VALUE!” error in case of strings e.g.,

VALUE(33 1/3) returns 33.33333333 whereas
VALUE(“33 1/3”) returns #VALUE!

Thanks for creating a ticket, is there a way for us to check/track this ticket to view the progress.
Also, if you can give any ballpark ETA for this that would be great.

4

@sajad.deyargaroo
Thank you for your feedback. In normal support here, we deal with issues on a first come, first served basis. We believe this is the fairest and most appropriate way to meet the needs of our customers. If your issue is not complex, we should be able to fix it soon, and the fix may be included in our upcoming release (Aspose.Cells v24.12 - planned for publication in the first half of December). If the issue is complex, it may take a few more weeks or even a month to resolve.

Additionally, if you purchase Paid Support Services , we will prioritize your issue so that it can be resolved earlier.

5

@sajad.deyargaroo,

We are pleased to inform you that your issue (Ticket ID: “CELLSNET-57287”) has been resolved. The fix/enhancement will be included in the upcoming release (Aspose.Cells v24.12) that might be released next week of December 2024. You will be notified once the new version is published.

6

Thanks a bunch!
Appreciate your support on this issue.

7

@sajad.deyargaroo,

You are welcome. We will keep you posted with updates on the new version.

8

The issues you have found earlier (filed as CELLSNET-57287) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi

9

Thanks team!
We have successfully tested this and issue has been resolved. However, our workbook is still having calculation issues and we have created a new topic for this (295838),

10

@sajad.deyargaroo,

It’s good to hear that your original/initial problem has been resolved with Aspose.Cells for .NET v24.12. For the additional (other) issue you mentioned, please refer to and continue the discussion in your other thread for further assistance.