Home » WinForms » Excel for .NET » Existing Formulas in XLS

Existing Formulas in XLS

WinForms

ComponentOne's WinForms controls
Details
  • 1 Reply
  • 0 Subscribers
  • 436 days old
Options

Existing Formulas in XLS

  • rated by 0 users
  • This post has 1 Reply |
  • 0 Followers
  • Posted by
    on 6-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

     
  • Posted by
    on 8-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)