[sc-issues] [Issue 112638] Matrix formulas are not d isplayed properly
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112638 User er changed the following: What|Old value |New value Assigned to|spreadsheet |er --- Additional comments from e...@openoffice.org Thu Jul 8 14:05:15 + 2010 --- Grabbing issue. - 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 112638] Matrix formulas are not d isplayed properly
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=112638
User er changed the following:
What|Old value |New value
Priority|P3|P2
Platform|Unknown |All
Subcomponent|viewing |programming
--- Additional comments from e...@openoffice.org Thu Jul 8 14:04:37 +
2010 ---
I could not reproduce the error to vanish, in DEV300m84 I tried setting all
dates to Italian and to Default (en-US) and recalculate each time, but it didn't
change. However, two values changed once when I forced a recalculation without
changing anything.. This smells like some uninitialized variable somewhere.
Interestingly, when exported to .xls and loaded in Excel also Excel displayed
#VALUE! for every cell in Stat.C:E.
Inspecting the formulas revealed that MONTH($Data.$A$5:$F$303) is the underlying
cause, changing that to MONTH($Data.$A$5:$A$303) to use only column A makes the
calculation work as intended. Using MONTH on a non-numeric value of other
columns produces #VALUE! (since OOo3.2)
However, there's a serious flaw with the matrix initialization of the MONTH
values, one can easily see with the matrix formula {=MONTH($Data.$A$5:$F$303)}
that from the second column on arbitrary values are present, all values should
be #VALUE! and not just a few or arbitrary month numbers. These values change
when forcing a recalculation.
-
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 112638] Matrix formulas are not d isplayed properly
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112638 User regina changed the following: What|Old value |New value CC|''|'regina' Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from reg...@openoffice.org Thu Jul 8 10:30:32 + 2010 --- I see the described error in DEV300m83 with the attached document. No, I do not think, that it is the same problem as 101155. It looks like a problem with the argument of YEAR and MONTH. I see the data in column A on sheet 'Data' in mixed format, some are language Default and some are in language Italian. If I set the language for all cells in column A to Italian, the errors on sheet 'Stat' vanish after a hard recalculate. I think, that it is a bug, because the argument of YEAR is the internal date number and that should be independent of the language of the display format. - 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 112638] Matrix formulas are not d isplayed properly
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112638 --- Additional comments from rem...@openoffice.org Thu Jul 8 07:55:32 + 2010 --- Similar or probably a duplicate of issue 101155 - 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 112638] Matrix formulas are not d isplayed properly
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112638 --- Additional comments from rem...@openoffice.org Fri Jun 25 10:48:47 + 2010 --- 9 time over 10 formula in "Stat" sheet are not displayed properly in Ooo 3.2 - 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 112638] Matrix formulas are not d isplayed properly
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112638 --- Additional comments from rem...@openoffice.org Fri Jun 25 10:45:47 + 2010 --- Created an attachment (id=70217) Example ods file. 9 time over 10 formula in Stat" - 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 112638] Matrix formulas are not d isplayed properly
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112638 --- Additional comments from rem...@openoffice.org Wed Jun 23 18:22:34 + 2010 --- Created an attachment (id=70178) example of matrix formulas not displaying properly - 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 112638] Matrix formulas are not d isplayed properly
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112638 Issue #|112638 Summary|Matrix formulas are not displayed properly Component|Spreadsheet Version|OOO300m1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|viewing Assigned to|spreadsheet Reported by|remo00 --- Additional comments from rem...@openoffice.org Wed Jun 23 18:21:09 + 2010 --- Starting with OOO 3.0 onward I had problems sometimes with matrix formula. >From time to time, some cells containing matrix formula don't display the right result but a #VALUE# with "wrong data type" or simply they do not display anything This is not reproducible, it occurs sometimes inserting and deleting rows, or pressing the Undo button, but not always. I took a screen-shot. of the same file behaving normally and when is not working Note that the formula in D33 in both cases. Workarounds may be: Closing and opening again the file, inserting and deleting rows, but not always The attachment follows - 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
