pyExcelerator

Tracker: Patches

5 Avoid blank formula cells needing manual recalc - ID: 1607006

Last Update: Comment added ( gwashburn )

Details:

Quoting from this blog post, http://www.petersblog.org/node/1105:

> I ran the formula demo and it created a spreadsheet
> but when I opened it in Excel 97 and all the cells
> were blank. The formulas were in it but needed manual
> recalculating (F2 and enter, one by one).

Attached is the patch he did to solve that problem. See the blog posting
for more info.

Submitted:

Christian Hudon ( chrish42 ) - 2006-12-01 17:27

Priority:

Status:

Closed

Resolution:

Fixed

Assigned:

Nobody/Anonymous

Category:

None

Group:

None

Visibility:

Public

Comment ( 1 )

Date: 2007-02-14 05:08 Sender: gwashburn Actually that solution creates broken excel files. I presume that Excel sees that the result is not valid and does a recalculation on the field. Regardless, I've made a more generic fix to the problem in the svn HEAD. Take a look at examples/formulas.py to see how to use the new code.

Log in to comment.

Attached File ( 1 )

Filename	Description	Download
diff.out	Patch	Download

Changes ( 4 )

Field	Old Value	Date	By
status_id	Open	2007-02-14 05:08	gwashburn
resolution_id	None	2007-02-14 05:08	gwashburn
close_date	-	2007-02-14 05:08	gwashburn
File Added	205300: diff.out	2006-12-01 17:27	chrish42

pyExcelerator

Tracker: Patches

Comment ( 1 )

Log in to comment.

Attached File ( 1 )

Changes ( 4 )

About SourceForge

Find Software

Develop Software

Community

Help