Jan 29, 2013 at 5:06 PM
Edited Jan 30, 2013 at 1: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...
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.