C1 Community
ComponentOne Community is a free source for developers and help authors to collaborate and communicate.
Forums » WinForms » XLS for WinForms » Existing Formulas in XLS

Existing Formulas in XLS

rated by 0 users
This post has 1 Reply | 0 Followers

Top 500 Contributor
Posts 18
Reply
ILDEVERT1 Posted: Wed, Jun 24 2009 11:32 AM

Hi,

 

I have an existing spreadsheet that is used as a template to send out some reports in excel.

 

The issue I am having is that every time I feed the xls file with the data, the formulas contained within the xls file does not update.  Even after it has been saved and/or reopened. Whenever I manually press the F2 key and enter, it works fine (gets updated).

 

I saw a few post back in 2006 saying that C1 does not support formulas. Is this still the case?  Any work around?

 

Thanks!!!

 

Alex

 

Top 25 Contributor
Posts 456
Reply
C1_JamesS replied on Fri, Aug 7 2009 4:39 AM
Hello Alex,
 
Currently Formulas are not loaded or saved however. If you load files that contain formulas and then save them back, the formulas will be removed. This is in contrast to the traditional xls (Biff8) format, which does preserve the formulas.
 
I hope this helps.
 
Have a nice day.
 
Regards,
James Smith
<ILDEVERT1> wrote in message news:219320@10.0.1.98...

Hi,

 

I have an existing spreadsheet that is used as a template to send out some reports in excel.

 

The issue I am having is that every time I feed the xls file with the data, the formulas contained within the xls file does not update.  Even after it has been saved and/or reopened. Whenever I manually press the F2 key and enter, it works fine (gets updated).

 

I saw a few post back in 2006 saying that C1 does not support formulas. Is this still the case?  Any work around?

 

Thanks!!!

 

Alex

 


http://helpcentral.componentone.com/cs/forums/p/79661/219320.aspx#219320

Page 1 of 1 (2 items) | RSS
Contact ComponentOne: 1.800.858.2739 ©1987-2010 ComponentOne LLC All Rights Reserved.