[sc-issues] [Issue 101155] Insertion of lines corrup ts matrix
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101155 User regina changed the following: What|Old value |New value CC|''|'regina' --- Additional comments from reg...@openoffice.org Thu Jul 8 10:32:26 + 2010 --- cc me. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 101155] Insertion of lines corrup ts matrix
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101155 --- Additional comments from reg...@openoffice.org Thu Jul 8 10:00:08 + 2010 --- I have similar problems with matrices (issue 106162), but cannot produce a scenario, where it fails always. My suspicion is, that it is connected to using names for ranges. Are there any names involved in your case? - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 101155] Insertion of lines corrup ts matrix
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101155 --- Additional comments from marten...@openoffice.org Fri Apr 17 09:52:27 + 2009 --- Created an attachment (id=61627) A matrix missing the first element at M120 - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 101155] Insertion of lines corrup ts matrix
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=101155
Issue #|101155
Summary|Insertion of lines corrupts matrix
Component|Spreadsheet
Version|OOo 3.0.1
Platform|PC
URL|
OS/Version|Windows Vista
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|code
Assigned to|spreadsheet
Reported by|martenjan
--- Additional comments from marten...@openoffice.org Fri Apr 17 09:49:57
+ 2009 ---
* description: see summary
* reproducability: difficult
* solution: work-around
PROBLEM DESCRIPTION
My sheet contains several matrix multiplications. After inserting or deleting
lines above, the first element disappears, and depending calculations corrupt.
Moving matrices around by cutting and pasting it to a the new location also may
make the first element disappear in dependent matrices.
In the screenshot, M120:P123 is such a matrix, where M120 disappeared. The
depending matrix S143:Z146 now displays #VALUE.
The corrupted matrices are always given by matrix formulas, in the current case
{M120:P123}={=MINVERSE(M110:P113)}
The curly brackets are the consequence of using ctrl-shift-enter for applying
the matrix formula.
REPRODUCABILITY
Although I encounter this bug quite regularly, I cannot reproduce it at will,
making it hard to track down the cause, or to provide an stripped down example.
The bug occurs in several different files. The corrupted matrix defies a
recalculation attempt (F9), and also defies a save document - exit Open Office -
reload document cycle. I use the Quickstarter, so I am not sure whether a faulty
states persists in memory.
WORK AROUND
Two techniques have been applied successfully to repair the corrupt matrix:
* Pressing `Undo' until the corrupted matrix is restored in correct form, and
then `Redo' to undo your undoings. One should expect the bug to occur again, but
it doesn't, which is one of the reasons I have a problem with reproducability
* Cutting and pasting the corrupted matrix in the same location: Select the
corrupt matrix, and execute the ctrl-X ctrl-V sequence.
-
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: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
