1) Right now I first download my results csv file to my computer and then open it in Openoffice Calc (v.2.2). I'd like to eliminate step 1 (i.e. open my results in Calc directly from the FA server) Calc is capable to link to external data via the INSERT menu. What URL should I enter in the EXTERNAL DATA dialog?
2) MS Excel (I'm using Excel 2004 Mac) also seems to have the ability to link to external data, but as far as I understand it requires you to purchase and install an ODBC driver. Is this mandatory? Do you know about any other mean for Excel to link to ext. data without purchasing an installing additional software?
At this time you can only export the data through our website. Does OpenOffice allow you to provide a username and password (HTTP authentication) when you retrieve data using a URL?