To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94625
Issue #|94625
Summary|string representing a date is corrupted in calc cell
Component|Spreadsheet
Version|OOO300m7
Platform|PC
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P2
Subcomponent|programming
Assigned to|spreadsheet
Reported by|jimmyjazz
------- Additional comments from [EMAIL PROTECTED] Sat Oct 4 12:22:13 +0000
2008 -------
hi,
a basic macro string like
myDate = Format(Date, "dd mm yy")
is corrupted when it is assigned to a cell. In the cell itself it is shown
correct, but the formula editor shows that it now has a leading < ' > in
front of it. As a consequence it can't be detected by the format settings
of calc for this cell as a date value. Also affected are strings like this:
myDate = "1.10." (language: de, means 1st of october)
so the "Format" function not seems to be the reason.
It works perfect with casting it to Date-format before assigning it to the
cell.
regards
jimmyjazz
---------------------------------------------------------------------
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]
