Cells with external references

Cells with external references

Posted by: djmelan on 11 July 2018, 4:04 am EST

• 

  djmelan

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 11 July 2018, 4:04 am 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

• 

  esha.dhir

  

  • Post Options:
  • Link
    Copy

  Posted 11 July 2018, 9:54 pm 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

• 

  djmelan

  • Post Options:
  • Link
    Copy

  Posted 19 July 2018, 5:22 am 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

• 

  esha.dhir

  

  • Post Options:
  • Link
    Copy

  Posted 19 July 2018, 6:29 pm 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

• 

  esha.dhir

  

  • Post Options:
  • Link
    Copy

  Posted 18 September 2018, 3:23 pm 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