https://bugs.documentfoundation.org/show_bug.cgi?id=146722
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|[email protected] |[email protected] |desktop.org | Status|NEW |ASSIGNED --- Comment #5 from Eike Rathke <[email protected]> --- (In reply to TorrAB from comment #4) > (In reply to Eike Rathke from comment #3) > > Automatic labels are fragile > > … but VERY convenient! But not necessarily deterministic and persistent. > > and should be deprecated in the UI option settings > Why? Because their detection depends on data content and arrangement. If later a cell content is added with the same string that is nearer to the formula cell then a recompilation of the formula will yield a different result. > The bug (as explained above) should be easy to fix I love it when people who do not know the code and implications say "should be easy".. > > Best use defined label ranges, > > Sheet -> Named Ranges and Expressions -> Labels... > Yes, but they are clumsy No, they are the correct way to use labels. Anyway, I'll come up with a fix for this situation (no text content above/below and empty cell below and numeric cell to the right leads to a row label), which of course *might* break other uses of the non-deterministic automatic labels where exactly this constellation previously lead to a column label. -- You are receiving this mail because: You are the assignee for the bug.
