BoldSign®Effortlessly integrate e-signatures into your app with the BoldSign® API. Create a sandbox account!
Hello
I have been using the XLSIO control and found an issue. Namely, it inserts braces around my formula... which in turn causes a "#NAME?" error in Excel. I am inserting data into an existing Excel workbook (not creating formulas in XLSIO), so this change is happening to existing formulas in Excel which work perfectly fine before. If I go into the workbook after XLSIO and remove the braces, the formulas work with no issue.
Formula before: =INDEX($B$2:$B13,MATCH(2,1/($Q$2:$Q13=TRUE)))&":"&TEXTAFTER(B14," - ")
Formula after: {=INDEX($B$2:$B13,MATCH(2,1/($Q$2:$Q13=TRUE)))&":"&TEXTAFTER(B14," - ")}
Why is XLSIO inserting braces around formulas? Is there a way to prevent this? It breaks the workbook otherwise.
Dushan
Hi Dushan,
We are saving the workbook using XlsIO with a formula whose data had been removed in the referred range in Excel. After reopening the saved file and filling the data of the formula's referred range, we were able to reproduce the reported issue.
Please confirm if this is the same issue you are facing. If not, please share the Excel document in which the issue is occurring, as well as the Syncfusion XlsIO version you are using. This will be helpful for us in investigating the query further.
We will share the validation details for the issue we reproduced in two business days, on February 16th, 2023.
Regards,
Rahul
HI all
Looks like the braces are no longer present, which is great. However I'm also noticing some formulas return empty cells until i place my cursor in the formula bar (as if I'm going to edit) and then hit Enter. So I've changed literally nothing in the formula, but until I enter the formula bar and hit Enter, the cell remains empty.
One more note... I do still see formulas with braces. This doesn't seem to be limited to TEXTAFTER. Example:
={-1*IFERROR(INDEX('Sheet1'!$C:$N,MATCH($A14,'Sheet1'!$T:$T,0),COUNTIF($C$3:C$3,"Actual")),0)}
|
Query |
Response |
|
However I'm also noticing some formulas return empty cells until i place my cursor in the formula bar (as if I'm going to edit) and then hit Enter. |
Could you please share the Issue reproducing Excel file or issue reproducing formula which will help us to investigate the query further.
|
|
One more note... I do still see formulas with braces. This doesn't seem to be limited to TEXTAFTER. Example: ={-1*IFERROR(INDEX('Sheet1'!$C:$N,MATCH($A14,'Sheet1'!$T:$T,0),COUNTIF($C$3:C$3,"Actual")),0)}
|
We can reproduce the reported issue and validating it. We will share the validation details on March 27, 2023. |
we have confirmed the issue as Formula is getting corrupted while resaving the Excel document with IFERROR function and logged a defect report. We will in include the fix for this issue in our weekly NuGet release scheduled for April 11, 2023. You can track the status of this defect report through below feedback link.
Disclaimer: Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works reprioritization.
Dushan, we have confirmed the issue as "Formula calculation is incorrect after resaving Excel document with TEXTAFTER formula" and logged a defect report. We will include the fix for this issue in our weekly NuGet release scheduled for March 7th, 2023.
You can track the status of this defect report through below feedback link.
https://www.syncfusion.com/feedback/41221/formula-calculation-is-incorrect-after-resaving-excel-document-with-textafter
Disclaimer: Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works reprioritization.