Testcase specification document
Testname: Open / Import / Paste Behaviour of HTML and RTF Data |
Document Owner: Frank Stecher |
Last document change: 27.06.2006 |
Status of document: Standard |
Valid for version: StarOffice8 PP4
Check that English formatted numbers are imported
Easiest checked with German locales
HTML_Doc_Numberformats_in_table.html
HTML_Doc_Numberformats_in_table.rtf
Import of HTML tables (en_US setting) |
Status: Standard |
- |
|
||
Import of RTF Tables (en_US setting) |
Status: Standard |
- |
|
||
Paste Clipboard data containing formatted HTML content (en_US setting) |
Status: Standard |
- |
The section A6:A12 contains numbers converted from English/US
to German localized numbers. So a 1.1 is converted to 1,1 and so
on. 1.000 (one thousand) is converted to 1 as a comma is used as
decimal separator under German locales. According to the used
settings under HTML Compatibility this is correct. |
||
Import of HTML tables (locale setting) |
Status: Standard |
- |
Make sure you're using a locale setting other than US/English.
This testcase description describes the behaviour if used under
German locales. A10:A11 is converted to text as a number with a comma as thousands and a dot as decimal separator isn't known as a number for Germany. A12 is converted to one thousand as a dot under german locales is used as thousands separator and the import settings converts the comma correctly to a dot. B6:B11 is imported as number, which is also correct as a comma
is the decimal separator in German locale settings. |
||
Import of RTF tables (locale setting) |
Status: Standard |
- |
A8:A9 is converted to text as a number with a comma as thousands and a dot as decimal separator isn't known as a number for Germany. A10 is converted to one thousand as a dot under german locales is used as thousands separator and is followed by three zeros the import settings converts the comma correctly to a dot and therefore shows 1000. B4:B9 is imported as number, which is also correct as a comma
is the decimal separator in German locale settings. |
||
Paste Clipboard data containing formatted HTML content (locale setting) |
Status: Standard |
- |
The section A4:A7 contains dates converted from English/US localized numbers. So a 1.1 is converted to 01.01.06 and so on, as all these numbers in german locales are interpreted as dates because the dot is normally used as separator between day, month and year in Germany. According to the used settings under HTML Compatibility this is correct. A8:A9 is converted to text as a number with a comma as thousands and a dot as decimal separator isn't known as a number for Germany. A10 is converted to one thousand as a dot under german locales is used as thousands separator and is followed by three zeros the import settings converts the comma correctly to a dot and therefore shows 1000. B4:B9 is imported as number, which is also correct as a comma
is the decimal separator in German locale settings. |
||
Insert Sheet from HTML/RTF file |
Status: Standard |
- |
The section A6:A9 contains dates converted from English/US localized numbers. So a 1.1 is converted to 01.01.06 and so on, as all these numbers in german locales are interpreted as dates because the dot is normally used as separator between day, month and year in Germany. According to the used settings under HTML Compatibility this is correct. A10:A11 is converted to text as a number with a comma as thousands and a dot as decimal separator isn't known as a number for Germany. A12 is converted to one thousand as a dot under german locales is used as thousands separator and is followed by three zeros the import settings converts the comma correctly to a dot and therefore shows 1000. B6:B11 is imported as number, which is also correct as a comma
is the decimal separator in German locale settings.
The section A4:A7 contains dates converted from English/US localized numbers. So a 1.1 is converted to 01.01.06 and so on, as all these numbers in german locales are interpreted as dates because the dot is normally used as separator between day, month and year in Germany. According to the used settings under HTML Compatibility this is correct. A8:A9 is converted to text as a number with a comma as thousands and a dot as decimal separator isn't known as a number for Germany. A10 is converted to one thousand as a dot under german locales is used as thousands separator and is followed by three zeros the import settings converts the comma correctly to a dot and therefore shows 1000. B4:B9 is imported as number, which is also correct as a comma
is the decimal separator in German locale settings.
|
||
Insert Link to External Data |
Status: Standard |
- |
The section A6:A9 contains dates converted from English/US localized numbers. So a 1.1 is converted to 01.01.06 and so on, as all these numbers in german locales are interpreted as dates because the dot is normally used as separator between day, month and year in Germany. According to the used settings under HTML Compatibility this is correct. A10:A11 is converted to text as a number with a comma as thousands and a dot as decimal separator isn't known as a number for Germany. A12 is converted to one thousand as a dot under german locales is used as thousands separator and is followed by three zeros the import settings converts the comma correctly to a dot and therefore shows 1000. B6:B11 is imported as number, which is also correct as a comma
is the decimal separator in German locale settings.
|