Created attachment 44131 [details]
screen shot of error
When using a multi-sheet spreadsheet that has a formula on one sheet that retrieves data from another sheet. Using find & replace to make change in cell number will change the case of the sheet's name from uppercase to lowercase causing the formula to fail. I've included a screen shot to help explain what I'm seeing. If you look at the formula bar you will see the sheet name is lowercase. If you look at the tabs at the bottom of the spreadsheet you will see that the sheet name is actually uppercase. Before I do the find & replace, the formula contains uppercase letters for the sheet name. This happens on Windows XP but not in Ubuntu 10.10
Cannot reproduce this in LibreOffice 340 beta5, with simple formula e.g
Could you pls check in this version too?
Also NOT reproducible with own test document and "LibreOffice 3.4.1 - WIN7 Home Premium (64bit) German UI [OOO340m1 (Build:103)]".
Please feel free to reopen this bug if you find out that the problem still exists with the current stable LibreOffice version and if you can contribute requested additional information due to <http://wiki.documentfoundation.org/BugReport> (especially BugReport Details)!
Zdeněk Crhonek committed a patch related to this issue.
It has been pushed to "master":
uitest for bug tdf#35020
It will be available in 6.3.0.
The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.