To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=101154
User jim_meech2 changed the following:
What |Old value |New value
================================================================================
Status|CLOSED |UNCONFIRMED
--------------------------------------------------------------------------------
Resolution|DUPLICATE |
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Fri Apr 17 10:51:06
+0000 2009 -------
Thanks for your quick response, however I do not believe that this issue should
be closed as resolved as a duplicate of issue 1834.
I have scanned the numerous postings on this issue, perhaps my report is better
suited as a new feature request, as it appears the Link to external data route
is functioning as intended.
The suggested method of importing text files works fine if you wish to create a
new sheet for the imported data. If however you wish to repeatedly import &
refresh data from a text file, so that it always imports to the same sheet,
starting at the same cell, this method does not work easily.
You would have to write additional macros to cut and paste the data from the new
sheet to the sheet you wish to work on.
The equivalent functionality in Excel makes it very easy to import text data
into a template spreadsheet for rapid processing.
As an engineer dealing with large numbers of text based machine logs, this
functionality is invaluable.
I will upload an example excel spreadsheet & real data to demonstrate the
utility of this approach to data import.
This spread sheet will not open in OO due to incompatible macros.
on opening the spreadsheet in excel (office XP) follow these steps:
Don't update on the request to update linked data.
Press the macro button Refresh Data.
Select the text file Autopilot.txt
Ignore the Export results Macro Button
Statistical analysis & graph plotting have now been completed.
If you are willing to reconsider the status of this report I would be very
willing to clarify any points by phone. I may be contacted on +44 (0)1386 768050
Working hours 09:00 to 17:00 GMT+1 BST should this prove useful.
Many thanks & best regards
Jim Meech
---------------------------------------------------------------------
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]
