PicoXLSX icon indicating copy to clipboard operation
PicoXLSX copied to clipboard

Is it possible to add the autofit feature?

Open justaRandomCoder opened this issue 2 years ago • 4 comments
trafficstars

justaRandomCoder avatar Aug 28 '23 06:08 justaRandomCoder

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

rabanti-github avatar Aug 29 '23 18:08 rabanti-github

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?

justaRandomCoder avatar Aug 30 '23 04:08 justaRandomCoder

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 avatar Aug 30 '23 19:08 rabanti-github

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.

rabanti-github avatar Sep 07 '23 21:09 rabanti-github