https://bugs.freedesktop.org/show_bug.cgi?id=78373
Priority: medium Bug ID: 78373 Assignee: libreoffice-bugs@lists.freedesktop.org Summary: PIVOTTABLE: Some VLOOKUPs return #N/A until pivot refreshed Severity: normal Classification: Unclassified OS: Windows (All) Reporter: libreoffice.org-bugzi...@logicdaemon.ru 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 Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs