[sc-issues] [Issue 107451] Validity-Check for cells blocking allowed values!
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107451 User rainerbielefeld changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from rainerbielef...@openoffice.org Mon Dec 7 08:33:59 + 2009 --- @tommyads: Format of existing content will remain until contents will have been modified, pls. see Issue 96274 You can solve your problem by 'copy / paste as unformatted text' after you modified 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 107451] Validity-Check for cells blocking allowed values!
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107451 --- Additional comments from tommy...@openoffice.org Mon Dec 7 07:50:13 + 2009 --- Thanks! Making the format visible is a great function, I like it, did not know this before. But now I have the following problem: reformatting the cells (after marking the whole column C or some of the filled cells) and then trying to reformat those cells to "number" or to "text" does not work! The cells remain in their format, ignoring the reformatting. What is wrong here? Thanks! - 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 107451] Validity-Check for cells blocking allowed values!
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107451 User rainerbielefeld changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |INVALID --- Additional comments from rainerbielef...@openoffice.org Sat Dec 5 11:04:29 + 2009 --- - some problems with my keyboard or my gout fingers today ;-) - 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 107451] Validity-Check for cells blocking allowed values!
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107451 User rainerbielefeld changed the following: What|Old value |New value CC|''|'rainerbielefeld' --- Additional comments from rainerbielef...@openoffice.org Sat Dec 5 11:02:33 + 2009 --- No bug, so INVALID - 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 107451] Validity-Check for cells blocking allowed values!
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=107451
User rainerbielefeld changed the following:
What|Old value |New value
Keywords| |oooqa
--- Additional comments from rainerbielef...@openoffice.org Sat Dec 5
11:01:44 + 2009 ---
Reproducible with "Ooo 3.1.1 WIN XP DE-multilingual version German UI activated
[OOO310m19 (Build 9420)]", but INVALID
Please open sample document and check Menu 'View -> Value Highlighting'! Now in
cell range 'C2:C47' you will see several highlighted numbers and several not
highlighted texts ("27", "28", "26"), and you can see that the highlighted
numbers can be inserted manually into 'C62' (because that cell has formatting
'number'), but you cant insert number "26", because in the validity definition
cell range there only is a text "26". but no number "26".
If you modify formatting of cell 'C63', you will see that there only texts can
be inserted manually, all numbers will be blocked for manual insert.
I agree, that's a little
-
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 107451] Validity-Check for cells blocking allowed values!
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107451 --- Additional comments from tommy...@openoffice.org Fri Dec 4 17:52:36 + 2009 --- Created an attachment (id=66493) Spreadsheet containing the error - 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 107451] Validity-Check for cells blocking allowed values!
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107451 Issue #|107451 Summary|Validity-Check for cells blocking allowed values! Component|Spreadsheet Version|OOO310m19 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|tommyads --- Additional comments from tommy...@openoffice.org Fri Dec 4 17:51:36 + 2009 --- Hi, see attached the calc file. In cell C62 (and also the other cells below) there is a data-validity-check/constraint given (see Daten-Gültigkeit-Kriterien...), using the cell-range $C$2:$C$47 as the range for the valid values. This range contains the value 27, but entering this value in cell C62 yields an "invalid value"-error. Thanks, kr tommyads. - 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
