To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=91365





------- Additional comments from [EMAIL PROTECTED] Fri Jul  4 17:48:14 +0000 
2008 -------
>To confirm your problem I need a description how you want to do copying.

>If I want to copy a table I have no problems to do it.

>>Copy the data from the spreadsheet or table.
>How do _you_ do it

I select the columns/rows that I want to copy, then click copy from the
right-click menu, Edit>Copy menu, or use Control-C from the keyboard.

>>Paste the data to the data base table which has the fields already defined.
>which "data base" table? Do you mean the internal HSQL DB?

I have noticed that those words are in the status bar. They are called Tables on
the tool bar on the left side and when they are created in the bottom pane where
all of the wording refers to them as ‘tables’. The way it is now you have to
first paste the data into a CSV text file then import that file into the data
base ‘table’. Probably because of the difference in the way the data is handled
between a spreadsheet and a true data base.

>>Information is put in its proper place in the data base table, sans formating.

>This needs more information

I suppose I should have said, “After selecting the cell that is the first cell
of the columns/rows that I want to fill, I would click paste from a menu or
Control-V. The data would then be entered into each cell relative to the
starting cell without the formatting from the spreadsheet/document.” If I were
to click on the wrong cell in the data base, then the columns/rows would not
match the fields/records and I should get an error. In which case I would berate
myself, and start over being more careful to match the cells.

Another way of putting it would be I would like to enter data from the
spreadsheet/document table to the data base ‘table’ as easily as from one
spreadsheet table to another spreadsheet table. Without having to convert the
data to a CSV text file first.

You make it sound as if spreadsheets and SQL data bases are incompatible so that
it cannot be done. There might be a chance that someone will come up with a way
to do it sooner or later though.

---------------------------------------------------------------------
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]

Reply via email to