https://bugs.freedesktop.org/show_bug.cgi?id=85215
Bug ID: 85215
Summary: Sorting a column of linked formula gives Error 523
Product: LibreOffice
Version: 4.4.0.0.alpha0+ Master
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: critical
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
There is something incomplete or broken in the UpdateReferenceOnSort option
that make sorting not working in the following case. It is a regression from
version 4.2.6.3 and all previous versions of LibreOffice and OpenOffice.org :
Steps to reproduce with master and LibreOffice 4.3.4.0.0+ :
1/ open attachment 104016 from bug 81633
2/ make sure that the hidden option /org.openoffice.Office.Calc/input
UpdateReferenceOnSort is kept to its default value false. To do that go to
Tools > Options > LibreOffice > Advanced > Expert configuration
3/ click on A1 and go to menu Data > Sort
4/ in Option tab select The range contains column labels
5/ go back to Sort criteria tab and choose "Date" ascending as Sort key 1
6/ click OK button
Result: Err:523 (Calculation does not converge) in range D3:E6
Same problem in LO 4.4.0.0.alpha1+
Build ID for 4.3: f9050536650835b776b9aa022ae1b47315cd5e14
Build ID for 4.4: c60872984e78511c621ae76ed28ba6338b6d3a68
both built at home under Ubuntu 14.04 x86-64.
Best regards. JBF
--
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
