xlsxtream icon indicating copy to clipboard operation
xlsxtream copied to clipboard

Option to add empty cells

Open kukicola opened this issue 5 years ago • 1 comments

Hello again! I had one more issue with this gem. It's a pretty strange excel formatting behavior - if a cell with an overflowing text is next to the cell which does not exist in file it allows the text to overflow. Example: Zrzut ekranu 2020-04-17 o 18 30 51 Adding blank cell after this one fixes the issue: Zrzut ekranu 2020-04-17 o 18 31 28 On my fork I dealt with it by just removing condition to skip empty cells: https://github.com/paladinsoftware/xlsxtream/pull/2/files

Maybe it would be good to introduce an option like empty_cells: which is false by default. I can create a PR if you think that it can be useful.

kukicola avatar Apr 17 '20 16:04 kukicola

This is expected behavior in Excel and not something that xlsxtream should try to work around imao. I'd vote for closing this isssue.

sandstrom avatar Jun 02 '21 15:06 sandstrom