Hello, Before I go open a bug for this, would appreciate if someone could confirm.
Using 5.2.3 on Windows 7 x64... I have a spreadsheet - call it 'A' - with 9 sheets in it, and lots of formulas/references between the sheets. These all work fine and have for a very long time. I am working on a new spreadsheet - call it 'B' - that will have a very similar master sheet that will pull from spreadsheet 'A'. Since the only sheet in this new spreadsheet will be very similar to the main sheet on spreadsheet 'A', I started with a copy of 'A', then deleted all of the sheets I wouldn't need except the one I will be pulling data from. the plan was to get the formulas (math formulas) working with sheet references first, then once they were working, change the sheet reference to the external reference. Everything went as planned, with one exception. Some of the cells are blank on the sheet being pulled from. The formulas correctly interpreted the blank cells as zeros while I was using sheet references. But when I changed these to reference the exact same cell, but in the other spreadsheet 'A', I got the '#VALUE!' error. Is this an expected difference when referencing an external file/sheet? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
