You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Currently, when the xlsx template is filled, the styling is not adjusted to the contents at all. So if the template has the first 20 rows styled, everything below the range will be unstyled.
From the usability point this is not optimal. Everyone has to reformat/autoformat again as a first step after download. We should copy the format of the 3rd row (the first data row) to all used rows below (and maybe 100 rows more to prepare for additions).
See openpyxl styles for which styles to copy / assign to the cell. The formatting has to be done cell-by-cell. There is no build in function (I am aware of) for copying all styles from one row to the next.
The text was updated successfully, but these errors were encountered:
Currently, when the xlsx template is filled, the styling is not adjusted to the contents at all. So if the template has the first 20 rows styled, everything below the range will be unstyled.
From the usability point this is not optimal. Everyone has to reformat/autoformat again as a first step after download. We should copy the format of the 3rd row (the first data row) to all used rows below (and maybe 100 rows more to prepare for additions).
See openpyxl styles for which styles to copy / assign to the cell. The formatting has to be done cell-by-cell. There is no build in function (I am aware of) for copying all styles from one row to the next.
The text was updated successfully, but these errors were encountered: