You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/10/04 11:53:49 UTC
[Bug 121156] New: Locale selection does nothing when linking to
external data
https://issues.apache.org/ooo/show_bug.cgi?id=121156
Priority: P3
Bug ID: 121156
Assignee: ooo-issues@incubator.apache.org
Summary: Locale selection does nothing when linking to external
data
Severity: normal
Issue Type: DEFECT
Classification: Application
OS: All
Reporter: villeroy@t-online.de
Hardware: All
Status: UNCONFIRMED
Version: AOO 3.4.1
Component: open-import
Product: spreadsheet
Calc-menu:Insert>Link_to_external_data
Paste URL http://twolf.hermitstore.com/wolf.gz/ver001/yield.html and hit Enter.
Wait some seconds and choose html_all (the URL consists of one table).
Locale: any Chinese or any English locale with decimal point.
Result:
First column of integers imports correctly.
Subsequent columns of decimals import as text.
The locale selector for html import had been introduced in OOo 3.3 in order to
avoid text-to-number conversion for wrongly imported numerals. It seems to do
nothing here.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121156] Locale selection does nothing when linking to external
data
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121156
--- Comment #8 from Edwin Sharp <el...@apache.org> ---
Created attachment 82172
--> https://issues.apache.org/ooo/attachment.cgi?id=82172&action=edit
Screenshot of Region and Language with spreadsheet
Can not reproduce.
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
[Bug 121156] Locale selection does nothing when linking to external
data
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121156
--- Comment #10 from Edwin Sharp <el...@apache.org> ---
1. Start - Control Panel - Clock, Language, and Region - Region and Language -
Formats - Format:French (France)
2. File - New - Spreadsheet
3. Insert - Link to External Data...
4. Click ... button
5. Select HTML file of comment 9 - Open
6. Import Options - Select the language to use for import - Custom=Chinese
(traditional) - OK
7. Available tables/ranges - HTML_all - OK
Column Contents
A Integers
B Decimals
C Decimals
D Decimals
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
[Bug 121156] Locale selection does nothing when linking to external
data
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121156
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
CC| |elish@apache.org
Resolution|--- |IRREPRODUCIBLE
--- Comment #6 from Edwin Sharp <el...@apache.org> ---
Only column B is text.
Columns C-E are decimals.
AOO410m1(Build:9750) - Rev. 1551017
Rev.1551017
Win 7
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
[Bug 121156] Locale selection does nothing when linking to external
data
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121156
--- Comment #3 from Andreas Säger <vi...@t-online.de> ---
So we agree in the matter of fact that the import is broken for this most
simplistic example of a HTML table.
I can import the URL with incorrect data (text instead of numbers) whereas the
downloaded file opens correctly through Calc's HTML filter.
Ariel, what is your problem with the URL import? Do you get some error message?
The related forum is
http://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=56604 where the OP
gets some error message in Chinese.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121156] Locale selection does nothing when linking to external
data
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121156
--- Comment #11 from Andreas Säger <vi...@t-online.de> ---
1. Start - Control Panel - Clock, Language, and Region - Region and Language -
Formats - Format:French (France)
2. File - New - Spreadsheet
3. Insert - Link to External Data...
Yes, because you adjust the global office locale *before* you do the import.
This is supposed to be adjustable for each import in the dialog that pops up
when the data come in. That language selector in the dialog does nothing.
And the "Special Numbers" option on that dialog doesn't work neither as you can
see with date, time, currency, boolean strings.
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
[Bug 121156] Locale selection does nothing when linking to external
data
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121156
--- Comment #4 from Ariel Constenla-Haile <ar...@apache.org> ---
(In reply to comment #3)
> So we agree in the matter of fact that the import is broken for this most
> simplistic example of a HTML table.
> I can import the URL with incorrect data (text instead of numbers) whereas
> the downloaded file opens correctly through Calc's HTML filter.
>
> Ariel, what is your problem with the URL import? Do you get some error
> message?
>
> The related forum is
> http://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=56604 where the OP
> gets some error message in Chinese.
I get the same error as described there.
Bu the error is not the one described in this bug (if I use localhost, the
table gets imported OK), the error seems to be with the underlying code that
fetches the table from the internet (the code changed from OOo 3.4 beta to AOO
3.4.0, because of license issues). See bug 121057
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121156] Locale selection does nothing when linking to external
data
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121156
Ariel Constenla-Haile <ar...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |arielch@apache.org
--- Comment #2 from Ariel Constenla-Haile <ar...@apache.org> ---
I can't reproduce it (I had to copy the file in my public_html on localhost,
because importing is broken)
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121156] Locale selection does nothing when linking to external
data
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121156
--- Comment #9 from Andreas Säger <vi...@t-online.de> ---
I reproduce it with any HTML input, version 4.0.1 and 3.4.1.
If your locale happens to be a decimal point locale, save the following as a
html file and try to insert a link with German(Germany) as import locale
(because of the comma decimals). The resulting table will be text although you
have chosen an adequate locale.
<html>
<body><table border="1">
<tr><th>No</th><th>PER</th><th>Yield</th><th>P/B</th></tr>
<tr><td>1101</td><td>15,28</td><td>5,41</td><td>1,4</td></tr>
<tr><td>1102</td><td>14,23</td><td>7,22</td><td>1,44</td></tr>
<tr><td>1103</td><td>0,0</td><td>3,57</td><td>0,76</td></tr>
</table></body></html>
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
[Bug 121156] Locale selection does nothing when linking to external
data
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121156
--- Comment #1 from Andreas Säger <vi...@t-online.de> ---
The html is a most simple test case with a body like this:
<body><table border="1">
<tr><th>No</th><th>本益比(PER)</th><th>殖利率(Yield)</th><th>股價淨值比(P/B)</th></tr>
<tr><td>1101</td><td>15.28</td><td>5.41</td><td>1.4</td></tr>
<tr><td>1102</td><td>14.23</td><td>7.22</td><td>1.44</td></tr>
<tr><td>1103</td><td>0.0</td><td>3.57</td><td>0.76</td></tr>
more table rows
</table></body>
When I open downloaded file copy as file type "HTML (Calc)" I get the correct
data for the given locale.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121156] Locale selection does nothing when linking to external
data
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121156
--- Comment #7 from Andreas Säger <vi...@t-online.de> ---
All you need to do in order to reproduce the issue with the given data from
http://twolf.hermitstore.com/wolf.gz/ver001/yield.html is:
Set your global locale to some locale with decimal comma (German, Russian,
French).
Then link to external data, specify that you want to use a decimal point locale
(English, Chinese) and do the import. The specified locale does not override
the global locale. It has no effect at all.
This happens regardless of the data access method with the given URL or its
downloaded html.
Demonstrating the expected functionality with csv or clipboard content like
this:
<snip>
2/3/2013;3.146
9/8/2013;3,146
</snip>
Paste-special unformatted text with semicolon as column separator and "Special
Numbers" option checked. Depending on the chosen import locale, the 4 numerals
evaluate to different values (3rd of February or 2nd of March, 8th of September
or 9th of August, 3146 or Pi or text).
This functionality is dead in the html import (Insert>Link to External...).
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
[Bug 121156] Locale selection does nothing when linking to external
data
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121156
--- Comment #5 from Ariel Constenla-Haile <ar...@apache.org> ---
Side note, the text in the message boxes should be easy to copy and paste.
Don't know if there is a RFE for this.
--
You are receiving this mail because:
You are the assignee for the bug.