[Libreoffice-bugs] [Bug 126189] Enhance autofill to better sense data blocks with empty cells or columns
https://bugs.documentfoundation.org/show_bug.cgi?id=126189 Heiko Tietze changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||7731 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 126189] Enhance autofill to better sense data blocks with empty cells or columns
https://bugs.documentfoundation.org/show_bug.cgi?id=126189 --- Comment #9 from Timur --- Created attachment 153702 --> https://bugs.documentfoundation.org/attachment.cgi?id=153702=edit Autofill test ODS Au lieu of attachment 152498, I attach ODS with all those examples. -- 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
[Libreoffice-bugs] [Bug 126189] Enhance autofill to better sense data blocks with empty cells or columns
https://bugs.documentfoundation.org/show_bug.cgi?id=126189 --- Comment #8 from Heiko Tietze --- (In reply to Eike Rathke from comment #7) > What does it do if A1 is empty... It's filled from C1:C4 > And what if B1 is empty instead? No cells are filled in this case. So the rule is: a) left (or right) is filled at the starting cell and b1) left (or right) and one more column has a value. A B C D 1 x 2 3 4 5 6 is filled from C1:C6. Tested with more columns and it works as well unless there is a gap. So A B C D 1 2 3 4 5 is just filled from C1:C2. -- 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
[Libreoffice-bugs] [Bug 126189] Enhance autofill to better sense data blocks with empty cells or columns
https://bugs.documentfoundation.org/show_bug.cgi?id=126189 --- Comment #7 from Eike Rathke --- Thanks for checking. What does it do if A1 is empty (assuming that we start filling with value x that is missing in your context/layout) A B C 5 x 2 6 3 7 4 8 And what if B1 is empty instead? A B C 1 x 2 6 3 7 4 8 -- 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
[Libreoffice-bugs] [Bug 126189] Enhance autofill to better sense data blocks with empty cells or columns
https://bugs.documentfoundation.org/show_bug.cgi?id=126189 Heiko Tietze changed: What|Removed |Added CC|libreoffice-ux-advise@lists |heiko.tietze@documentfounda |.freedesktop.org|tion.org Keywords|needsUXEval | --- Comment #6 from Heiko Tietze --- Double-checked MSO and the logic is simple: fill if either the left cell has content or the cell next to it (and as Eike mentioned right when left is empty). This would be filled from C1:C4 (3 7): A B C 1 5 2 6 3 7 4 8 -- 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
[Libreoffice-bugs] [Bug 126189] Enhance autofill to better sense data blocks with empty cells or columns
https://bugs.documentfoundation.org/show_bug.cgi?id=126189 --- Comment #5 from Eike Rathke --- Just for completeness: if there is no data immediately to the left then autofill looks for data immediately to the right. -- 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
[Libreoffice-bugs] [Bug 126189] Enhance autofill to better sense data blocks with empty cells or columns
https://bugs.documentfoundation.org/show_bug.cgi?id=126189 --- Comment #4 from Heiko Tietze --- Right now the autofill functions works transparently on the left column and fills data until the next empty cell (great example, btw). Any modification to this logic makes it hard to understand. For example, "if left column is empty take the next" or "if only one cell is empty take the next down". Users will not understand the logic behind. My take is WFM. -- 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
[Libreoffice-bugs] [Bug 126189] Enhance autofill to better sense data blocks with empty cells or columns
https://bugs.documentfoundation.org/show_bug.cgi?id=126189 --- Comment #3 from Timur --- I don't think this enhancement is related to bug 66890 nor that it jeopardizes user sheet data. Per attached example, it simply better fill empty cells. Enhancements like this one are better to have because they can be done sometimes and they can be found as noted, in case someone searches. They are still at Low. -- 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
[Libreoffice-bugs] [Bug 126189] Enhance autofill to better sense data blocks with empty cells or columns
https://bugs.documentfoundation.org/show_bug.cgi?id=126189 V Stuart Foote changed: What|Removed |Added CC||er...@redhat.com, ||libreoff...@kohei.us, ||vstuart.fo...@utsa.edu See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=66 ||890 Blocks||113499 --- Comment #2 from V Stuart Foote --- While I can agree the autofill logic and its behavior handling empty cells needs consistency--and so requires ongoing review--it is not clear this "enhancement" (nor that of bug 66890) is merited to try to match MS Office 2013 (or later) nor any other spreadsheet offering. IIUC it would require rework of what has been functional autofill logic inherited from OOo, that while conservative protects user sheet data. Since from the LO perspective, we already do the correct thing, no need to chase other implementations. IMHO => WF Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=113499 [Bug 113499] [META] AutoFill bugs and enhancements -- 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
[Libreoffice-bugs] [Bug 126189] Enhance autofill to better sense data blocks with empty cells or columns
https://bugs.documentfoundation.org/show_bug.cgi?id=126189 Jacques Guilleron changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 CC||jal...@laposte.net --- Comment #1 from Jacques Guilleron --- Hi Timur, Can't verify in Excel, I have 2010 version, but I agree this enhancement. Jacques -- 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