Excel turns off right after completing text to columns option.

nhn / tui.grid

🍞🔡 The Powerful Component to Display and Edit Data. Experience the Ultimate Data Transformer!

http://ui.toast.com/tui-grid/

MIT License

2.4k stars 386 forks source link

Excel turns off right after completing text to columns option. #1994

Open yoonjeongnam opened 8 months ago

yoonjeongnam commented 8 months ago

Describe the bug

The Excel downloaded from TUI Grid turned off immediately after completing the 'Text to Column' option in Excel2016. When I copied the data and inserted it into a new Excel, it worked fine. The option works fine for new files that have not been downloaded from TUI Grid.

Please see the zip file below.

IMG_9551.mov.zip

Test Environment

Desktop
Windows
Chrome
Excel v2016

yoonjeongnam commented 7 months ago

I found out that this is happening because of xlsx. xlsx does not officially support the 'Text to Column' option in Excel v2016. By any change, are you planning to change the Excel export library to something else? It seems work with ExcelJS...