How to export a ZK spreadsheet(3.0) with value ONLY

asked 2013-12-20 04:34:34 +0800

mcfong
0

Hi, I currently run into a problem on exporting a spreadsheet with customized formula. Consider the following scenario, I have A1 = 1; A2 = 2; A3 = myAdd(A1, A2) = 3 (In this example, formula myAdd works as SUM) Everything works fine, and I would like to export it as xls file.

I open the exported with Excel, I have A1 = 1; A2 = 2; A3 still has myAdd(A1, A2), which caused an Error:509. It makes sense, because the Excel does not recognize my custom function.

So, my question would be is there a way (or workaround) that I can export the value (in this case, 3) instead of the formula on cell A3?

Thanks in advance!