CollaboraOnline / online

Collabora Online is a collaborative online office suite based on LibreOffice technology. This is also the source for the Collabora Office apps for iOS and Android.
https://collaboraonline.com
Other
1.83k stars 701 forks source link

Calc: scroll automatically when entering the frozen area when selecting cells (and using autofill) #10269

Open bayramcicek opened 1 week ago

bayramcicek commented 1 week ago

Describe the Bug

On LibreOffice - if we have a frozen row/col in a document; selecting cells starting from the unfrozen area to the frozen area, automatically scrolls the unfrozen area. Online, does not have such behavior (until mouse reaches the top).

Steps to Reproduce

  1. freeze row (or column)
  2. scroll the unfrozen area to down.
  3. select cells in the unfrozen area, and keep select cells through the frozen area.
  4. unfrozen area should scroll automatically (not happening on Online)
  5. then selection should enter the frozen area.

Online does not automatically scrolls the unfrozen area. It directly enters the frozen area. We should first scroll the unfrozen area, and then enter the frozen area. The same goes for when using autofill.

LO (correct behavior)

https://github.com/user-attachments/assets/c3c5ddc3-e538-4fdb-92a4-7491863d72c3

Online (wrong behavior)

https://github.com/user-attachments/assets/7414afd3-58a2-4ccd-ac11-7c00930d6a8b

What we need: On the Online side, scrolling only happens when we reach to the top with cursor (this is also seems buggy). But we should do scroll as soon as we enter the frozen area - we shouldn't wait until mouse reached at the top - as shown in the video recording.

Additional Context

The no-scroll behavior may lead potential/unwanted data loss:

https://github.com/user-attachments/assets/ae3efd10-48f6-450d-977a-badf42e75d23

User may think only selected cells will be deleted, but actually all cells are deleted - including the cells that out of visible area. -> implementing the scroll behavior will also fix this. See the correct behavior on the LibreOffice: (there will be no cells hidden)

https://github.com/user-attachments/assets/5c3fc280-4460-4a36-86d3-22028a36c6aa

bayramcicek commented 1 week ago