This illustrates the problem I have so often with XML Mind...I don't know how to paste a whole row! I can paste row by row if I have to, but I can't paste cell by cell. Ideally I'd like to be able to select an entire section (e.g. 10 columns by 10 rows) in Excel and paste it into an XML Mind table.
First I clicked on a row of data in an Excel spreadsheet and then clicked on the "row" selector in XML Mind so the row was highlighted. I then right clicked while the row was highlighted, but paste wasn't an option. Next I selected exactly the same number of columns in my XML Mind spreadsheet in my Excel spreadsheet and selected the row so it was highlighted in XML Mind. The paste option again wasn't there. It seems that the paste option is only there when I'm trying to paste a single cell. Is that right? ----- Original Message ----- From: "Hussein Shafie" <[email protected]> To: "Allison Bloodworth" <abloodworth at berkeley.edu> Cc: <xmleditor-support at xmlmind.com> Sent: Tuesday, March 15, 2005 9:34 AM Subject: Re: [XXE] Pasting spreadsheets into tables? > 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. > >
