Date: prev next · Thread: first prev next last
2017 Archives by date, by thread · List index


Guess it would help to attach the files...


On Tue Jan 17 2017 13:01:13 GMT-0500 (Eastern Standard Time), Tanstaafl
<tanstaafl@libertytrek.org> wrote:
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
<tanstaafl@libertytrek.org> 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
<tanstaafl@libertytrek.org> wrote:
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.