tabulator
tabulator copied to clipboard
rowHeader breaks table.import("xlsx")
Describe the bug rowHeader breaks table.import("xlsx").
While trying to add import/export to a Tabulator table with row selection I noticed that the row selection column seems to slurp a bit of data and generally confuse the import.
Tabulator Info Version 6.3
Working Example https://jsfiddle.net/sw18p09j/2/
To Reproduce A step by step guide to recreate the issue in your JS Fiddle or Codepen:
- Export
- Import the generated export.xlsx
Expected behavior The data should survive the roundtrip.
Screenshots
Before import:
After import:
The table gets incorrectly populated and always with an extra row (but that seems to be a different problem).
Desktop (please complete the following information): Same result with firefox on linux and chrome on windows
I can confirm the same issue. I also noticed that this will occur with hidden columns. It seems the upload is completely column position/index-based. Is there a way to reliably map the Excel field name to the Tabulator column field name?