https://bugs.freedesktop.org/show_bug.cgi?id=78373
Priority: medium
Bug ID: 78373
Assignee: [email protected]
Summary: PIVOTTABLE: Some VLOOKUPs return #N/A until pivot
refreshed
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.2.4.1 rc
Component: Spreadsheet
Product: LibreOffice
Created attachment 98600
--> https://bugs.freedesktop.org/attachment.cgi?id=98600&action=edit
sample spreadsheet to reproduce error
Problem description: out of 3 almost identical VLOOKUPs (only cell indexes
different by offset), one returns #N/A despite all values are there. Values
searched are static, not pivot results (in this case), but search area
partially covers pivot.
Steps to reproduce:
1. Open attached spreadsheet
2. Refresh Pivot table (RMB in A2, Refresh). Note row 15 values changed.
3. (optionally) Save, Reload (File → Reload)
Current behavior:
See #N/A in row 15 of 1st sheet.
But no NA in 13 and 14, despite formulas there are similar. Exact values don't
matter, I filled error row with numbers, but originally it was empty.
Very strange thing: if I reset formatting of row 15, bad effect goes away.
Expected behavior:
Correct values on open.
Same in 4.2.5.0.0+ Build ID: b26b9606efa30c0a44e20dcf638fbd1e27f05089
TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-05-06_06:43:43
4.1.6.2 also works well.
Operating System: Windows XP
Version: 4.2.4.1 rc
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
