| Summary: | EDITING: Wrong sorting if complicated formulas (Sorting is correct, but wrong numbers appear) | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | mmedek |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | miguelangelrv |
| Priority: | medium | ||
| Version: | 4.1.2.3 release | ||
| Hardware: | Other | ||
| OS: | Windows (All) | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | On first sheet unsorted data, on second sheet sorted data by column q (in range b4-r21) - strange result in cell y13 (q13) - on third sheet | ||
Hi mmedek, thanks for reporting. Please try if hard recalc [Shift+Ctrl+F0] solves the issue. (In reply to comment #1) > Hi mmedek, thanks for reporting. > > Please try if hard recalc [Shift+Ctrl+F0] solves the issue. Yes, ctrl+shift+F9 solved the issue - mmedek Some functions need a hard recalc to be updated, e.g. NOW(), |
Created attachment 87527 [details] On first sheet unsorted data, on second sheet sorted data by column q (in range b4-r21) - strange result in cell y13 (q13) - on third sheet In attached file I tried to count 4 best results of 6 tournaments, but if some "unplayed" cells were empty, numbers from others rows appeared in my "assistant column" when sorting. But after save and reopen correct results appear. So I have taken shot of screen and inserted it into sheet 3. Operating System: Windows (other) Version: 4.1.2.3 rc