[Libreoffice-bugs] [Bug 141495] CONFIGURATION = EOMONTH function corruption
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Sun Apr 25 09:56:36 UTC 2021
https://bugs.documentfoundation.org/show_bug.cgi?id=141495
--- Comment #7 from john.warton at virgin.net <john.warton at virgin.net> ---
Having just reopened the spreadsheet that had the problem and that I had edited
to correct, the same problem has appeared i.e. the eomonth function string has
changed to "com.sun.star.sheet.addin.analysis.geteomonth" (the full expression
is
"=AVERAGE(H46:H64)*(1.005^((DAY(com.sun.star.sheet.addin.analysis.geteomonth(B45,-1))/365))-1)").
I am going to try opening in Excel, resaving and then reopening in CALC to see
if the file is corrupted and CALC is unable to resolve the corruption.... will
report back when done
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210425/659ea40d/attachment.htm>
More information about the Libreoffice-bugs
mailing list