[Libreoffice-bugs] [Bug 146722] Calc using labels shows errors or wrong results
https://bugs.documentfoundation.org/show_bug.cgi?id=146722 Eike Rathke changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |er...@redhat.com |desktop.org | Status|NEW |ASSIGNED --- Comment #5 from Eike Rathke --- (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.
[Libreoffice-bugs] [Bug 146722] Calc using labels shows errors or wrong results
https://bugs.documentfoundation.org/show_bug.cgi?id=146722 --- Comment #4 from tor...@yahoo.com --- (In reply to Eike Rathke from comment #3) > Automatically finding labels prioritizes on column labels if the next cell > above/below the found label cell does not have text content at the moment > the cell formula is compiled (not interpreted). What happens here is that in > both documents the intersection of the label in 1.A1/2.A2 and the formula > cell in B3 is A3 instead of the expected 1.B1/2.B2. If a numeric value is > entered in A3 in either document it can be observed. > > Automatic labels are fragile … but VERY convenient! and should be deprecated in the UI option settings Why? The bug (as explained above) should be easy to fix Best use defined label ranges, > Sheet -> Named Ranges and Expressions -> Labels... Yes, but they are clumsy -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146722] Calc using labels shows errors or wrong results
https://bugs.documentfoundation.org/show_bug.cgi?id=146722 Eike Rathke changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEW CC||er...@redhat.com Version|7.2.4.1 release |Inherited From OOo --- Comment #3 from Eike Rathke --- Automatically finding labels prioritizes on column labels if the next cell above/below the found label cell does not have text content at the moment the cell formula is compiled (not interpreted). What happens here is that in both documents the intersection of the label in 1.A1/2.A2 and the formula cell in B3 is A3 instead of the expected 1.B1/2.B2. If a numeric value is entered in A3 in either document it can be observed. Automatic labels are fragile (and should be deprecated in the UI option settings). Best use defined label ranges, Sheet -> Named Ranges and Expressions -> Labels... -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146722] Calc using labels shows errors or wrong results
https://bugs.documentfoundation.org/show_bug.cgi?id=146722 --- Comment #2 from tor...@yahoo.com --- Created attachment 177502 --> https://bugs.documentfoundation.org/attachment.cgi?id=177502=edit file with formula -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146722] Calc using labels shows errors or wrong results
https://bugs.documentfoundation.org/show_bug.cgi?id=146722 --- Comment #1 from tor...@yahoo.com --- Created attachment 177501 --> https://bugs.documentfoundation.org/attachment.cgi?id=177501=edit file with formula -- You are receiving this mail because: You are the assignee for the bug.