open, edit and save

Jan 29, 2013 at 6:06 PM
Edited Jan 30, 2013 at 2:46 PM

I need to open an excel 97-2003 file that is heavliy formatted.  Save data to specific cells, then save it under a new name.  Easy as pie with Interop but too costly.

Have tried 8 other open source gigs with no luck.  Did get one to save, but lost all formatting.

NPOI seems to be the answer...

but

If I have a calculation in C5 and it relies on a value from C4...no matter what I put in C4, the calc does not run?  Thoughts?

I have tried format as number or put in a number to no avail.

Jan 30, 2013 at 3:55 PM

Never mind, found it (violated the "serach first" mantra)   recalculate = true