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

On Mon Jan 16 2017 18:16:28 GMT-0500 (Eastern Standard Time), m.a.riosv
<miguelangelrv@libreoffice.org> wrote:
> Please could you share sample files to test?

I can't share the specific files, they contain sensitive financial
information.

But it should be easy to recreate...

Create two spreadsheets, 'A' and 'B'

Define column A in spreadsheet 'A' as Number/Currency, enter some
numbers in column A

Define column A in spreadsheet 'B' as Number/Currency, define formula to
reference column A in spreadsheet 'A', fill down to include rows in
spreadsheet 'A' with nothing in them

Sort column A in spreadsheet 'B' in descending order

Note that all of the blank cells are sorted ABOVE the ones with values,
when they should be sorted BELOW (treated as zeros, so less than any non
blank/zero value).

Sorting the same rows directly in spreadsheet 'A' puts the empty cells
BELOW the cells with values

-- 
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