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

Test purpose:

Check that English formatted numbers are imported


Known issues:


Preconditions of test:

Easiest checked with German locales


Test documents:

HTML_Doc_Numberformats_in_table.html
HTML_Doc_Numberformats_in_table.rtf


Testcases:

Import of HTML tables (en_US 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.

Open an Office and check that tools-options-load/save-HTML-Compatibility-Use 'English (USA)' locale for numbers is tagged.

Download and open the testdocument (HTML_Doc_Numberformats_in_table.html). (Make sure you have selected the Calc HTML or Webquery filter, otherwise the document opens as Writer/Web document)

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.

B6:B11 is imported as text, which is also correct as a comma isn't known as decimal separator in English/US locale settings, therefore these values are converted to text.

B12 is shown as 1000 because the 1 in the HTML file is followed by three zeros and the comma is the thousands separator in the US, so we get a number.

Import of RTF Tables (en_US 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.

Open an Office and check that tools-options-load/save-HTML-Compatibility-Use 'English (USA)' locale for numbers is tagged.

Download and open the testdocument (HTML_Doc_Numberformats_in_table.rtf). (Make sure you have selected the Ritch Text Format for Calc filter, otherwise the document opens as Writer document)

The section A4:A10 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.

B4:B9 is imported as text, which is also correct as a comma isn't known as decimal separator in English/US locale settings, therefore these values are converted to text.

B10 is shown as 1000 because the 1 in the RTF file is followed by three zeros and the comma is the thousands separator in the US, so we get a number.

Paste Clipboard data containing formatted HTML content (en_US setting)

Status: Standard

-






Make sure you're using a locale setting other than US/English. This testcase describes the behaviour if used under German locales.

Open an Office and check that tools-options-load/save-HTML-Compatibility-Use 'English (USA)' locale for numbers is tagged.

Download and open one of the testdocuments (HTML_Doc_Numberformats_in_table.html), (HTML_Doc_Numberformats_in_table.rtf). (Make sure it opens as Writer or Writer/Web document) Select all content in this document and Copy this into the clipboard


Now open a new Spreadsheet document an d paste the clipboard into cell A1.

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.

B6:B11 is imported as text, which is also correct as a comma isn't known as decimal separator in English/US locale settings, therefore these values are converted to text.

B12 is shown as 1000 because the 1 in the RTF file is followed by three zeros and the comma is the thousands separator in the US, so we get a number.

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.

Open an Office and check that tools-options-load/save-HTML-Compatibility-Use 'English (USA)' locale for numbers is un-tagged.

Download and open the testdocument (HTML_Doc_Numberformats_in_table.html). (Make sure you have selected the Calc HTML or Webquery filter, otherwise the document opens as Writer/Web document)

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. 1.000 (one thousand) is converted to 1000 as the conversion rule is set to convert such en_US thousands separator to a valid number under German locales. 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 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.

B12 is shown as 1 because the 1 in the HTML file is followed by three zeros and the comma is the decimal separator in the Germany, so we get the number one.

Import of RTF 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.

Open an Office and check that tools-options-load/save-HTML-Compatibility-Use 'English (USA)' locale for numbers is un-tagged.

Download and open the testdocument (HTML_Doc_Numberformats_in_table.rtf). (Make sure you have selected the Calc Rich Text Filter, otherwise the document opens as Writer document)

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.

B10 is shown as 1 because the 1 in the HTML file is followed by three zeros and the comma is the decimal separator in the Germany, so we get the number one.

Paste Clipboard data containing formatted HTML content (locale setting)

Status: Standard

-





Make sure you're using a locale setting other than US/English. This testcase describes the behaviour if used under German locales.

Open an Office and check that tools-options-load/save-HTML-Compatibility-Use 'English (USA)' locale for numbers is un-tagged.

Download and open one of the testdocuments (HTML_Doc_Numberformats_in_table.html). (Make sure it opens as Writer or Writer/Web document) Select all content in this document and Copy this into the clipboard


Now open a new Spreadsheet document and paste the clipboard into cell A1.

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.

B10 is shown as 1 because the 1 in the HTML file is followed by three zeros and the comma is the decimal separator in Germany, so we get the number one.

Insert Sheet from HTML/RTF file

Status: Standard

-




Make sure you're using a locale setting other than US/English. This testcase describes the behaviour if used under German locales.

Open an Office and check that tools-options-load/save-HTML-Compatibility-Use 'English (USA)' locale for numbers is un-tagged.

Download and store both testdocuments (HTML_Doc_Numberformats_in_table.html), (HTML_Doc_Numberformats_in_table.rtf) in a folder that can be reached by the office.

Now open a new Spreadsheet document and go to the Insert Menu. Select Sheet from file.

Search for the HTML file and click on the Insert button.

in the next dialog choose the Position you want and click on the Ok Button, a new sheet will be inserted at the position you have choosen.

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.

B12 is shown as 1 because the 1 in the HTML file is followed by three zeros and the comma is the decimal separator in Germany, so we get the number one.



Now go to the Insert Menu. Select Sheet from file.

Search for the RTF file and click on the Insert button.

in the next dialog choose the Position you want and click on the Ok Button, a new sheet will be inserted at the position you have choosen.

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.

B11 is shown as 1 because the 1 in the HTML file is followed by three zeros and the comma is the decimal separator in Germany, so we get the number one.



Now tag the checkbox under tools-options-load/save-HTML-Compatibility-Use 'English (USA)' locale for numbers.

Repeat the steps above for the HTML file.

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.

B6:B11 is imported as text, which is also correct as a comma isn't known as decimal separator in English/US locale settings, therefore these values are converted to text.

B12 is shown as 1000 because the 1 in the HTML file is followed by three zeros and the comma is the thousands separator in the US, so we get a number.



Repeat the steps above for the RTF file.

The section A4:A10 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.

B4:B9 is imported as text, which is also correct as a comma isn't known as decimal separator in English/US locale settings, therefore these values are converted to text.

B10 is shown as 1000 because the 1 in the RTF file is followed by three zeros and the comma is the thousands separator in the US, so we get a number.

Insert Link to External Data

Status: Standard

-



Make sure you're using a locale setting other than US/English. This testcase describes the behaviour if used under German locales.

Open an Office and check that tools-options-load/save-HTML-Compatibility-Use 'English (USA)' locale for numbers is un-tagged.

Download and store the HTML testdocument (HTML_Doc_Numberformats_in_table.html) in a folder that can be reached by the office.

Now open a new Spreadsheet document and go to the Insert Menu. Select Link to External Data.

Click on the file selector box (...) and search for the HTML testfile. Click on Insert.

Select HTML_all in the Available tables/ranges field of the External data dialog and click on Ok.

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.

B12 is shown as 1 because the 1 in the HTML file is followed by three zeros and the comma is the decimal separator in Germany, so we get the number one.



Now tag the checkbox under tools-options-load/save-HTML-Compatibility-Use 'English (USA)' locale for numbers.

Now select Sheet 2 of the open document and go to the Insert Menu. Select Link to External Data.

Click on the file selector box (...) and search for the HTML testfile. Click on Insert.

Select HTML_all in the Available tables/ranges field of the External data dialog and click on Ok.

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.

B6:B11 is imported as text, which is also correct as a comma isn't known as decimal separator in English/US locale settings, therefore these values are converted to text.

B12 is shown as 1000 because the 1 in the HTML file is followed by three zeros and the comma is the thousands separator in the US, so we get a number.