Bug 42745 - Part of fix for bug 40590 not included in 3.4.4. Formulas in defined names messed up again.
Summary: Part of fix for bug 40590 not included in 3.4.4. Formulas in defined names m...
Status: CLOSED DUPLICATE of bug 40590
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.4.4 release
Hardware: x86 (IA32) All
: highest critical
Assignee: Not Assigned
Depends on:
Reported: 2011-11-09 08:01 UTC by Bruce Leary
Modified: 2011-11-14 05:12 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Simple sheet that demonstrates the bug (11.00 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-11-10 18:35 UTC, Bruce Leary

Note You need to log in before you can comment on or make changes to this bug.
Description Bruce Leary 2011-11-09 08:01:11 UTC
Bug 40590 was written against 3.4.3.  When I tested the first fix that was "approved" it did not correct the problem.  A subsequent additional change was made that did fix the problem.  

The secondary problem had something to do with needing to have a second pass to resolve forward reference names.  In other words name "b" referenced name "c" and "c" has not been resolved yet.  Where possible, changing the names such that all references to other names are reverse in collating sequence instead of forward avoids the problem.  In other words, change name "b" to name "d" and the problem is avoided.

The notes on 40590 should be helpful.

I'm going back to 3.4.3.  I cannot understand the poor quality control that exists within the LibreOffice development organization.
Comment 1 Bruce Leary 2011-11-10 18:35:12 UTC
Created attachment 53387 [details]
Simple sheet that demonstrates the bug

This sheet demonstrates the bug.
Comment 2 Eike Rathke 2011-11-14 02:03:21 UTC
Bug 40590 says "fixed in master", that's what it is. The fix was considered too invasive in a review to be cherry-picked to 3-4.

*** This bug has been marked as a duplicate of bug 40590 ***
Comment 3 Bruce Leary 2011-11-14 05:12:02 UTC
This bug has been marked as CLOSED DUPLICATE OF 40590 which in turn says RESOLVED FIXED.  The definitions of those words is subject to interpretation.  As it turns out, the fix will not be included until at least release 3.5.0.  The bug was introduced in 3.4.3.  3.4.2 worked correctly.  3.4.3 created the problem.  The fix is now stated as being too invasive to include in 3.4.4 or 3.4.5.  

Amazing.  They broke it in 3.4.3 but the fix is "too invasive" to be implemented until 3.5.0 at the earliest.  

With this operating philosophy I don't believe that anyone should consider LibreOffice for use in a true production environment if your software maintenance policy embraces the concept of installing incremental fix releases.

See bug 42745 for more.