Telerik Document Processing Feedback Portal
Back to Feed
Request a Feature Report a Bug
Unplanned
Last Updated: 14 Jun 2024 08:50 by ADMIN
ADMIN
Tanya
Created on: 20 Jun 2017 08:10
Category: SpreadProcessing
Type: Feature Request
17
SpreadProcessing: Add support for external references to another workbook
With the current implementation, references like in the following expression cannot be evaluated and are treated as strings:
=SUM('C:\Users\Your user name\Desktop\[Workbook_1.xlsx]Sheet1'!A1:B2)
4 comments
ADMIN
Yoan
Posted on: 14 Jun 2024 08:50

Hi Stefan,

You are indeed correct as this task is solely about the support for external references. As you may already know we already have a separate feature request logged in our Feedback Portal about obtaining the cached value of formulas containing such external references - SpreadProcessing: Handle importing and reading cached formula value when the formula contains external references.

That said, this task (SpreadProcessing: Add support for external references to another workbook) is currently not on our roadmap for the foreseeable future and I also wouldn't want to mislead you by giving you any incorrect information just for the sake of it. Once any item is resolved, we immediately update the public feedback page to notify our clients so the best thing I can offer is to subscribe to the task in order to track its progress and don't miss potential updates.

If you have any questions about any of these two tasks feel free to continue the conversion in their respective threads.

Thank you for your understanding.


Regards,
Yoan
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Stefan
Posted on: 10 Jun 2024 11:15
I have an XLS with "= LOOKUP(somewhere in space without access)" from external.


Excel shows the value the creator got through the lookup and THIS value I want to get - of course too.
Support is mixing this up.
This is for accessing and running external formulas, but not to get the "cached" value from the creator.
ADMIN
Tanya
Posted on: 28 Mar 2018 10:47 
Hi Vasssek,

This task is currently not scheduled. Make sure to cast your vote for its implementation and continue following this item so you can get notifications when its status changes.

Regards,
Tanya
Vasssek
Posted on: 20 Feb 2018 14:01 
Based on this thread https://www.telerik.com/forums/export-excel-datetime-field-display-seconds#2Kvc433IbkWLDe624n--vw , when it will be included ?

Best regards
Vasssek
Create an account Log In
View
Type
Status
Category