Summary: | Entire column A:A / row 1:1 notation should be display instead of A1:A1048576 / A1:AMJ1 | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Óvári <ovari123> |
Component: | Calc | Assignee: | Eike Rathke <erack> |
Status: | RESOLVED FIXED | ||
Severity: | enhancement | CC: | h3734236 |
Priority: | medium | ||
Version: | 5.1.0.0.alpha0+ Master | ||
Hardware: | All | ||
OS: | All | ||
See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=44419 https://bugs.documentfoundation.org/show_bug.cgi?id=92441 https://bugs.documentfoundation.org/show_bug.cgi?id=92439 https://bugs.documentfoundation.org/show_bug.cgi?id=92452 https://bugs.documentfoundation.org/show_bug.cgi?id=92453 https://bugs.documentfoundation.org/show_bug.cgi?id=92426 https://bugs.documentfoundation.org/show_bug.cgi?id=92468 |
||
Whiteboard: | target:5.1.0 target:5.0.0.3 | ||
Crash report or crash signature: | Regression By: |
Description
Óvári
2015-06-29 13:54:21 UTC
The other axis (rows if entire column, columns if entire row) has to have absolute references, so B$1:B$1048576 then it will be converted to B:B Thank you Eike for your comment. Perhaps LibreOffice documentation user documentation could state that: 1. LibreOffice Calc requires absolute reference; and 2. LibreOffice Calc converts to the entire column/row notation differently to Microsoft Excel. Humm.. seeing that Excel converts such reference maybe we should do the same. Thank you Eike for reopening this ticket. Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=0ccefa0cb62da893556893bec2414c22cb2ad7b8 tdf#92427 entire column/row reference also if both sticky parts are relative It will be available in 5.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d2787cde7722dee09ae67e1d6bc9a3501ecc0d56&h=libreoffice-5-0 tdf#92427 entire column/row reference also if both sticky parts are relative It will be available in 5.0.0.3. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=8ed32d8a91dd6df2888dc73d27a453a1b851e448 unit tests for tdf#92427 It will be available in 5.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. |