https://bugs.documentfoundation.org/show_bug.cgi?id=78929
LeMoyne Castle <lemoyne.cas...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |NEW
Resolution|WORKSFORME |---
--- Comment #10 from LeMoyne Castle <lemoyne.cas...@gmail.com> ---
Setting back to NEW because SetFormula() and Formula property should work.
expected: setFormula should work for the functions from the 'built-in' Analysis
Add-In the same way the native calc functions work.
actual: calc 'built-in' Analysis Add-In functions placed on sheet in Basic with
oCall.setFormula(<str>) require modification in calc ui in order to compile and
work correctly. So far, setFormula has failed for *every* Analysis AddIn
function I have tried (see dup Bug#82610).
Additionally, localization or special syntax may be required to get some calc
functions to work in setFormula (even native funcs? -- h/t Jacques Guilleron).
-----
It is tempting to go with resolved+workaround because oCell.FormulaLocal =
"dec2hex(A1)" does work. However, I'm not sure FormulaLocal is in the
published API (maybe I just didn't find it). Besides, setFormula(<fstr>) and
Formula = <fstr> should simply work without the user needing to edit the cell
in calc.
Additionally, want to make sure can access other functions that should(?) be
available in calc: e.g. Basic library.module.functions that are both placed on
sheet and called from sheet through the scripting interface.
-----
Thanks Kaya for the workaround (use FormulaLocal) and thanks to Ewald for the
multi-page initial report, and again, a tip of the hat to Jacques Guilleron.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
