Forums Home / Wijmo / General Discussion
Posted by: curiosichi on 25 October 2022, 2:39 pm EST
curiosichi
Posted 25 October 2022, 2:39 pm EST - Updated 25 October 2022, 5:38 pm EST
https://stackblitz.com/edit/angular-n1h5cj?file=src/app/app.component.css
Through that stackblitz, you will see an observed issue with sumifs calc in a flexgrid. The expected result should be 2 in each of the 3 similar formulas, but the second column is not calculating as expected. A copy of this formula example in Excel works as expected.
Could you provide me with some insight?
vivek.pannu
Posted 27 October 2022, 5:57 am EST
Hi,
This is a bug, which is now escalated to the dev team for further investigation with internal tracking id WJM-25175. We will update you as soon as we have an update from the dev team.
Regards
curiosichi
Posted 10 November 2022, 2:34 pm EST
Good day to you,
Any chance we can receive an ETA on this fix? It is affecting our customers and our ability to provide them with an estimate time for a fix.
Thank you.
vivek.pannu
Posted 11 November 2022, 12:32 am EST
Hi,
Sorry but there aren’t any updates, the issue is still under investigation at the Dev team. We have asked the dev team for updates on this case. We will let you know, as soon as we have a response from the dev team.
Regards
curiosichi
Posted 5 January 2023, 2:57 pm EST
Hey there,
Wanted to bump this and see if we have an update. I haven’t checked for any new releases of Wijmo but hoped we have resolved this calc issue or get an ETA. This is affecting our product and the work around has been a custom function that does what a SUMIF should do natively.
vivek.pannu
Posted 6 January 2023, 9:47 am EST
Hi,
Sorry, but this issue is still under investigation, I have asked the dev team to prioritize this case. I appreciate your patience, we will provide you an update at the earliest.
Regards
curiosichi
Posted 2 February 2023, 12:03 pm EST - Updated 2 February 2023, 12:22 pm EST
Is there an update on this issue?
Our project has found numerics in strings in general seem to break all calcs we’ve tested. And of note, if you manually type a number in the second string field, the field parses the input as a numeric and does calc. So there is an inconsistency in the cell type, where a field we would want to remain string (say a department number entered as 12345) is being converted to 12,345.
https://stackblitz.com/edit/angular-vuqrbd?file=src/app/app.component.ts
The SumIfs issue we opened this thread on especially needs to be addressed though; we have customers and management pressing for an update.
vivek.pannu
Posted 3 February 2023, 5:50 am EST
Hi,
The dev team is considering this issue to be fixed soon and it will be reflected in our next builds. Until then you can use the following workaround to avoid this issue, if it fits your requirements - you can create a custom function to update the cell values by converting them to ‘Number’ dataType from ‘String’ datatype. Please refer to the following updated sample for the same - https://stackblitz.com/edit/angular-8paq2o?file=src/app/app.component.ts
Also, to keep the values in string format, you can manually set the dataType for the column to string. Please refer to the following code snippet -
flex.columns[0].dataType = 'String'; In case, you face any issues, please let us know.
Regards
curiosichi
Posted 6 March 2023, 11:05 pm EST
Has the fix been added to a recent build for us to try out?
Thanks for the update.
vivek.pannu
Posted 7 March 2023, 8:01 am EST
Hi,
We have asked the dev team for an update on this issue. Please rest assured, we will update you with the same as soon as we have a response from the dev team.
Regards
vivek.pannu
Posted 14 March 2023, 2:53 am EST
Hi,
The dev team is working on this issue, and the ETA for this fix is 2023v1-Hotfix
Regards
curiosichi
Posted 27 April 2023, 3:08 pm EST
Is that hotfix going to be a part of the 5.20231.879 release once it passes RC checks?
vivek.pannu
Posted 28 April 2023, 12:58 am EST
Hi,
The current RC build, i.e. 5.20231.879-rc will be merged with Wijmo’s 5.2023v1 build, which will be released in the next few weeks, but due to certain circumstances, your fix will not be added to this build. It will be added in the 5.2023v1-hotFix release, which will be released after the 5.2023v1 build.
Regards
vivek.pannu
Posted 10 May 2023, 12:03 am EST
Hi,
This issue has been fixed in the latest nightly build and will be added in the 5.2023v1-hotFix release. You can confirm it in the following sample - https://stackblitz.com/edit/angular-rjnkfw?file=src/app/app.component.ts
Regards
richard
Posted 19 May 2023, 4:37 pm EST
Hi, for Column B, if i try to create a SUM formula, ‘=SUM(B1:B5)’ , it doesnt work. Even if i get rid of the space in the in the number string, it doesnt work. The SUMIfs works but not the regular SUM function. Let me know if you have questions.
vivek.pannu
Posted 22 May 2023, 9:00 am EST
Hi Richard,
Thank you for informing us about the issue, we have notified the dev team about it and will keep you updated on its progress.
Regards
vivek.pannu
Posted 22 May 2023, 9:00 am EST
Hi Richard,
Thank you for informing us about the issue, we have notified the dev team about it and will keep you updated on its progress.
Regards
vivek.pannu
Posted 25 May 2023, 12:34 am EST
Hi Richard,
The dev team has confirmed that this behavior is by design and will not be changed in the near future. However, you can use the following workaround to avoid this issue - you can create a custom function to update the cell values by converting them to ‘Number’ dataType from ‘String’ datatype.
Please refer to the following sample for a demonstration - https://stackblitz.com/edit/angular-8paq2o?file=src/app/app.component.ts
Regards
