Sign UpSign Up   Sign InSign In Welcome Guest,
Live Chat Live Chat
Aspose.com » Public Forums for Customers an... » Aspose.Cells Product Family » Aspose Cells

Aspose Cells

Last post 09-04-2010, 12:28 AM by kartiken. 4 replies.
Sort Posts: Previous Next

  •  06-21-2010, 1:52 AM 244432

    Aspose Cells .NET

    Hi,

              I am using Aspose cells 4.0 version for reporting. in the reporting template i have 8 sheets. i am adding one row using Asp.net program in the first sheet the 4 th sheet has some formulas refer to the first sheet. while adding the row the 4 th sheet formulas are not updating can you help me on this

    i have given some coding examples to adding the row i could not attach the excel file because it is highly confidential file    

    Aspose.Cells.Worksheet theAPWorksheet;

    Aspose.Cells.Workbook theAPWorkbook = new Aspose.Cells.Workbook();

    serverpath = Server.MapPath(".") + "\\Template\\OutputTemplate.XLS";

    theAPWorkbook.Open(serverpath);

    theAPWorkbook.Worksheets[1].Cells.InsertRow(OuterCount + Convert.ToInt32(dtcount.Rows[0].ItemArray[0]) - 1);

     

     

    Regards,

     

    Unichem
     

  •  06-21-2010, 2:14 AM 244436 in reply to 244432

    Re: Aspose Cells

    Attachment: Present (inaccessible)
    Hi,

    Please try the attached version (latest fix v5.0.0.1), if you still find the issue, kindly post your template excel file here, we will check your issue soon.

    Thank you.
    Amjad Sahi
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     

  •  09-02-2010, 6:35 AM 256801 in reply to 244436

    Re: Aspose Cells .NET

    Attachment: Present (inaccessible)

    Dear sir/Madam,

             this version is not supporting . i have enclosed the sample format sheet3 has formula referred with sheet1 i.e(=Sheet1!A3) . if i add one row between A3 it automatically change to =Sheet1!A4

     

    please help me on this it is very urgent

    awaiting for your positive feedback

     

    Regards,

     

    Unichem

    Chennai.

     

     
     

  •  09-03-2010, 11:22 PM 257067 in reply to 256801

    Re: Aspose Cells

    Hi,

    Thanks for the template file.

    Please use Cells.InsertRows method instead of InsertRow, you may pick an overloaded version of the method i.e..,
    InsertRows(rowIndex, totalRows, updateReference) ---> set "true" for the third parameter.
    e.g

    //Insert a row at A3 location and update references in other sheets of the book.
    theAPWorkbook.Worksheets[0].Cells.InsertRows(2,1, true);


    Thank you.
    Amjad Sahi
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     

  •  09-04-2010, 12:28 AM 257072 in reply to 257067

    Re: Aspose Cells

    Hi,

           Thanks for your valuable suggestion. now i resolved the problems. thanks a lot

     

    Regards

    Kartik

    Unichem
     
View as RSS news feed in XML
© Aspose 2002-2012. All Rights Reserved. LinkedIn YouTube Twitter Facebook RSS