That's the info I am trying to get into the OpenOffice Spreadsheet. But I don't think it can be done. Unless someone knows how. I was trying too insert or use the the Gox ticker http://data.mtgox.com/api/1/BTCUSD/ticker. But I think in openoffice you can only use HTML pages, from what I was reading.
If you got that set up. You should be able to add sections for people to enter a product Price and Tax Rate that will give the total amount of GLDcoins due for a payment. That's just what I'm trying to do 
. But then it needs to be downloaded for stores to use.
Assuming openoffice can't poll the data directly is true... (I tend to deal with more databases/indexes/libs/logs/etc. then I do with spreadsheets)
It CAN be done, if you REALLY need this in openoffice/libreoffice...
Basically write a small script to run every-so-often, poll the ticker/api, grab the data fields you need, manipulate the data, and either insert the data directly into the spreadsheet file, or render a small/simple, local html page to follow with your spreadsheet...
(assuming Linux, a fairly simple mixture of cron, awk/sed/grep, bc, echo, etc, and don't forget some logic to verify it's a good poll... if you're running Windows, I know it can be done about the same way, but I don't do windows, so I gots nuthin')
I have a few calcs in mind for my stuff, but for now I'm trying to get the monitoring thing I've started with to a point I'm happy with... not quite there yet.. Thanks though...
EDIT: I should have read your original post better.. :p
What I suggested would work to put the data into a HTML page or spreadsheet, but wouldn't be good enough for a real application... that was just an idea for a hack to make your sheet work...
