Hi again,

I've tried to export a Views spreadsheet to both XLS and XLSX format and the fields containing formulas do not export correctly. For instance, the field containing the formula "COUNTA("finalreport"!A1:A1000)" returns the following error in the XLSX file: "Could not export formula COUNTA("finalreport"!A1:A1000). Is there any workaround for this? Unfortunately if not it means I'm stuck in terms of exporting these views, as they rely heavily on formulas. Thanks in advance for any help.

Comments

willhallonline’s picture

willhallonline
Primary language English
Location Cambridge, UK
CreditAttribution: willhallonline as a volunteer commented
Issue summary: View changes
Status: Active » Closed (outdated)

Can you please try again with PHPExcel 1.7.8 and the latest version of Sheetnode and socialcalc library please? I believe that this is now resolved.