ngs-doo / TemplaterExamples

Creating reports in .NET and Java
https://templater.info
The Unlicense
48 stars 27 forks source link

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

Open asmaier opened 1 month ago

asmaier commented 1 month ago

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

zapov commented 1 month ago

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

asmaier commented 1 month ago

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.