Re: [libreoffice-users] Calc - blank cell not treated as 0 in formula when referenced from external file/sheet

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
<tanstaafl@libertytrek.org> 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: users+unsubscribe@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