[sc-issues] [Issue 84748] Wrong calculation with col oured values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84748 User volkerme changed the following: What|Old value |New value Component|de|Spreadsheet QA contact|[EMAIL PROTECTED] |[EMAIL PROTECTED] Summary|Falsche Zellberechnung in |Wrong calculation with col |Calc bei verschiedenfarbig|oured values |en Zellwerten | Subcomponent|www |formatting --- Additional comments from [EMAIL PROTECTED] Wed Dec 19 11:31:57 + 2007 --- Translating summary, changing component. - 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]
[sc-issues] [Issue 84748] Wrong calculation with col oured values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84748 User volkerme changed the following: What|Old value |New value Assigned to|[EMAIL PROTECTED] |spreadsheet --- Additional comments from [EMAIL PROTECTED] Wed Dec 19 11:34:13 + 2007 --- Can confirm with OOo 2.3.1 - WinXP The coloured value in the example is misinterpreted. Reassigning. - 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]
[sc-issues] [Issue 84748] Wrong calculation with col oured values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84748 User cloph changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |INVALID --- Additional comments from [EMAIL PROTECTED] Wed Dec 19 12:55:26 + 2007 --- invalid. The colored one is interpreted as text. Strong hint for that is that it is left-aligned, not right aligned. If you want be sure, just check with the formula =ISTTEXT(E1) Text is treated as 0 and according to the interval settings in tools|Options → OOo → General Interpret two digit years as ... will be treated as 2000 If you change the interval to go from e.g. 1850, the combined date will be treated as 1900. Solution: Convert the date to a number first (encapsulate it as WERT(E1)) - 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]
[sc-issues] [Issue 84748] Wrong calculation with col oured values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84748 User cloph changed the following: What|Old value |New value CC|''|'cloph' Status|RESOLVED |CLOSED --- Additional comments from [EMAIL PROTECTED] Wed Dec 19 12:59:15 + 2007 --- invalid. Text != number and thus the date function doesn't malfunction. closing 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]