Re:Show HN: Datagridxl.js – No-nonsense fast Excel-like data...
by robbiejs on Wednesday July 22, 2020 @03:26PM
(#23920625)
I am not sure if this is actually a bug, that will probably also happen when pasting those two lines to Excel or G. Sheets. Correct me if I'm wrong.
[ Parent
| on HN ]
Re:Show HN: Datagridxl.js – No-nonsense fast Excel-like data...
by janci on Wednesday July 22, 2020 @04:56PM
(#23921486)
Yes, it is possible to paste cells in excel and shift cells below in Excel. But here the cells are shifted if the corrupted cell is visible and shift back if it's not. Definitely a bug.
Re:Show HN: Datagridxl.js – No-nonsense fast Excel-like data...
by robbiejs on Wednesday July 22, 2020 @05:09PM
(#23921614)
Ah I think I know what you mean now. I think you mean when you paste multi-line text inside the cell value editor! You're right, thanks for spotting it!
This does not happen when you paste when the editor is not open, am I correct?
Re:Show HN: Datagridxl.js – No-nonsense fast Excel-like data...
by janci on Saturday July 25, 2020 @01:41PM
(#23951008)
Yes, exactly.
Re:Show HN: Datagridxl.js – No-nonsense fast Excel-like data...
by robbiejs on Monday July 27, 2020 @01:10PM
(#23967095)
Hi janci, just letting you know that the bug has been fixed. Thank you for spotting it!
The current solution that I came up with: replace \n with Return HTML-entity. Not sure if that is the best solution for you (or anybody else) but at least it prevents the unwanted shift of column contents.
Thanks again!