I use a german Version of LibreOffice scalc 4.2.2.1 Windows 7. I changed recently from OpenOffice 3.0.1 I've got an error 504 when I try =ZEILE('file:///C:/temp/Unbenannt.ods'#$Tabelle1.A2) ("Zeile" means "ROW") or =ISTBEZUG('file:///C:/temp/Unbenannt.ods'#$Tabelle1.A2) ("ISTBEZUG" means "ISREF") in OO 3.0.1 these examples work
Hi Juergen, thanks for reporting. I can reproduce the issue for ROW() functions with: Win7x64Ultimate Version: 4.2.2.1 Build ID: 3be8cda0bddd8e430d8cda1ebfd581265cca5a0f Version: 4.2.5.0.0+ Build ID: cc45204a7a286cef32fc7faf266dc2da235c1ae2 TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-04-17_02:46:49 Version: 4.3.0.0.alpha0+ Build ID: 0ce6d9bcea7c37a7cb2c42e8393e2e20780bd171 TinderBox: Win-x86@39, Branch:master, Time: 2014-04-17_00:11:33 but not for the ISREF() function.
Hi, does this mean, that you get an error for ROW('file:///C:/temp/Unbenannt.ods'#$Tabelle1.A2) but not for isref('file:///C:/temp/Unbenannt.ods'#$Tabelle1.A2) Am 19.04.2014 04:17, schrieb bugzilla-daemon@freedesktop.org: > m.a.riosv <mailto:mariosv@miguelangel.mobi> changed bug 77517 > <https://bugs.freedesktop.org/show_bug.cgi?id=77517> > What Removed Added > Status UNCONFIRMED NEW > CC mariosv@miguelangel.mobi > Ever confirmed 1 > > *Comment # 1 <https://bugs.freedesktop.org/show_bug.cgi?id=77517#c1> > on bug 77517 <https://bugs.freedesktop.org/show_bug.cgi?id=77517> from > m.a.riosv <mailto:mariosv@miguelangel.mobi> * > Hi Juergen, thanks for reporting. > > I can reproduce the issue for ROW() functions with: > Win7x64Ultimate > Version: 4.2.2.1 Build ID: 3be8cda0bddd8e430d8cda1ebfd581265cca5a0f > Version: 4.2.5.0.0+ Build ID: cc45204a7a286cef32fc7faf266dc2da235c1ae2 > TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-04-17_02:46:49 > Version: 4.3.0.0.alpha0+ Build ID: 0ce6d9bcea7c37a7cb2c42e8393e2e20780bd171 > TinderBox: Win-x86@39, Branch:master, Time: 2014-04-17_00:11:33 > > but not for the ISREF() function. > ------------------------------------------------------------------------ > You are receiving this mail because: > > * You reported the bug. > --- Diese E-Mail ist frei von Viren und Malware, denn der avast! Antivirus Schutz ist aktiv. http://www.avast.com
Yes. (Please if you can answer here, or if you answer from your client email program try to avoid reproduce the text)
This is not a critical bug - as we can see - not a lot of dupes, not a lot of users commenting. There is apparently loss of data but it's very specific to external references on Windows platform. It would be nice to know if: 1) This is still a problem with 4.4.3 or newer; 2) Did this ever work correctly? (Please test 3.3 and report back) http://downloadarchive.documentfoundation.org/libreoffice/old/
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.1.5 or 5.2.1 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20160920
Still there at least for ROW() Win10x64 Version: 5.2.2.1 (x64) Build ID: 3c2231d4aa4c68281f28ad35a100c092cff84f5d CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; Locale: es-ES (es_ES); Calc: group
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.4.1 or 5.3.6 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170929
Dear Bartosz, This bug has been in ASSIGNED status for more than 3 months without any activity. Resetting it to NEW. Please assigned it back to yourself if you're still working on this.
@Eike, @Winfried, i thought you could be interested in this issue...
@Winfried: one for you? svExternalSingleRef and svExternalDoubleRef aren't handled in ScInterpreter::ScRow() and ScInterpreter::ScColumn(). Should not be too complicated, obtain the external references as in ScInterpreter::ScOffset() and for svExternalDoubleRef use the calculation of svDoubleRef that creates a matrix.
(In reply to Eike Rathke from comment #10) > @Winfried: one for you? > > svExternalSingleRef and svExternalDoubleRef aren't handled in > ScInterpreter::ScRow() and ScInterpreter::ScColumn(). Should not be too > complicated, obtain the external references as in ScInterpreter::ScOffset() > and for svExternalDoubleRef use the calculation of svDoubleRef that creates > a matrix. Thanks for the pointers ;-) I'll work on it (once I have finished the bug I'm currently working on).
Winfried Donkers committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=b1740fba0d1e6e3d69c3781734509317f42a0e4f tdf#77517 make Calc function ROW accept external references. It will be available in 6.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.
Winfried Donkers committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=28f3e44e99283ede636c28c68bffb2b9df0bbcf8 tdf#77517 make Calc function COLUMN accept external references. It will be available in 6.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.
Winfried Donkers committed a patch related to this issue. It has been pushed to "libreoffice-6-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d5c8199a94d0e2f722fff6637b930205a6641adf&h=libreoffice-6-1 tdf#77517 make Calc function COLUMN accept external references. It will be available in 6.1.0.1. 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.
Winfried Donkers committed a patch related to this issue. It has been pushed to "libreoffice-6-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=ad6bdc81f3b47cc46a7751e93e59fb92edd28baf&h=libreoffice-6-1 tdf#77517 make Calc function ROW accept external references. It will be available in 6.1.0.1. 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.
Winfried Donkers committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=3613990eaae645e0489660be2dab8a61cab8a69c tdf#77517 Additions to unit tests. It will be available in 6.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.