Is it possible to add the autofit feature?

rabanti-github / PicoXLSX

PicoXLSX is a small .NET / C# library to create XLSX files (Microsoft Excel 2007 or newer) in an easy and native way

MIT License

52 stars 13 forks source link

Is it possible to add the autofit feature? #23

Open justaRandomCoder opened 1 year ago

rabanti-github commented 1 year ago

Hello, This feature is in the Backlog for v3.x of NanoXLSX: https://github.com/rabanti-github/NanoXLSX/wiki/Backlog However, the task is not that easy, since there must a full capable font parser (to get letter widths/height and spacings) be in place, as well as a style parser (e.g. to determine the output of a formatted date) and ideally also a fully implemented formula parser, since formulas will certainly change the actual cell content. However, there is not yet a timeline for this

justaRandomCoder commented 1 year ago

Thank you for your propmpt response, one more thing, there is no option currently to disable the gridlines in an excel sheet, have you thought about adding that as well?

rabanti-github commented 1 year ago

The feature (and other View features) are not yet implemented. But it looks like they are very easy to implement in the Worksheet class. I will probably do this the next few days, for this library, as well as for nanoXLSX v2.x and NanoXLSX4j. Should not be a problem

rabanti-github commented 1 year ago

The following features were added right now with the new release v3.2.0:

Added worksheet option for zoom factors
Added worksheet option for view types (e.g. page break preview)
Added worksheet option to show or hide grid lines
Added worksheet option to show or hide columns and row headers
Added worksheet option to show or hide rulers in page layout view type

Autofit is still on backlog though.