[Libreoffice-bugs] [Bug 47109] [IMPORT] Link to external HTML file import dates well but with the cell formatted as text.
https://bugs.freedesktop.org/show_bug.cgi?id=47109 mariosv changed: What|Removed |Added Summary|IMPORT: Link to external|[IMPORT] Link to external |HTML file import dates well |HTML file import dates well |but with the cell formatted |but with the cell formatted |as text.|as text. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 47109] IMPORT: Link to external HTML file import dates well but with the cell formatted as text.
https://bugs.freedesktop.org/show_bug.cgi?id=47109 mariosv changed: What|Removed |Added Summary|Link to external HTML file |IMPORT: Link to external |import dates well but with |HTML file import dates well |the cell formatted as text. |but with the cell formatted ||as text. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 47109] [IMPORT] Link to external HTML file import dates well but with the cell formatted as text.
https://bugs.freedesktop.org/show_bug.cgi?id=47109 mariosv changed: What|Removed |Added Severity|normal |major -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 47109] [IMPORT] Link to external HTML file import dates well but with the cell formatted as text.
https://bugs.freedesktop.org/show_bug.cgi?id=47109 joaquin changed: What|Removed |Added See Also||https://bugs.freedesktop.or ||g/show_bug.cgi?id=53103 --- Comment #1 from joaquin 2012-08-06 17:24:59 UTC --- Also numbers are imported as TEXT, with one exception: - Global setting Load/Save -> HTML Compatibility -> Use English (USA) locale for number changes this behaviour for numbers with a "." as decimal separator (but swaps month and day around if day < 13) - Withouth this global setting all numbers in all formats and (manipulated) dates are imported as TEXT Tested with LibreOffice 3.5.4 & 3.6.0 RC4 -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 47109] [IMPORT] Link to external HTML file import dates well but with the cell formatted as text.
https://bugs.freedesktop.org/show_bug.cgi?id=47109 bfoman changed: What|Removed |Added CC||bfo.bugm...@spamgourmet.com --- Comment #2 from bfoman 2012-08-08 12:35:05 UTC --- (In reply to comment #0) > Opening HTML file with dates MM/DD/ (English-US), trough link to external > data source, import dates well formed but with the cell formatted as text (@). Confirmed with: LO 3.5.5.3 Build ID: own W7 debug build Windows 7 Professional SP1 64 bit(In reply to comment #0) > Opening in the system with right-click, selecting LibreOffice Calc to open, > the > dates look well with the cell formatted as date DD/MM/YY. Could not reproduce. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 47109] [IMPORT] Link to external HTML file import dates well but with the cell formatted as text.
https://bugs.freedesktop.org/show_bug.cgi?id=47109 --- Comment #3 from satlin...@aim.com 2012-08-15 18:59:50 UTC --- Created attachment 65609 --> https://bugs.freedesktop.org/attachment.cgi?id=65609 Example of buggy number import File imports numbers from http://n2yo.com/satellites/satlinker.php in the third coloumn it tests some numbers of the second coloumn if its a number or not. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 47109] [IMPORT] Link to external HTML file import dates well but with the cell formatted as text.
https://bugs.freedesktop.org/show_bug.cgi?id=47109 --- Comment #4 from satlin...@aim.com 2012-08-15 19:16:34 UTC --- The import of numbers doesn't work at all in version 3.6. See the second attachment, it imports numbers from a website. In the third coloumn it tests some numbers of the second coloumn if its a number or not. It worked fine in former libreoffice versions. The numbers don't have a ' before to format it as text, however they are not recognized as numbers. It has nothing to do with Load/Save -> HTML Compatibility -> Use English (USA) locale for number. This should not be a global option but an option for a specific table. Please be careful with changes to a running system, that error makes me a lot of troubles. Better not so many updates therefor better tested ones. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 47109] [IMPORT] Link to external HTML file import dates well but with the cell formatted as text.
https://bugs.freedesktop.org/show_bug.cgi?id=47109 satlin...@aim.com changed: What|Removed |Added Priority|medium |high -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 47109] [IMPORT] Link to external HTML file import dates well but with the cell formatted as text.
https://bugs.freedesktop.org/show_bug.cgi?id=47109 --- Comment #5 from joaquin 2012-08-31 18:58:35 UTC --- (In reply to comment #1) > Also numbers are imported as TEXT, with one exception: > > - Global setting > Load/Save -> HTML Compatibility -> Use English (USA) locale for number > changes this behaviour for numbers with a "." as decimal separator > (but swaps month and day around if day < 13) > - Withouth this global setting all numbers in all formats and (manipulated) > dates > are imported as TEXT > > Tested with LibreOffice 3.5.4 & 3.6.0 RC4 Use this global setting, automatic on import and import some numbers with two or three decimals: http://beurs.fd.nl/aandelen/amsterdam/aex/ Then the "," decimal separator is lost in the TEXT() fields with more than two decimals, e.g. ArcelorMittal 11,855 Becomes: ArcelorMittal 11855 While Royal Dutch Shell A 27,81 gets the same characters "27,81" in the second TEXT-field. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs