To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73766
------- Additional comments from [email protected] Sun Apr 19 12:50:08 +0000 2009 ------- There are two different bugs although related: FIRS BUG: Absolute reference to a cell turning into a reference to a range. Try this: B1 = $A$1 + A2, then, if to copy B1 to B2, B2 = $A$1 + A3, the correct beheavior. If you want B2 = $A$2 + A3 you can either edit the formula by typing or while editing it, drag the colored A1 cell to A2. But, and this is the bug, OOo changes it to the range $A$2:A2, then B2 = $A$2:A2 + A3. There is noting wrong with the result of B2 as the range starts and ends in the same cell, but if it gets copied, say to B3, the formula will no be as intended (B3 = $A$2 + A4) but B3 = $A$2:A3 + A4, which by way of how OOo handles ranges in a formula is equivalent to B3 = A3 + A4. SECOND BUG: Absolute reference to a cell turning into a reference to an absolute range. The process is the same as the first bug, but in some cases that I can't replicate every time, the range reference is absolute in the starting and ending cells. I am using OOo 3.0.1 in windows. Will it ever get solved? It is the 4th most voted defect in the spreadsheet component and 37th overall. I am tired of this and this is my last comment on this bug. We users keep talking about it. Every one can replicate de basic form of the bug. It gives WRONG results. It is almost impossible to verify in a large and complex spreadsheet. IT WAS NOT PRESENT in older versions of OOo. The OOo team keeps changing the target milestone and now it is not even a specific one. It is not assigned to anyone. Developers DO NOT pay attention to users no matter the 17 votes it has. It seems to me that OpenOffice will never be a trusty application. It is more of a showcase for opensource advocates (SUN and IBM included) that need to prove that a good and large application can be developed? --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
