To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=106840
User paweljm changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Issue type|DEFECT |ENHANCEMENT
--------------------------------------------------------------------------------
Priority|P3 |P5
--------------------------------------------------------------------------------
Resolution| |WORKSFORME
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Fri Nov 13 17:38:17
+0000 2009 -------
Summary:
OOo 3.2.0 works fine, assuming that copying-pasting dates as numeric values
is NOT ALLOWED - (Warning message can be interpreted by someone who knows
Java).
OOo 3.1.1 allows to use numeric formatting but the date is 2 days off. If
formatting "language" is different than the locale then copy-paste does not work
correctly. Since 3.2 will be released soon, I am not reporting this as an Issue
for 3.1.1
Description:
In OOo 3.1.1 I was unable to copy DATE cells with “Polish” language formatting
to create Tables in BASE. The Month and Day was reversed if day <= 12, or
created a wrong date if day > 12.
Therefore I tried to use numeric formatting of the DATE and it worked, except
the date was 2 days off.
In OOo 3.2.0 the “Polish” formatting seems to work fine and the date fields are
correct, however now the fields formatted as numeric create “Wrong data type
java.lang.IllegalArgumentException”.
Thus, now BASE does not allows copy-paste dates as numeric values, and it is OK,
I think, except the error message is somehow not very informative for regular
users.
Finally in Calc 3.1.1 I copied-pasted my Tables by setting the formatting to
“English (USA)” instead of “Polish” and pasting them to BASE; it worked fine.
Attached are 4 files, for reference and below there is a detailed description,
Regional settings Option on Windows XP
English (United States)
In OpenOffice: Locale Setting: Default - English (USA) (Same as locale setting
( . )
============== Openoffice 3.1.1 =======================
Openoffice 3.1.1 OOO310m19 (Build:9420)
attached files: Date311.ods and New Database311.odb
Here are the steps for Table1 (files Date311.ods and New Database311.odb
Calc
Cell Date1: I typed 12/31/99:
Category: Date
Format: 12/31/99
Language: Default (English US)
Format Code: MM/DD/YY
Cell Date2: I typed 12/31/99 and formated:
Category: Number
Format: -1234
Language: Default (English US)
Format Code: 0
Cell Date3 - I typed number 40130:
Category: Number
Format: General
Language: Default
Format Code: 0
Cell Date4 - I typed number 40130:
Category: Date
Format: 31.12.1999
Language: Polish
Format Code: D.MM.YYYY
Base:
Create new database
Do not register
Open for editing
Button: Finish
Paste 8 cells that were copied from CALC
Paste to Base as Table311
Definition and Data
Type formatting:
all Date1, Date2 Date3, and Date4 have Field Type set to Date [DATE]
create primary key
Table311 shows:
Date1: 11/13/09 (correct)
Date2: 11/15/09 (WRONG - 2 days off)
Date3: 11/15/09 (WRONG - 2 days off)
Date4: 12/30/99 (WRONG - should be 11/13/09)
================== OOo-dev 3.2.0 =========================
Openoffice 3.2.0 OOO320m4 (Build:9450)
attached files: Date320.ods and New Database320.odb
Here are the steps for Table_320
Calc
Cell Date1 (I typed 11/13/09) :
Category: Date
Format: 12/31/99
Language: Default (English US)
Format Code: MM/DD/YY
Cell Date2: (I typed 11/13/09)
Category: Number
Format: -1234
Language: Default (English US)
Format Code: 0
Cell Date3 - I typed number 40130:
Category: Number
Format: -1234
Language: Default (English US)
Format Code: 0
Cell Date4 - I typed number 40130:
Category: Date
Format: 31.12.1999
Language: Polish
Format Code: D.MM.YYYY
Base (File New Database320:
Create new database
Do not register
Open for editing
Button: Finish
Paste 8 cells copied from CALC
Paste to Base
Table320_PL
Definition and Data
Type formatting:
all Date1, Date2, Date3, Date4 Type: Date [DATE]
create primary key
Warning: Wrong data type java.lang.IllegalArgumentException
Continue? YES
Table1 shows:
Date1: 11/13/09 (correct)
Date2: empty
Date3: empty
Date4: 11/13/09 (correct, 13.11.2009 if Polish format is s
---------------------------------------------------------------------
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]
