Re: [Bug 60848] SUMPRODUCT fails when first arg is of form --(...)

2023-10-14 Thread Jakub Vojtíšek
Thanks PJ Fanning and Stanton Fisque for your comments. I must say that for me it would be a sad news if POI withdraws from supporting excel formulas evaluations. The company I work for uses POI for more than 10 years to process excel files. Being able to evaluate excel workbooks in java and have

Re: [Bug 60848] SUMPRODUCT fails when first arg is of form --(...)

2023-10-13 Thread stanton fisque
there is a use case, and i have used it, so i will raise a counter comment for POI to retain running calculations: i had a project where i built a harness to load an excel spreadsheet and then exercise it as a system of record. if POI were to lose the ability to perform that function, it would