Bug 42745

Summary:	Part of fix for bug 40590 not included in 3.4.4. Formulas in defined names messed up again.
Product:	LibreOffice	Reporter:	Bruce Leary <b.bugs.freedesktop>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	CLOSED DUPLICATE
Severity:	critical	CC:	b.bugs.freedesktop
Priority:	highest
Version:	3.4.4 release
Hardware:	x86 (IA32)
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Simple sheet that demonstrates the 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.