Allison Bloodworth wrote: > Is there a way to paste a whole spreadsheet into a table, other than by > pasting one cell at a time?
In XXE, there is no big, monolithic, ``spreadsheet object'' (AKA worksheet), there are just many little, independent, spreadsheet formulas. Spreadsheet formulas are contained in "xxe-formula" processing-instructions. These processing-instructions are regular ``XML objects'' which can be copied and pasted as any other ``XML object'' (e.g. plain text node, comment, para element, entry element, etc). These processing instructions are visually represented by a small (f) icon which makes them look very different from other ``XML objects''. But this is just their visual representation. Aside of that, they are regular ``XML objects''. This means that if you copy a row containing a lot of spreadsheet formulas and you paste this row into another table, you have copied ``a piece of the spreadsheet'' to another place. Copying a table containing many spreadsheet formulas from one document to another works too. Copying a section containing many tables containing many spreadsheet formulas from one document to another works too. Etc, etc. The only caveat is that the target document must already contain at least one spreadsheet formula in order to ``activate'' the copied formulas (active green (f) icon instead of inactive yellow (f) icon). In other words, the target document must have been made ``spreadsheet-aware''. (Saving the target document after pasting a bunch of spreadsheet formulas and then reopening it works too.) Recommended reading: http://www.xmlmind.com/xmleditor/_distrib/docs/spreadsheet/index.html --- PS: XMLmind XML Editor Standard Edition will *strip all the formulas* from the files you are going to save.
