| Summary: | Defining a named range for complete column or row results in broken expression (Formula syntax = ExcelR1C1) | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Bradley Sepos <bradley> |
| Component: | Calc | Assignee: | Eike Rathke <erack> |
| Status: | VERIFIED FIXED | ||
| Severity: | normal | CC: | h3734236, raal |
| Priority: | medium | ||
| Version: | 5.0.0.0.alpha0+ Master | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | target:5.2.0 target:5.1.3 target:5.0.6 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | named-expression-bugs.ods | ||
|
Description
Bradley Sepos
2016-03-30 17:30:42 UTC
It's excel syntax. Tools > options > Calc > Formula > Formula syntax = ExcelR1C1 I can confirm with Version: 5.2.0.0.alpha0+; win7 select row53 > menu Insert > Name expression > Define create range Budget!R53 This name doesn't work, when I change range to Budget!R53>R53 then name works. Formula syntax =excel A1 : Budget!$53:$53 -> correct Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=3c36ba50f65d663f35264f2a11c99c0ff98674a2 Resolves: tdf#98990 accept R1C1 notation entire column/row references It will be available in 5.2.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. Pending review https://gerrit.libreoffice.org/23842 for 5-1 https://gerrit.libreoffice.org/23843 for 5-0 Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=a4c6fc2c2641d2020cce626877749a22ca10be4b&h=libreoffice-5-1 Resolves: tdf#98990 accept R1C1 notation entire column/row references It will be available in 5.1.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 "libreoffice-5-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7ba918f014f177718664cbd379c6386a7a258c59&h=libreoffice-5-0 Resolves: tdf#98990 accept R1C1 notation entire column/row references It will be available in 5.0.6. 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. Tested the Mac OS X daily build for 2016-04-12. Still failing in Excel R1C1 mode. (In reply to Bradley Sepos from comment #6) > Tested the Mac OS X daily build for 2016-04-12. Still failing in Excel R1C1 > mode. Hello, The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. You tested the build from the day when commit was released .. Please try build from 15.4. Thanks Apologies, I should have double-checked the hash dates. Will test the next build as requested. Appears fixed in the latest 5.1.3 daily builds. Thanks all. Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=8465e99a27168a2c0a62e84b819e9e133f47ddf8 add test for tdf#98990 It will be available in 5.2.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. |