Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Can't Handle Structured References #102

Open
Kyle1297 opened this issue Dec 4, 2022 · 3 comments
Open

Can't Handle Structured References #102

Kyle1297 opened this issue Dec 4, 2022 · 3 comments

Comments

@Kyle1297
Copy link

Kyle1297 commented Dec 4, 2022

It doesn't seem like xlsx-calc can handle structured references yet.

See some of the errors that I am getting when the exec/check_variable function is ran (in the Exp.js file):

[Exp.js] - H32: evaluating TRANSPOSE(_xlws.SORT(TRIM(UNIQUE(_xlws.FILTER(DataTable1[Product],(DataTable1[Product]<>"")*(DataTable1[Manufacturer]=F32))))))
Undefined DataTable1[Product]
[Exp.js] - H32: evaluating TRANSPOSE(_xlws.SORT(TRIM(UNIQUE(_xlws.FILTER(DataTable1[Product],(DataTable1[Product]<>"")*(DataTable1[Manufacturer]=F32))))))
Undefined DataTable1[Product]
[Exp.js] - C42: evaluating IFERROR(IF(VLOOKUP(INDEX(Table3[Supplier],MATCH('10. Data Stuff - Hidden'!B42,Table3[Composition],0)),$F$3:$G$32,2,FALSE)>0,OFFSET($F$3,MATCH('1. CarbonFootprint- User Fields'!C32,$F$3:$F$32,0)-1,2,1,VLOOKUP('1. CarbonFootprint- User Fields'!C32,$F$3:$G$32,2,FALSE)),""),"")
Undefined DataTable1[Product]
[Exp.js] - H32: evaluating TRANSPOSE(_xlws.SORT(TRIM(UNIQUE(_xlws.FILTER(DataTable1[Product],(DataTable1[Product]<>"")*(DataTable1[Manufacturer]=F32))))))
Undefined DataTable1[Product]
[Exp.js] - H32: evaluating TRANSPOSE(_xlws.SORT(TRIM(UNIQUE(_xlws.FILTER(DataTable1[Product],(DataTable1[Product]<>"")*(DataTable1[Manufacturer]=F32))))))
Undefined DataTable1[Product]
/Users/kylegriffin/Documents/kyle/grounded/vulcan/sustainability/node_modules/xlsx-calc/src/index.js:16
          throw error
          ^

Error: Undefined DataTable1[Product]
    at checkVariable (/Users/kylegriffin/Documents/kyle/grounded/vulcan/sustainability/node_modules/xlsx-calc/src/Exp.js:64:19)
    at exec (/Users/kylegriffin/Documents/kyle/grounded/vulcan/sustainability/node_modules/xlsx-calc/src/Exp.js:81:25)
    at Exp.self.calc (/Users/kylegriffin/Documents/kyle/grounded/vulcan/sustainability/node_modules/xlsx-calc/src/Exp.js:171:9)
    at exec (/Users/kylegriffin/Documents/kyle/grounded/vulcan/sustainability/node_modules/xlsx-calc/src/Exp.js:84:45)
    at Exp.self.calc (/Users/kylegriffin/Documents/kyle/grounded/vulcan/sustainability/node_modules/xlsx-calc/src/Exp.js:147:9)
    at /Users/kylegriffin/Documents/kyle/grounded/vulcan/sustainability/node_modules/xlsx-calc/src/UserFnExecutor.js:19:67
    at Array.map (<anonymous>)
    at UserFnExecutor.self.calc (/Users/kylegriffin/Documents/kyle/grounded/vulcan/sustainability/node_modules/xlsx-calc/src/UserFnExecutor.js:19:58)
    at Exp.self.calc (/Users/kylegriffin/Documents/kyle/grounded/vulcan/sustainability/node_modules/xlsx-calc/src/Exp.js:200:32)
    at /Users/kylegriffin/Documents/kyle/grounded/vulcan/sustainability/node_modules/xlsx-calc/src/UserFnExecutor.js:19:67
@Kyle1297
Copy link
Author

Kyle1297 commented Dec 4, 2022

@fabiooshiro

@Kyle1297
Copy link
Author

Kyle1297 commented Dec 4, 2022

Oh this might be related to this issue: #88

@fabiooshiro
Copy link
Owner

Could you send a json example with the DataTable?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@fabiooshiro @Kyle1297