To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=74625
------- Additional comments from [EMAIL PROTECTED] Mon Feb 19 18:19:27 +0000
2007 -------
1. Well, it is good to know that the work has started. Though, I cannot agree,
that when moving data around, there should be NO warning IF something messy will
happen.
Maybe ERROR is to much, BUT at least a warning message that some formulas could
get broken. Calc does NOT do really nasty things (as breaking the matrix into
non-contiguous matrices), BUT the formulas are still broken.
I will attach a *Test Sheet* demonstrating this behavior. Perform the steps as
described in the sheet 'Initial'. After Cut/Transpose/Paste, the formula inside
A19 is NOT updated. This is BETTER so, BUT the user has NO clue that this
*formula is probably wrong.*
2. LOOKUP
======
Well, this is another problem.
Lets say we have the following formula:
= VLOOKUP('a_cell_NOT_really_important'; A1:B10; 2)
and we cut/transpose/paste A1:B10 (pasting into A1 for convenience, BUT because
of previous error I used a different cell inside the test sheet);
The new range becomes A1:J2. The problem is, VLOOKUP() searched inside A1:A10
for first value, and NOW it searches inside A1:A2, because it is still
VLOOKUP(). Something very wrong has happened. It should search inside A1:J1, BUT
this is a horizontal search AND NOT a vertical one, so HLOOKUP() should be used.
So, while Calc updates the formula, this becomes a total MESS. LOOKUP()
functions won't be able to search anymore, BECAUSE the range was TRANSPOSED, BUT
the range is NOT suited for the corresponding LOOKUP. By virtue of the
*transposition*, what was vertical becomes horizontal AND what was horizontal
becomes vertical.
This error applies ALWAYS (always reproducible) when the transposed range is the
2nd argument of the LOOKUP function!
So, my belief is that a correct formula update should update the function, too.
---------------------------------------------------------------------
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]
