Ok, I created two basic spreadsheets that demonstrate the problem, but you'll have to adjust the formula for the file location on your computer - unless someone can tell me how to make it just a relative reference that assumes the called document is in the same location as the one calling it.
On Tue Jan 17 2017 12:46:05 GMT-0500 (Eastern Standard Time), Tanstaafl <[email protected]> wrote: > 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
