https://bugs.freedesktop.org/show_bug.cgi?id=81295
GerardF <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from GerardF <[email protected]> --- This is cause by the cell B1. This cell contains the word "Criterion" and in Tools > Options > LO Calc > Calculate, "Automatically find column and row labels" is checked. When a name is defined with the scpoe "Sheet1", this name can be used only in "Sheet1". So changing the scope to a different sheet have the same effect as deleting this name. This name deleted, Calc search for a Label with the same name and find Criterion in B1. The name in the formula is replaced by the Label 'Criterion' (quote surrounding). And is not reverted when creating again the name. Deleting the word "Criterion" from B1 or (better) uncheck "find labels" in options and the problem is gone. Waiting for another Calc expert opinion to close this bug. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
