[Libreoffice-ux-advise] [Bug 126189] New: Enhance autofill to better sense data blocks with empty cells or columns

classic Classic list List threaded Threaded
6 messages Options
bugzilla-daemon-2 bugzilla-daemon-2
Reply | Threaded
Open this post in threaded view
|

[Libreoffice-ux-advise] [Bug 126189] New: Enhance autofill to better sense data blocks with empty cells or columns

https://bugs.documentfoundation.org/show_bug.cgi?id=126189

            Bug ID: 126189
           Summary: Enhance autofill to better sense data blocks with
                    empty cells or columns
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
               URL: https://help.libreoffice.org/6.4/en-US/text/scalc/guid
                    e/calc_series.html?DbPAR=CALC#bm_id3150769
                OS: All
            Status: UNCONFIRMED
          Keywords: needsUXEval
          Severity: enhancement
          Priority: low
         Component: Calc
          Assignee: [hidden email]
          Reporter: [hidden email]
                CC: [hidden email]

This is an enhancement request for autofill to better sense data blocks with
double click, as seen in MSO since 2013.
See examples in ODS attachment 152498.

Double click on H1 fills up to H2, because previous column has some empty
cells,  instead of up to H10.
Double click on M1 doesn’t fill to M10, because previous column is empty.

--
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Libreoffice-ux-advise mailing list
[hidden email]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
bugzilla-daemon-2 bugzilla-daemon-2
Reply | Threaded
Open this post in threaded view
|

[Libreoffice-ux-advise] [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 <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1
                 CC|                            |[hidden email]

--- Comment #1 from Jacques Guilleron <[hidden email]> ---
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 on the CC list for the bug.
_______________________________________________
Libreoffice-ux-advise mailing list
[hidden email]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
bugzilla-daemon-2 bugzilla-daemon-2
Reply | Threaded
Open this post in threaded view
|

[Libreoffice-ux-advise] [Bug 126189] Enhance autofill to better sense data blocks with empty cells or columns

In reply to this post by bugzilla-daemon-2
https://bugs.documentfoundation.org/show_bug.cgi?id=126189

V Stuart Foote <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email],
                   |                            |[hidden email],
                   |                            |[hidden email]
           See Also|                            |https://bugs.documentfounda
                   |                            |tion.org/show_bug.cgi?id=66
                   |                            |890
             Blocks|                            |113499

--- Comment #2 from V Stuart Foote <[hidden email]> ---
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 on the CC list for the bug.
_______________________________________________
Libreoffice-ux-advise mailing list
[hidden email]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
bugzilla-daemon-2 bugzilla-daemon-2
Reply | Threaded
Open this post in threaded view
|

[Libreoffice-ux-advise] [Bug 126189] Enhance autofill to better sense data blocks with empty cells or columns

In reply to this post by bugzilla-daemon-2
https://bugs.documentfoundation.org/show_bug.cgi?id=126189

--- Comment #3 from Timur <[hidden email]> ---
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 on the CC list for the bug.
_______________________________________________
Libreoffice-ux-advise mailing list
[hidden email]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
bugzilla-daemon-2 bugzilla-daemon-2
Reply | Threaded
Open this post in threaded view
|

[Libreoffice-ux-advise] [Bug 126189] Enhance autofill to better sense data blocks with empty cells or columns

In reply to this post by bugzilla-daemon-2
https://bugs.documentfoundation.org/show_bug.cgi?id=126189

--- Comment #4 from Heiko Tietze <[hidden email]> ---
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 on the CC list for the bug.
_______________________________________________
Libreoffice-ux-advise mailing list
[hidden email]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
bugzilla-daemon-2 bugzilla-daemon-2
Reply | Threaded
Open this post in threaded view
|

[Libreoffice-ux-advise] [Bug 126189] Enhance autofill to better sense data blocks with empty cells or columns

In reply to this post by bugzilla-daemon-2
https://bugs.documentfoundation.org/show_bug.cgi?id=126189

--- Comment #5 from Eike Rathke <[hidden email]> ---
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 on the CC list for the bug.
_______________________________________________
Libreoffice-ux-advise mailing list
[hidden email]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise