Cell formula

[Aggie]

Hello,
I am using Linux as the OS and am using the Parseexcel, saveparser
modules to modify an existing xls file.

The xls file is not created using Writeexcel but is a file created
using MS Excel and fto;d to the server as a template file. I need to
then read this file and update a few columns and present it back to
the user.

Filling in the required columns is fine. I have a problem with cells
that have a formula. The cells do not preserve the formula, nor do the
recalculate the values. The cells come up with the previous value
usually #REF's.

e.g.
Template file has
cell F10 and G10 are blank
and H10 has a fomula =SUM(F10:G10) (that as of now will evalue to
#REF! )

now using SAveParser I change the value of
F10 and G10 to 10,20 respectively.
and save the file as new.xls
The excel sheet now 1. in cell H10 doesn't have the formula =SUM
(F10:G10)
nor does it show the calculated sum 30 it still shows #REF!.

Please help.

[jmcnamara]

On Nov 11, 2:27 pm, Aggie <vaawas...@googlemail.com> wrote:
>
>
> Filling in the required columns is fine. I have a problem with cells
> that have a formula. The cells do not preserve the formula, nor do the
> recalculate the values. The cells come up with the previous value
> usually #REF's.

Hi,

Unfortuanately, that is the current behaviour. Rewriting formulas
isn't supported by SaveParser.

John.
--