Summary: | Macro Inserting SUM function results in 508 error. | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Don <donny.danger> |
Component: | BASIC | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED NOTABUG | ||
Severity: | normal | ||
Priority: | medium | ||
Version: | 24.2.2.2 release | ||
Hardware: | All | ||
OS: | Windows (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: |
Description
Don
2024-05-01 14:02:35 UTC
This is not a bug. The formula that you define using setFormula must use ODF syntax - it means not only English function names, but also e.g. semicolons as argument separators, not commas. This requirement allows creating macros working independently of current settings. oCell.setFormula("=SUM(B1; B2)") My apologies, I failed to reference the help file, and was only going by the tooltip displayed when inserting a SUM function. I will be more careful in the future. |