Tracing Precedents and Dependents

Last post 02-13-2012, 3:48 AM by aspose.notifier. 8 replies.
Sort Posts: Previous Next
  •  01-17-2012, 7:01 AM 355679

    Tracing Precedents and Dependents .NET

    We are using the Aspose Cells.Net v7.0.3.0 library. With reference to the below articles, we would like to retrieve the Precedents and Dependents of a cell. We are currently unable to retrieve the Dependent Cell values:


    Our requirement is to retrieve both the direct and in-direct Dependents of the cell.

    Please advice as how to proceed.
    Filed under: api
     
  •  01-17-2012, 12:39 PM 355771 in reply to 355679

    Re: Tracing Precedents and Dependents

    Hi,

    I am afraid, the feature is not available at the moment, I have logged a ticket for your needs with an id: CELLSNET-40294. We will look into it soon.

    Thank you.

    Amjad Sahi
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     
  •  01-18-2012, 1:29 PM 356076 in reply to 355771

    Re: Tracing Precedents and Dependents .NET

    Hi Amjad,

    Thanks for creating a support ticket on this. Could you please provide me a tentative timeline of when the above can be expected?

    Also while going through the Forum posts, I came across an implementation of the getDependents method which was discussed in 2007.


    If this feature was available in a previous version of the library, could you please confirm in which version it was available and why it is not available in the latest version?

    Thanks in advance.
    Filed under: api;missing
     
  •  01-18-2012, 9:27 PM 356122 in reply to 356076

    Re: Tracing Precedents and Dependents

    Hi,

    I am afraid, this feature is not available and we will support it later.

    As Amjad has already logged the New Feature Request in our database. Once, we will implement this feature or we have any other update for you, we will let you know asap.

    Many Thanks and Kind Regards,

    Shakeel Faiz
    Support Developer
    Aspose Sialkot Team
    Contact Us
    Aspose - The .NET and Java Component Publisher

    Keep in touch! We're on Twitter and Facebook
     
  •  01-19-2012, 4:11 AM 356197 in reply to 356076

    Re: Tracing Precedents and Dependents

    Hi,

    Please download and try this fix: Aspose.Cells for .NET v7.1.0.1

    We have added Cells.GetDependents(bool isAll, int row,int column) method.


    Many Thanks and Kind Regards,

    Shakeel Faiz
    Support Developer
    Aspose Sialkot Team
    Contact Us
    Aspose - The .NET and Java Component Publisher

    Keep in touch! We're on Twitter and Facebook
     
  •  01-19-2012, 6:16 AM 356229 in reply to 356197

    Re: Tracing Precedents and Dependents .NET

    Hi Shakeel,

    Many thanks to you and Amjad for the quick turn-around. I have used the fix provided and following are my queries:
    1. Is there any difference between the "public Aspose.Cells.Cell[] GetDependents(bool isAll)" and "public Aspose.Cells.Cell[] GetDependents(bool isAll, int row, int column)" methods?
    2. Currently the above methods return the first-level (direct) dependency. Is there any API that would retrieve the in-direct (multi-level) dependencies also? I am not comfortable with looping and getting each cell dependency recursively and I dont think that would be a good idea... Please advice.
    3. Also please advice, what would be the best way to implement the above, keeping in consideration performance and memory management.
    Thanks in advance.

    --
    Adnan
    Filed under: api
     
  •  01-19-2012, 9:30 PM 356389 in reply to 356229

    Re: Tracing Precedents and Dependents

    Hi,

    1) Cells.GetDependents(bool isAll) is same as Cell.GetDependents(bool isAll, int row, int column)

    The parameter “isAll” means whether to check all worksheets in the workbook.

    2) and 3) We don’t support get multi-level dependents of the cell now. We will look into it later.


    Many Thanks and Kind Regards,

    Shakeel Faiz
    Support Developer
    Aspose Sialkot Team
    Contact Us
    Aspose - The .NET and Java Component Publisher

    Keep in touch! We're on Twitter and Facebook
     
  •  01-20-2012, 4:55 AM 356463 in reply to 356389

    Re: Tracing Precedents and Dependents .NET

    Thanks,

    Looking forward to this implementation.
     
  •  02-13-2012, 3:48 AM 361028 in reply to 355679

    Re: Tracing Precedents and Dependents

    The issues you have found earlier (filed as CELLSNET-40294) have been fixed in this update.


    This message was posted using Notification2Forum from Downloads module by aspose.notifier.
     
View as RSS news feed in XML