[api-issues] [Issue 52509] Problem with setting date through automation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52509 User nn changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |INVALID --- Additional comments from [EMAIL PROTECTED] Thu Nov 2 10:47:42 -0800 2006 --- Yes, this isn't a defect and can be closed. - 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]
[api-issues] [Issue 52509] Problem with setting date through automation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52509 User nn changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from [EMAIL PROTECTED] Thu Nov 2 10:48:07 -0800 2006 --- closing - 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]
[api-issues] [Issue 52509] Problem with setting date through automation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52509 User cyb changed the following: What|Old value |New value Assigned to|jl|nn --- Additional comments from [EMAIL PROTECTED] Fri Sep 2 04:48:06 -0700 2005 --- cyb-nn: So it's not a defect? Can you resolve the 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]
[api-issues] [Issue 52509] Problem with setting date through automation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52509 --- Additional comments from [EMAIL PROTECTED] Fri Aug 26 06:52:34 -0700 2005 --- The string that's passed to setFormula is always assumed to be in US-English format, regardless of the system locale. From that string, the cell content (value) is determined, but the cell's number format is not changed, so the resulting date display can be in a different order, even depending on the system locale. The same is true for numbers. If you want to set a decimal number using setFormula, the string has to use . as the decimal separator. Of course, you can also set a value using setValue, without involving any strings. - 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]
[api-issues] [Issue 52509] Problem with setting date through automation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52509 --- Additional comments from [EMAIL PROTECTED] Thu Aug 18 23:02:43 -0700 2005 --- NN is currently on vacation. So be a patient :) - 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]
[api-issues] [Issue 52509] Problem with setting date through automation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52509 User cyb changed the following: What|Old value |New value CC|'nn' |'cyb,nn' Keywords| |oooqa --- Additional comments from [EMAIL PROTECTED] Thu Aug 18 15:48:52 -0700 2005 --- adding myself to cc. Seems like a real issue to 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[api-issues] [Issue 52509] Problem with setting date through automation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52509 --- Additional comments from [EMAIL PROTECTED] Thu Jul 28 23:04:16 -0700 2005 --- JL-NN: Do you have an idea? - 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]
[api-issues] [Issue 52509] Problem with setting date through automation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52509 User sw changed the following: What|Old value |New value Assigned to|sw|jl --- Additional comments from [EMAIL PROTECTED] Thu Jul 28 05:09:12 -0700 2005 --- sw-jl: any ideas ? - 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]
[api-issues] [Issue 52509] Problem with setting date through automation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52509 --- Additional comments from [EMAIL PROTECTED] Thu Jul 28 06:13:32 -0700 2005 --- setFormula takes a string as argument. However, you provida a Variant containing a Date. The OleAutomation bridge uses VariantChangeType to convert the Date to a BSTR. This string must already contain a wrong version format. The string must contain the date in ISO format (-mm-dd) or in us-eng (mm/dd/jjj) in order to be recognized. Maybe the VariantChangeType depends on a locale that is not properly set in your application. What you could do is convert your Date with VariantChangeType into a BSTR in your appliccation and check if the string has the proper 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[api-issues] [Issue 52509] Problem with setting date through automation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52509 --- Additional comments from [EMAIL PROTECTED] Thu Jul 28 06:28:36 -0700 2005 --- Small correction, because the conversion from Date to BSTR occurs in the office process, the date format depends on the locale set in that process. To be on the safe side you could make the conversion in the client application and pass the string. - 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]
[api-issues] [Issue 52509] Problem with setting date through automation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52509 --- Additional comments from [EMAIL PROTECTED] Thu Jul 28 06:51:53 -0700 2005 --- OK, I changed the code to BSTR bs = SysAllocString( L2005-08-03); IGNORE_COM_ERRORS( pSheet, _T(DateIssue), bs);//(DATE)dt1); The problem still persists. I'm getting the data April (!!!) 8th, 2005 instead of August 3rd, 2005. Note that I'm getting it when the month is displayed in words so the problem is not a display one but OOo really must parse this string incorrectly. - 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]
[api-issues] [Issue 52509] Problem with setting date through automation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52509 --- Additional comments from [EMAIL PROTECTED] Thu Jul 28 07:00:38 -0700 2005 --- I just learned that the ISO format is new in OOo2. So please try the 08/03/2005. - 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]
[api-issues] [Issue 52509] Problem with setting date through automation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52509 --- Additional comments from [EMAIL PROTECTED] Thu Jul 28 07:10:51 -0700 2005 --- Changed code to BSTR bs = SysAllocString( L08/03/2005); IGNORE_COM_ERRORS( pSheet, _T(DateIssue), bs);//(DATE)dt1); The results is still the same, ie. I get April 8th, 2005. Note that I even get April instead of March :-( - 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]
[api-issues] [Issue 52509] Problem with setting date through automation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52509 --- Additional comments from [EMAIL PROTECTED] Thu Jul 28 07:29:06 -0700 2005 --- That is really strange. Could you strip down your code, so that it is still buildable and attach the source? Then I could have a closer look. - 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]
[api-issues] [Issue 52509] Problem with setting date through automation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52509 --- Additional comments from [EMAIL PROTECTED] Thu Jul 28 08:58:40 -0700 2005 --- Sorry, I was working with a group of projects and had the active project set to something else than the OOo project. So the DLL that was exporting to OOo was not recompiled and therefore I got wrong results. The code is now working fine, passing 08/04/2005 instead of variant of type VT_DATE really helped. Thanks for the help. BTW, I was porting the code from a library exporting to Excel and there no problems occur if I pass VT_DATE instead of string. - 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]
[api-issues] [Issue 52509] Problem with setting date through automation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52509 --- Additional comments from [EMAIL PROTECTED] Thu Jul 28 09:09:41 -0700 2005 --- Dear jl, may I just ask you a few questions? First of all, if I pass 08/04/2005, will the date be shown properly independently of international settings? Ie. will OOo always parse it as month/day/year and just change the display, even though the user might have set the date format to day/month/year? Or should I pass it as an integer value, ie. convert date to int and pass the result? Second, how do I pass currency and double types? I suppose that I use strings again but what should I use as decimal separator? , or . ? And will this really be independent of the user's settings? 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[api-issues] [Issue 52509] Problem with setting date through automation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52509 --- Additional comments from [EMAIL PROTECTED] Tue Jul 26 16:27:46 -0700 2005 --- I am very confused about this function: void IGNORE_COM_ERRORS( IDispatch *pSheet, const TCHAR *name, DATE value) { VARIANT val; VariantInit( val); val.vt = VT_DATE | VT_BYREF; val.pdate = value; IGNORE_COM_ERRORS( pSheet, name, val); } Maybe I am blind this late hour of the night, but this seems like something really bad to me (does your code ever exit?) - 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]
[api-issues] [Issue 52509] Problem with setting date through automation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52509 --- Additional comments from [EMAIL PROTECTED] Tue Jul 26 16:34:20 -0700 2005 --- There's no problem. void IGNORE_COM_ERRORS( IDispatch *pSheet, const TCHAR *name, DATE value) simply creates a VARIANT of type VT_DATE and calls void IGNORE_COM_ERRORS( IDispatch *pSheet, const TCHAR *name, VARIAN value). There, the code ends. - 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]