Filled horizontal alignment

[bpranoto]

Does FPSpreadsheet support filled horizontal alignment?

The tsHorAlignment set only has haDefault, haLeft, haCenter and haRight

Thank you.

[wp]

You mean justified alignment in which the widths of the spaces are adjusted so that the cell text is aligned at both left and right sides? This was not supported because the LCL drawing styles do not cover this case. But on the other hand, somebody who only wants to read/write files may be missing it. Therefore, I just extended the TsHorAlignment enumeration by an element haJustify:

Code: Pascal  [Select][+][-]

1. type
2.   TsHorAlignment = (haDefault, haLeft, haCenter, haRight, haJustify);

This is supported now by xlsx, xls (Excel 8, Excel 5), Excel xml, OpenDocument ods for both reading and writing.

But note that the new version is only available on CCR so far. For installation you must use svn, or you download the zipped snapshot from https://sourceforge.net/p/lazarus-ccr/svn/HEAD/tree/components/fpspreadsheet/.

[bpranoto]

You mean justified alignment in which the widths of the spaces are adjusted so that the cell text is aligned at both left and right sides?

No, with fill horizontal alignment, the text cell value is repeated so it fills the cell width

[TRon]

No, with fill horizontal alignment, the text cell value is repeated so it fills the cell width

I am sure I misunderstand but can you show a picture of how something like that should look like ?

As I interpret that statement it is something that I have never seen before in a spreadsheet.

[bpranoto]

Libreoffice has 5 horizontal alignment: Default, Left,Center,Right,Justified,Filled and Distributed.

In the attachment, the A1 cell's text value is =, when we apply the Filled horizontal alignment it draws repeated = occupy the cell width

[TRon]

Thank you very much for the picture and explanation bpranoto.

You have thought me something new about spreadsheets (at least about formatting cells)  (I never used that feature before)

As far as I know fpspreadsheet (currently) does not have provision for that. As author wp is able to tell more.

[bpranoto]

You mean justified alignment in which the widths of the spaces are adjusted so that the cell text is aligned at both left and right sides?

This is called Distributed alignment

Justified alignment is different:

• if the text is only 1 row, it is left aligned
• if the text is wrapped to multiple rows, rows before the last row is aligned to left and right, but the last row is left aligned

See the difference In the attachment, cell A6 is distributed  while cell A10 is justified

[bpranoto]

Thank you very much for the picture and explanation bpranoto.

You have thought me something new about spreadsheets (at least about formatting cells)  (I never used that feature before)

As far as I know fpspreadsheet (currently) does not have provision for that. As author wp is able to tell more.

You're welcome TRon. This feature is useful for a balance sheet financial report like in the attachment.

[wp]

Here you are: r9348 supports justified, distributed and filled alignments:

Code: Pascal  [Select][+][-]

1. TsHorAlignment = (haDefault, haLeft, haCenter, haRight, haJustified, haDistributed, haFilled);

[bpranoto]

Thank you very much wp..