[sc-issues] [Issue 80318] Data range validity : perc ent and date format not respected in the list
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80318 User mgalmard changed the following: What|Old value |New value CC|'baumux,camillem,huw' |'baumux,camillem,huw,mgalm | |ard' - 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 80318] Data range validity : perc ent and date format not respected in the list
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80318 User baumux changed the following: What|Old value |New value CC|'camillem,huw'|'baumux,camillem,huw' - 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 80318] Data range validity : perc ent and date format not respected in the list
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80318 --- Additional comments from j...@openoffice.org Mon Jul 6 15:50:09 + 2009 --- Issue 97857 has a patch that looks like it should fix the portion of this issue that deals with date values. - 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 80318] Data range validity : perc ent and date format not respected in the list
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80318 User camillem changed the following: What|Old value |New value CC|'huw' |'camillem,huw' - 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 80318] Data range validity : perc ent and date format not respected in the list
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80318 --- Additional comments from [EMAIL PROTECTED] Fri Apr 4 19:44:23 + 2008 --- This problem first appeared in OO v2.3 and continues in v2.4. The problem does not occur in v2.2.1. This problem also when using time formats. The work around works if the spreadsheet is only required to work in OO but if the same spreadsheet has to work in Excel as well it won't work because OO v2.3 and v2.4 now use a semicolon as a separator and not a comma which is required by Excel. OO v2.2.1 accepted a comma. - 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 80318] Data range validity : perc ent and date format not respected in the list
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80318 User huw changed the following: What|Old value |New value CC|''|'huw' - 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 80318] Data range validity : perc ent and date format not respected in the list
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80318 --- Additional comments from [EMAIL PROTECTED] Fri Feb 8 18:00:32 + 2008 --- Here is a workaround. Suppose you want some times to appear in the combo box, and these times are in the range F1:F4, type the formula TEXT($F$1:$F$4;[HH]:MM:SS) in the source textbox in the Validity dialog, once you have selected Cell range as a criteria. For percentages, use something like TEXT($F$1:$F$4;##0.00%). Note that if you use the sorting option, the values are sorted as text, not as numbers and therefore 75% will be between 7% and 8%. - 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 80318] Data range validity : perc ent and date format not respected in the list
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80318 User dr changed the following: What|Old value |New value Assigned to|dr|er Status|STARTED |NEW --- Additional comments from [EMAIL PROTECTED] Wed Jan 9 14:53:12 + 2008 --- Excel inserts the formatted visible values of the source cells into the dropdown list, but after selecting a value from the list, it inserts the raw unformatted cell value into the destination cell, without changing its number format. To fix this issue, we need to store the display string and the underlying value of a cell in the dropdown list. dr-er: with the current implementation using a formula cell and its result matrix it is not possible to transport the formatted values (source code changes from issue 56566). Not sure how to do this, maybe we need the possibility to ask a formula cell for the result range instead of the result matrix, and to manually process the range, as it was before issue 56566. - 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 80318] Data range validity : perc ent and date format not respected in the list
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80318 --- Additional comments from [EMAIL PROTECTED] Wed Jan 9 15:09:34 + 2008 --- See also issue 82165. - 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 80318] Data range validity : perc ent and date format not respected in the list
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80318 User er changed the following: What|Old value |New value Target milestone|OOo 2.4 |OOo 3.x --- Additional comments from [EMAIL PROTECTED] Wed Jan 9 15:45:57 + 2008 --- Known limitation of the feature implemented with issue 56566. Since the virtual formula cell used to calculate the arbitrary matrix (doesn't have to be a range of cells) isn't even part of the document, there is no way to ask it for a matrix range that matches the source range. Matrix needs a mechanism to transport number formats in such special cases. Certainly nothing for 2.4 anymore. - 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 80318] Data range validity : perc ent and date format not respected in the list
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80318 --- Additional comments from [EMAIL PROTECTED] Wed Jan 9 15:46:45 + 2008 --- *** Issue 82165 has been marked as a duplicate of this 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]
[sc-issues] [Issue 80318] Data range validity : perc ent and date format not respected in the list
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80318 --- Additional comments from [EMAIL PROTECTED] Wed Jan 9 17:06:53 + 2008 --- Hi, perhaps this issue could be linked to issue 45291 ? Yves. - 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 80318] Data range validity : perc ent and date format not respected in the list
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80318 --- Additional comments from [EMAIL PROTECTED] Wed Jan 9 17:41:07 + 2008 --- Issue 45291 is about something different. - 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 80318] Data range validity : perc ent and date format not respected in the list
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80318 User dr changed the following: What|Old value |New value Status|NEW |STARTED --- Additional comments from [EMAIL PROTECTED] Wed Dec 19 10:00:58 + 2007 --- started - 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 80318] Data range validity : perc ent and date format not respected in the list
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80318 User fst changed the following: What|Old value |New value Assigned to|spreadsheet |dr Target milestone|--- |OOo 2.4 --- Additional comments from [EMAIL PROTECTED] Mon Aug 6 10:02:53 + 2007 --- Hi Daniel, please have a look at this one. Frank - 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 80318] Data range validity : perc ent and date format not respected in the list
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80318 --- Additional comments from [EMAIL PROTECTED] Fri Aug 3 09:32:40 + 2007 --- Created an attachment (id=47287) Sample displaying the wrong formatting - 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 80318] Data range validity : perc ent and date format not respected in the list
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80318 Issue #|80318 Summary|Data range validity : percent and date format not resp |ected in the list Component|Spreadsheet Version|680m223 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|sgauti --- Additional comments from [EMAIL PROTECTED] Fri Aug 3 09:31:38 + 2007 --- Hi, Open the sample document : - click in cell B16 to display the list, data are not displayed in percent formatting - click in cell E16 to display the list, data are not displayed in date formatting Kind regards - Sophie - 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]
