Summary: | Converting formulae to entire row and entire column when limit exceeds bounds | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Óvári <ovari123> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | CLOSED DUPLICATE | ||
Severity: | normal | CC: | jalojo |
Priority: | medium | ||
Version: | 5.0.0.3 rc | ||
Hardware: | Other | ||
OS: | All | ||
See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=44419 https://bugs.documentfoundation.org/show_bug.cgi?id=92759 https://bugs.documentfoundation.org/show_bug.cgi?id=92779 |
||
Whiteboard: | |||
Crash report or crash signature: | Regression By: |
Description
Óvári
2015-07-15 04:19:58 UTC
Hi Óvári, I confirm with LO 5.0.0.3 Build ID: f79b5ba13f5e6cbad23f8038060e556217e66632 Windows 7 Home Premium That's normal behaviour and always was the case. Inserting 4 rows will shift the reference end row beyond 1048576 (i.e. 1048577). There's no automatic conversion to $B:B in between and should not be. *** Bug 92759 has been marked as a duplicate of this bug. *** Thank you Eike for your comment. Perhaps LibreOffice (LO) documentation user documentation could state that: 1. LO Calc operates differently to MS Excel as it does not have automatic conversion to absolute/relative entire row/column; and 2. LO Calc produces an #REF! error, while MS Excel converts the range to absolute/relative entire row/column notation. |