TemplaterExamples icon indicating copy to clipboard operation
TemplaterExamples copied to clipboard

In-cell drop-down is Excel not processed correctly?

Open asmaier opened this issue 1 year ago • 2 comments

I have a file with a table, where two columns (E and F) consist of values, which the user can select from a in-cell drop-down list

test_dropdown

The row A2 to F2 is marked as range. However when I process some example data with templater like

java -jar templater-json.jar test_dropdown.xlsx test_data.json test_dropdown_out.xlsx

the the output cells in column E and F will not be in-cell drop-downs anymore:

test_dropdown_out

It seems to me templater is just reading the value of the cell, but does not seem to recognize, that the cell allows for a selection of values from a drop-down list.

Am I doing something wrong here? Or is this not something not possible with templater?

Here are the test files:

test_data.json test_dropdown_processed.xlsx test_dropdown.xlsx

asmaier avatar Jul 25 '24 09:07 asmaier

This Excel features does not seem to be supported currently. I'll look into what would it take to support it.

zapov avatar Jul 25 '24 17:07 zapov

Thank you for the quick response. This feature would be really interesting for my employer, because they have many Excel sheets with these dropdown lists.

asmaier avatar Jul 29 '24 07:07 asmaier

v8.1.0 released and this is now supported

zapov avatar Sep 24 '24 19:09 zapov

Wow, thank you very much!

asmaier avatar Sep 27 '24 15:09 asmaier