[sc-issues] [Issue 85540] Insert > Link to External Data applies number formatting
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85540 --- Additional comments from [EMAIL PROTECTED] Mon Dec 8 00:12:55 + 2008 --- Yes, as far as I understand 71997 it's similar. Let me add a very common example: Trying to link tables of sport results (Nine to Twelve), you may get the following evaluation of strings to formatted numbers: "9-12" => this year's 9th of December or US Dec 12th respectively "9:12" => 0.38333 (fraction of a day) With any other import method there is some trick to enforce literal strings, except for "Link to external data" which always overwrites formatting and values, evaluating everything in numeric context. Link to external data works well with file:// links as long as the referenced file has named tables embedded, such as named tables in html, named ranges or database ranges in spreadsheets (no text-tables, unfortunately). - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 85540] Insert > Link to External Data applies number formatting
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85540 --- Additional comments from [EMAIL PROTECTED] Sun Dec 7 14:47:40 + 2008 --- Seems a duplicate of 71997 to me. BTW, link to external data seems to work on http (not "file://") only in recent versions? (and the workaround via the Navigator has a wrong description in the manual ..). - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 85540] Insert > Link to External Data applies number formatting
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85540 Issue #|85540 Summary|Insert > Link to External Data applies number formatti |ng Component|Spreadsheet Version|OOo 2.3.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|villeroy --- Additional comments from [EMAIL PROTECTED] Thu Jan 24 08:51:42 + 2008 --- It is a frequently reported issue on the support forums that you have no control on the imported data types. I know 5 different ways to import data into Calc (not counting the clipboard). "Menu:Insert>Link to External Data..." is the only method where I can not prevent "1-5" to be imported as date. When I import the very same html-table via clipboard I can pre-set the offending fields to number format "Text". Linking overrides my formatting. - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
