Fill In a Series of Formulas

4 posts, 0 answers
  1. jafar
    jafar avatar
    9 posts
    Member since:
    Feb 2013

    Posted 30 Mar 2013 Link to this post

    Hello,
    I need Fill In a Series of Formulas in cellselection .
    for example :
     
     this.radSpreadsheet.ActiveWorksheet.Cells[0, 1].SetValue("=A2");
     this.radSpreadsheet.ActiveWorksheet.Cells[0, 2].SetValue("=B2");
     CellSelection selectionA1A6 = this.radSpreadsheet.ActiveWorksheet.Cells[new CellRange(new CellIndex(0, 1), new CellIndex(0, 7))];

    selectionA1A6.FillData(CellOrientation.Horizontal);

    and in result I want to have : 

    =A2  | =B2 | =C2 | =D2 |...

    for per column generate a formula.
    but in this version just repeat =A1 | =B2 | ... .

    Do you have a solution for this problem?
    Thanks
  2. Nikolay Demirev
    Admin
    Nikolay Demirev avatar
    103 posts

    Posted 01 Apr 2013 Link to this post

    Hi Jafar,

     You just have to use FillDataSeriesAuto instead of FillData. Here is an example:

    this.radSpreadsheet.ActiveWorksheet.Cells[0, 1].SetValue("=A2");
    this.radSpreadsheet.ActiveWorksheet.Cells[0, 2].SetValue("=B2");
    CellSelection selectionA1A6 = this.radSpreadsheet.ActiveWorksheet.Cells[new CellRange(new CellIndex(0, 1), new CellIndex(0, 7))];
     
    selectionA1A6.FillDataSeriesAuto(CellOrientation.Horizontal, true);


    Greetings,
    Nikolay Demirev
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  3. DevCraft banner
  4. jafar
    jafar avatar
    9 posts
    Member since:
    Feb 2013

    Posted 06 Apr 2013 Link to this post

    Hello
    this code repeat =A2 | =B2 formula in other columns 
    but I want to set other columns to  C2 | D2 | ... . 
    I need Fill In a Series of Formulas in cellselection according to column names.

    can you help me?
    Thanks

  5. Nikolay Demirev
    Admin
    Nikolay Demirev avatar
    103 posts

    Posted 08 Apr 2013 Link to this post

    Hello Jafar,

    This issue is fixed in the Q1 2013 SP1 version of RadControls for Silverlight and works in the way you explained. I suggest you update your binaries to the latest version and use the code I sent earlier.

    Kind regards,
    Nikolay Demirev
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

Back to Top