Aspose is able to access data cached in local Excel files from previous connections to no longer available external data sources.
Hi,
Yes, but is there a way to directly access those cached values in the referencing workbook? In our situation the externally referenced data source is not available so we do not want to try and update the values. We want that cached value if it is available. Aspose renders the cached values when reading the data from the sheet into a datatable or when rendering a PDF. That is great. But I would like to identify if any values are being read from a cache so the user can be warned that some displayed values may not be consistent with what is shown on other renderings of the same workbook.
Hi,
Hi,
We think you do no need to access the cache directly.<o:p></o:p>
1) "But I would like to identify if any values are being read from a cache so the user can be warned that some displayed values may not be consistent with what is shown on other renderings of the same workbook."
Please use Cell.ContainsExternalLink property to check whether a cell contains external link.
2) " I would like to test the Excel file to know if it contains cached values prior to converting it to a PDF. We generate HTML previews of Excel files by reading the raw datasets of each worksheet and these will display the cached values. We also create PDF's using non-Aspose libraries depending on the user's requirements. These PDF do not always reflect the cached values."
It means that the values of the cells are correct if you can read the cached values by reading the raw datasets of the checck worksheet.
If the generated PDF file do not reflect the cached values, the formulas must be recalculated and incorrect values are returned.
Please check which libraries recalculated the file?
Thank you.