Re: iWork Numbers

Subject: Re: iWork Numbers

From: Philip Aker <email@hidden>

Date: Mon, 27 Aug 2007 20:43:21 -0700

Delivered-to: email@hidden

On 2007-08-27, at 20:00:13, Bruce Robertson wrote:

Let's just take the Hawaii Vacation example.

One of the tables is "Gadgets". It has 12 data rows and is 3 columns wide; plus header. Only six data rows contain data. It begins like this:

<sf:tabular-model sfa:ID="SFTTableModel-5" sf:name="Gadgets"
sf:id="931928960B595C3D00970EA600000000" sf:num-header-rows="1"
sf:num-footer-rows="0" sf:num-header-columns="0" sf:name-is-visible="true"
sf:grouping-enabled="false"><sf:grid sfa:ID="SFTTableGrid-5" sf:ocnt="33"
sf:numcols="3" sf:numrows="13" sf:hiddennumcols="0"
sf:hiddennumrows="0"><sf:columns sf:count="3"><sf:grid-column
sf:width="98.064529418945312" sf:preferred-width="98.064529418945312"
sf:fitting-width="84.245895385742188"/><sf:grid-column
sf:width="58.967739105224609" sf:preferred-width="58.967739105224609"
sf:fitting-width="41.657913208007812"/><sf:grid-col

The unpacked XML for this simple table is 11,000 characters and about 230 XML entitites.

Let's just take the simple question of adding a new table and just take a fragement of that - how do I assign an ID to my new table?

Hi Bruce,

I haven't this app yet, but normally you'd want to use a .xsl file and a utility like xsltproc <x-man-page://xsltproc> or a full-fledged XML editor to do the above.

A lot depends on knowing the schema (or DTD) as it defines the file format (and perhaps the format of the IDs very precisely).

If for instance, the schema file states that the sfa:ID attribute is "xsd:IDREF" then it means the ID has to be unique among the document (or indeed a document as it might be a conglomeration of several sub-documents). So your .xsl file, as one of the inputs to xsltproc, could parse an existing document, create the new table after the last table slot, and generate it's ID by the XPath function:

<xsl:value-of select="concat( 'SFTTableModel-', generate-id() )"/>.

or perhaps just create a value one larger than the highest sfa:ID number.

Doing that with PVA[1] may be possible, but isn't practical at all.

Philip Aker

email@hidden

[1] Pure Virgin AppleScript

_______________________________________________ Do not post admin requests to the list. They will be ignored. AppleScript-Users mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/applescript-users/email@hidden Archives: http://lists.apple.com/archives/applescript-users This email sent to email@hidden

Follow-Ups:

Re: iWork Numbers
- From: Bruce Robertson <email@hidden>

References:

>Re: iWork Numbers (From: Bruce Robertson <email@hidden>)