https://bugs.documentfoundation.org/show_bug.cgi?id=100297
Bug ID: 100297
Summary: API, Calc sheets, Inconsistency concerning changes of
cell properties by a user function.
Product: LibreOffice
Version: 5.1.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: j...@psilosoph.de
Created attachment 125577
--> https://bugs.documentfoundation.org/attachment.cgi?id=125577&action=edit
Demonstration of the problems; Code included
Predecessors of LibO Calc did not allow any changes of the content of a cell by
a function called from a formula contained in a cell of the same sheet. AOO
4.1.2 still is regarding this restriction (as I tested).
LibO relieved this restriction substantially. From my recent tests I found that
changes of all the relevant properties as there are
- Value
- String
- Formula
for cells in the same sheet as the call of the function whose body is
performing the changes are allowed.
This with one exception: Setting the Formula property to "" (empty string)
which should make the cell BLANK (answer TRUE if asked ISBLANK) does not cause
an error, but is not performed. It only works for cells in different sheets.
If the content of a cell in a different sheet is changed by the body of a
function called from a cell not in the active sheet, the recalculation of a
cell in the active sheet referencing the changed cell, is not correctly
triggered.
Generally the behaviour of cells is inconsistent with respect to changes of
contents by the bodies of user functions via the API.
The alternatives I see are to either suppress changes of cells by function
bodies completely, or to thoroughly remove any inconsistencies.
See attached example.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs