dhatim / fastexcel

Generate and read big Excel files quickly
Other
647 stars 116 forks source link

Is there a way to indent text in a cell #309

Open dgappc opened 11 months ago

dgappc commented 11 months ago

Excel has formatting to indent a cell by a number of characters (see image below). Is there a way to set this format using fastexcel?

Thanks

image

dgappc commented 11 months ago

If indentation is difficult to support, a workaround can be to allow leading spaces when setting String values in a cell.

Currently if I try to set a string with any leading spaces, the spaces get automatically removed by FastExcel.

POI which we used previously does not behave that way

Thanks

JakKowalCzyk commented 8 months ago

@dgappc have you discovered how to set indentation with the fastexcel?

dgappc commented 8 months ago

No, I have not. You can use hard spaces "\u00a0" instead of regular space, but we don't like that, it interferes with search.

JakKowalCzyk commented 8 months ago

I see, thanks anyway