https://bugs.freedesktop.org/show_bug.cgi?id=83067
Priority: medium
Bug ID: 83067
Assignee: [email protected]
Summary: Sort broken when using functions NOW, TODAY, INFO and
RAND
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.4.0.0.alpha0+ Master
Component: Spreadsheet
Product: LibreOffice
Created attachment 105245
--> https://bugs.freedesktop.org/attachment.cgi?id=105245&action=edit
Test file to sort on column A. Columns B and C should remain equal
Description: Sorting when cells contain one of these special functions and some
internal relative references will mixed references.
Steps to reproduce:
1. Open attached document which contains:
column A some dates
column B formula =YEARS($A2;NOW();0)
column C formula =YEARS($A2;$E$1;0) same formula with same result, but
NOW() has been replaced by absolute reference to E1 which contains formula
=NOW()
2. Select data A1:C5
3. Click on "Sort Ascending" button
Expected result:
Column B and C should be sorted the same way, and references in formula should
remain with the same row number
Actual result:
Column C is correctly sorted, but column B is mixed because references are
modified to reflect the new position of the cells.
Same bug with other functions: TODAY(), RAND() and INFO(). No problem with many
other functions. The bug appears if formulas use one of these functions (which
seem to need to communicate with the system).
Test made on Win 7 with Version: 4.3.2.0.0+
Build ID: 02bcf0d5abff100289d01c29eee2ed0685eb64ca
TinderBox: Win-x86@42, Branch:libreoffice-4-3, Time: 2014-08-23_08:23:00
which contains correction for bug 79441
Bug also reproduce with previous versions:
- Version: 4.4.0.0.alpha0+
Build ID: ad85ce18d3939170e5ef7b1a1f8e5dda2c8aeb9c
TinderBox: Win-x86@39, Branch:master, Time: 2014-08-11_05:21:44
- Version: 4.3.1.1
Build ID: c4b15cd4d00dec6b266fa830b4ba73e31ae6ce73
- Version: 4.2.7.0.0+
Build ID: 8de2e9b4bc53e6c097897142bad223c100d36292
TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-08-08_21:42:21
- Version: 4.2.7.0.0+
Build ID: 352a728ffbe171ea6f9f8e93e143fa24198d8271
TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-08-25_10:03:12
NOT reproduce with versions:
- Version: 4.1.6.2
Build ID: 40ff705089295be5be0aae9b15123f687c05b0a
- Version: 4.2.6.2
Build ID: 185f2ce4dcc34af9bd97dec29e6d42c39557298f
- Version: 4.3.0.4
Build ID: 62ad5818884a2fc2e5780dd45466868d41009ec0
--
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
