Cells with external references

Posted by: djmelan on 11 July 2018, 1:04 pm EST

  • Posted 11 July 2018, 1:04 pm EST

    Excel formulas can contain references to cells in other workbooks, such
    ='C:\Reports\[Budget.xlsx]Annual'!B3
    . If the referenced file is not present, or if external reference updates are disabled, Excel displays the formula's most recently calculated value. You can even move the spreadsheet to another machine and it will retain the cached value. Does Documents for Excel provide any way in to retrieve this cached value? When I call something like
    sheet.Range("A1").Value
    on a cell with an external reference, I get always get either zero or 4 (no idea why it returns 4, the actual value is nothing like 4). I can understand why Documents for Excel doesn't support dynamic update of cells with external references, but it seems like it should be able to provide the cell's cached value. Is this possible?
  • Replied 12 July 2018, 6:54 am EST

    Hello,

    We could observe the cell value retaining the referenced value in a sheet properly.
    We referred a cell's value from the first sheet to a cell in the second sheet, deleted the first sheet and saved the workbook.
    The second sheet retains the value even when the first sheet is deleted and also when it is moved on to another machine.
    We have attached the sample we used to check the scenario with the 1.5.0.3 Grapecity.Documents.Excel package version.

    Let us know if we are missing on something in the sample. Also, you can modify the same and share it back so that we can assist you further in the correct manner.

    Thanks,
    Esha
    prj_GcExcel_ExternalReference.zip
  • Replied 19 July 2018, 2:22 pm EST

    Here is an example project that demonstrates the problem. Start by opening the included Excel file in Excel. Note that cell A1 displays the value 5. Next, run the attached project. Note that the value of cell A1 reported by GcExcel is 0, not 5.GcExcel_ExternalReference_Revised.zip
  • Replied 20 July 2018, 3:29 am EST

    Hello,

    Thanks for sharing the modified sample.
    We are discussing this with the development team [Internal Tracking ID: 334749] and will get back to you once it is done.

    Best Regards,
    Esha
  • Marked as Answer

    Replied 19 September 2018, 12:23 am EST

    Hello,

    The issue has been resolved with the latest 1.5.0.4 package (https://www.nuget.org/packages/GrapeCity.Documents.Excel/).
    Kindly check with the same at your end and let me know if you need any further assistance.
    Release notes: http://help.grapecity.com/gcdocs/gcexcel/readme/webframe.html#rnotes1.5.0.4.html

    Best Regards,
    Esha
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels