Created attachment 75222 [details] Spreadsheet which exposes the problem Here it is how to reproduce the crash: 1) Open attached bug5.ods file 2) Go to sheet B 3) Select cell A1 4) Ctrl+C 5) Open a new spreadsheet 6) Select cell A1 6) Ctrl+V Boom! This cell contains =OFFSET($A.A1;1;0;1;1) It is important, that the reference (first argument) is to locked sheet (locked with $ character), also if we don't go exactly one cell down (argument 2), the crash won't happen, pretty narrow :) Even more, if you don't paste to the very first cell, it won't happen (although the area is much wider if your reference is to column Z). I use up to date Ubuntu 12.10 If there is anything else, which could help, then please let me know.
Created attachment 75223 [details] Backtrace
thank you for reporting this bug, I can reproduce this bug running LibreOffice 4.0.1.1 rc on Mac osx 10.6.8.
I'll take it.
Great job with the back trace. That helps a great deal.
Fixed on master. Backport requests sent: https://gerrit.libreoffice.org/5142 https://gerrit.libreoffice.org/5143
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=8b96cfd6caedbad7b3b79e57421a834f18c5c511 fdo#61201: Don't forget to calculate row offset for external single ref. 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.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=c2a94c283d6d0a82b8960e73c253ecb96c2b8140 fdo#61201: Add test for OFFSET used with external single reference. 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.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=9f2d5c46e372c4337ba04f627c32bac007431eb5&h=libreoffice-4-1 fdo#61201: Don't forget to calculate row offset for external single ref. It will be available in LibreOffice 4.1.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.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=c8fb4f13309ffecbaa72e0108315bb917ea33064&h=libreoffice-4-0 fdo#61201: Don't forget to calculate row offset for external single ref. It will be available in LibreOffice 4.0.5. 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.
Fixed.
Hey, many thanks for fixing this. Calc is now more stable than before.