https://bugs.documentfoundation.org/show_bug.cgi?id=105414
Bug ID: 105414
Summary: Blank cells formatted as numbers not treated as ZERO
when pulled via VLOOKUP to external file
Product: LibreOffice
Version: 5.2.4.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have a spreadsheet - 'A' that has data entered into it on a regular basis.
The cells this data is entered into are formatted as Number>Currency (with no
decimals).
I have another spreadsheet - 'B' that Management uses that pulls some data from
spreadsheet 'A' using VLOOKUP.
When sorting the Source (A) spreadsheet in descending order, the blank cells
are treated as zeros, so cells with values in them are sorted to the top, and
all blank cells are sorted below them.
But, when I sort the cells in the Management spreadsheet (B), the blank cells
are sorted to the top, above the cells with values in them, and then those with
values are properly sorted in descending order.
I consider this a bug.
Steps to Reproduce:
1. Create a spreadsheet - Source - with two columns, column A that has labels
in it, and column B that has numeric data (formatted as Currency with no
decimals) entered into some of the cells but not all.
2. Create a second spreadsheet - Management - identical to 'Source', but pulls
the data for column B from column B in 'Source' spreadsheet using VLOOKUP on
column A.
3. Sort Source spreadsheet on column B in descending order, note that the blank
cells are treated as zeros, so cells with values in them are sorted to the top,
and all blank cells are sorted below them.
Actual Results:
4. Sort Management spreadsheet the same way, note that the blank cells are
sorted to the top, above the cells with values in them, and then those with
values are properly sorted in descending order.
Expected Results:
The step 4. sort should be identical to the step 3. sort.
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:50.0) Gecko/20100101
Firefox/50.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
