| Summary: | FILTER: Multiple entries in AutoFilter with NaN | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Yolanda Andreyeva <yolandaandreyeva> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | minor | CC: | ilmari.lauhakangas, raal |
| Priority: | medium | ||
| Version: | 4.1.0.4 release | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Actual result | ||
Can't repro. In place of NaN, I see 0. Win 7 64-bit Version: 4.4.0.0.alpha1+ Build ID: 8b21b5cbe78945b27525b4ce78ae3d981f90590f TinderBox: Win-x86@39, Branch:master, Time: 2014-11-06_03:55:51 Unable to reproduce with LO 4.3.3, win7. Please test with actual 4.3.x version. If you still see the bug, please attach test document. Closing as worksforme. |
Created attachment 85710 [details] Actual result Steps to reproduce: 1) Run Calc 2) Enter a column of some repeating digits e.g. 1, 2, 3, 4, 1, 2, 3, 4, 1, 2, 3, 4 3) Save it as OpenDocument Spreadsheet (Flat XML) (.fods) (*.fods) 4) Replace 'office:value="4"' with 'office:value=""' in .fods file 5) Open .fods file in Calc You will see the following column: 1, 2, 3, NaN, 1, 2, 3, NaN, 1, 2, 3, NaN 6) Turn AutoFilter on in this column 7) Click on triangle button in the first cell to open filter window 8) Validate filter entries Actual result: Multiple entries for the same digit are present in the filter window. Please find screenshot attached. Expected result: There should be only one entry for each digit. Version: 4.1.0.4 Build ID: 89ea49ddacd9aa532507cbf852f2bb22b1ace28