[Libreoffice-ux-advise] [Bug 143962] EDITING range reference should update when edge cell is moved in same column (drag and drop or cut and paste)

[bugzilla-daemon at bugs.documentfoundation.org]

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

Stéphane Guillou (stragu) <stephane.guillou at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|unspecified                 |Inherited From OOo
           Severity|normal                      |enhancement
            Summary|EDITING Address error when  |EDITING range reference
                   |move (drag and drop) a      |should update when edge
                   |range                       |cell is moved in same
                   |                            |column (drag and drop or
                   |                            |cut and paste)
             Blocks|                            |108253
                 CC|                            |erack at redhat.com,
                   |                            |libreoffice-ux-advise at lists
                   |                            |.freedesktop.org,
                   |                            |stephane.guillou at libreoffic
                   |                            |e.org
           See Also|                            |https://bugs.documentfounda
                   |                            |tion.org/show_bug.cgi?id=75
                   |                            |904

--- Comment #5 from Stéphane Guillou (stragu) <stephane.guillou at libreoffice.org> ---
Reproduced in OOo 3.3 and a recent master build.

I can confirm that in Excel 365, following the same steps, the range is
extended in the C10 formula. However, the range is not updated if the cell is
dragged to a different column, or if it is dragged below the original range. So
this seems to only happen in specific, straight-forward cases.

Other apps:
- OnlyOffice does not extend the range, same as LibreOffice
- Gnumeric and Google Sheets extend the range, same as Excel

I consider this as request for enhancement rather than a bug.

Eike and UX team, what are your thoughts on this?

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 002ae41bb6088002ba3ed0188ac822fb823a23f9
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108253
[Bug 108253] [META] Calc cell formula bugs and enhancements
-- 
You are receiving this mail because:
You are on the CC list for the bug.