Scratch this... I actually decided to go ahead and create these for anyone who asked, but discovered these work as expected.
So, it must have something to do with the VLOOKUP I'm using. I'm working on recreating these, and will follow-up once I'm done. That said, if anyone knows how to use relative references to external spreadsheets (meaning, the reference assumes the referenced spreadsheet is in the same location/directory as the one calling it), I'd be most appreciative. On Tue Jan 17 2017 12:26:26 GMT-0500 (Eastern Standard Time), Tanstaafl <[email protected]> wrote: > On Mon Jan 16 2017 18:16:28 GMT-0500 (Eastern Standard Time), m.a.riosv > <[email protected]> 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: [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
