Anyone? This one is going to be a real problem if I can't solve it.
Thanks On Fri Jan 13 2017 08:53:29 GMT-0500 (Eastern Standard Time), Tanstaafl <[email protected]> wrote: > 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: [email protected] 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
