iworkmacospagesxml
It looks like iWork's Pages supports Open XML – however, I can't find any good information on this on either developer.apple.com or on the web. Is there a good resource for this that I'm not aware of? I see http://openxmldeveloper.org but this is clearly MS-specific. Is there a comparable resource for Pages?
I'd like a trivial example of how this would work such as a "Hello World" type document. Does this exist?
UPDATE::
The Example in the Answer below works, But it may be from a result of some sort of BUG in Pages.
I did not save the test document when I did this until now.
It seems when you reopen the Document. It saves the result in the total cell of Table A, as text. i.e removes the formula.
So the REAL answer is NO. you cannot do this in Pages.
You CAN do what you want in Numbers
Original Answer
In the cell of Table (A) the table you want the sum; type a equals symbol. =
You will now get a the formula box.
(cell in table A)
Type SUM(headerTitle) in front of the = with no spaces.
(cell in table A)
The headerTitle being a Header Title from Table (B)'s Header Row or Header Column.
In this example I use Table B's Header Row title 'headRowTitle2'
(table B)
(The Row in table B will highlight to show the cells Table A will be using)
Click the green tick button. It should now display the total you want.
(table A)
bplist means binary property list, which can be converted to XML with plutil -convert xml1. Inside each plist for a color is another data key for the fractional RGB values.
/usr/libexec/PlistBuddy -x -c 'Print "Window Settings":"My Theme"' ~/Library/Preferences/com.apple.Terminal.plist|tr -d '\n\t'|grep -o '[^>]*</key><data>[^<]*'|while read l;do echo ${l%%<*} $(base64 -D<<<${l##*>}|plutil -convert xml1 - -o -|awk '/<data>/{getline;print}'|tr -d '\t'|base64 -D);done
The output looks like this:
ANSIBlueColor 0.4769933663 0.4769933663 0.9314516129
ANSICyanColor 0.2666655827 0.8165705831 0.8588709677
ANSIGreenColor 0.428833897 0.8508064516 0.490967087
ANSIMagentaColor 0.9072580645 0.4499707336 0.9072580645
ANSIRedColor 0.9072580645 0.508503512 0.508503512
ANSIYellowColor 0.9072580645 0.9072580645 0.3914379553
CursorColor 0.9998760223 0.999984026 0.999786377
SelectionColor 0.3899414837 0.4639441073 0.5917825699
TextBoldColor 0.9441435337 0.4102420509 0.427282244
TextColor 1 0.99997437 0.9999912977
Best Answer
Office Open XML is a standard invented by Microsoft - their documentation would be the go-to resource. Pages simply uses the built-in OS X ability to read them. TextEdit can read OOXML (i.e. .docx) as well, and is included (with source) with Apple's developer tools as a sample.