https://bugs.documentfoundation.org/show_bug.cgi?id=167886
Bug ID: 167886
Summary: Add a method to calculate formula values without
making changes to the document
Product: LibreOffice
Version: 25.2.4.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
The need to calculate an arbitrary formula without making changes to the
document arises quite often.
I suggest adding the following method to some interface of the SheetCell
(https://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1sheet_1_1SheetCell.html)
service.
any computeFormula(string aFormula)
returns the result of aFormula (double, string, void (?) if error).
The proposed method is similar to the Worksheet.Evaluate
(https://learn.microsoft.com/en-us/office/vba/api/excel.worksheet.evaluate) MS
Excel method and has, in my opinion, a much clearer description.
--
You are receiving this mail because:
You are the assignee for the bug.
