[Excel] Add Building block

Question

Closed this issue 2 months ago · 3 comments

Answer 1 · 2024-07-09T08:23:27.000Z

Create annotation table ->

Building blocks adapt existing annotation table
Only one input and output and everything under more per table
Data can contain multiple columns (still in review)
Component columns: Id, name & source important
All reference columns shall be hidden, main column visible (e.g. main: degree celsius, reference: term and unit association)
Building blocks because more than one column can be added per building block
E.g. term has 3 columns, unit has 4 columns
When column is chosen -> add building block next right to it, otherwise at the end of the table

Answer 2 · 2024-07-09T08:25:11.000Z

Potential process:
Read current annotation table in excel, adapt it with building blocks and write it anew

Answer 3 · 2024-07-09T08:30:30.000Z

Helper functions -> toNumberFormat & ofNumberFormat in Shared for help
Information in spreadsheet update -> AddAnnotationBlock