On Mon Jan 16 2017 18:16:28 GMT-0500 (Eastern Standard Time), m.a.riosv <miguelange...@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+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