Apache OpenOffice (AOO) Bugzilla – Issue 96966
Lotus Multisheet workbooks only having the first sheet imported
Last modified: 2013-08-08 09:16:16 UTC
I am begining to migrate to OO and have found several Lotus multisheet worksheets where only the first sheet contains data after opeing in OO spreadsheet. This breaks the lookups on the first sheet since the areas containing the data being looked up is on the other sheets. I posted a question about it to the user community and a could of others tried to load one of these problem spreadsheets under their OO and had the same problem. These sheets demonstrate not problem in Lotus itself, just in OO spreadsheet. I can provide a zipped copy of the spreadsheet if needed.
Created attachment 58566 [details] zipped copy of the first spreadsheet where the problem was found
Crash when opening attachment. Rev. 1507307 Win 7 Only World sheet in 2.4.3 (Trade Partners and lookups sheets empty)