Where to post improvement suggestions?

Hi!

Where should I post a suggestion that would improve LibreOffice?

This is about tables in Writer. I went about to create a calendar out of a
table to mark the holidays in December when I noticed how difficult it was
to format the size of table and cells. I feel that not being able to set
width of all cells to an exact number is not good.

What I had to do is figure out initial width that would fit my needs,
multiply by column count, set the table to that calculated width and finally
space out column width evenly.

It would make a lot of sense for the computer to make the calculations and
adjust both cell and table width.

Thanks for reading!

Where should I post a suggestion that would improve LibreOffice?

You can suggest enhancements at the web site; start at https://www.libreoffice.org/get-help/feedback/ . But it is very sensible to discuss ideas here first - as you have done - since you may find both that something of what you need already exists and that others can contribute to your suggested improvements.

This is about tables in Writer. I went about to create a calendar out of a table to mark the holidays in December when I noticed how difficult it was to format the size of table and cells. I feel that not being able to set width of all cells to an exact number is not good.

You can do this.

o If you create an empty table that fills the text width between page margins, the width of all cells will be equal.

o Providing Alignment (on the Table tab of the Table Format dialogue) is not set to Automatic (which you can change after the table is created), you can tick "Adjust columns proportionally" on the Columns tab. If you then use the "Column width" boxes on that tab to change widths, they will all change in step.

o Select relevant columns of your table and go to right-click | Column > | Space Equally.

o Select relevant columns of your table and go to Table | Autofit > | Distribute Columns Evenly.

These last two techniques can be used either for all columns or for some columns only.

What I had to do is figure out initial width that would fit my needs, multiply by column count, set the table to that calculated width and finally space out column width evenly. It would make a lot of sense for the computer to make the calculations and adjust both cell and table width.

Which of the above techniques did you miss? See "column widths in tables" in the help text. All of this is also explained in Chapter 9 of the Writer Guide - also available from the web site.

I trust this helps.

Brian Barker

Where should I post a suggestion that would improve LibreOffice?

You can suggest enhancements at the web site; start at https://www.libreoffice.org/get-help/feedback/ . But it is very sensible to discuss ideas here first - as you have done - since you may find both that something of what you need already exists and that others can contribute to your suggested improvements.

This is about tables in Writer. I went about to create a calendar out of a table to mark the holidays in December when I noticed how difficult it was to format the size of table and cells. I feel that not being able to set width of all cells to an exact number is not good.

You can do this.

o If you create an empty table that fills the text width between page margins, the width of all cells will be equal.

o Providing Alignment (on the Table tab of the Table Format dialogue) is not set to Automatic (which you can change after the table is created), you can tick "Adjust columns proportionally" on the Columns tab. If you then use the "Column width" boxes on that tab to change widths, they will all change in step.

o Select relevant columns of your table and go to right-click | Column > > Space Equally.

o Select relevant columns of your table and go to Table | Autofit > | Distribute Columns Evenly.

These last two techniques can be used either for all columns or for some columns only.

What I had to do is figure out initial width that would fit my needs, multiply by column count, set the table to that calculated width and finally space out column width evenly. It would make a lot of sense for the computer to make the calculations and adjust both cell and table width.

Which of the above techniques did you miss? See "column widths in tables" in the help text. All of this is also explained in Chapter 9 of the Writer Guide - also available from the web site.

Although not relevant to the original posters situation, I would like to see a columns tab under the table dialogue that lists the column widths where you can type in the width of each column. I frequently have to tweek tables by stealing width from one column to give to another spaced a number of columns away and without changing table width or other column widths. It is quite cumbersome at present. Possibly I am manipulating columns incorrectly and this can already be achieved easily enough.
Steve

steveedmonds wrote

Although not relevant to the original posters situation, I would like to
see a columns tab under the table dialogue that lists the column widths
where you can type in the width of each column. I frequently have to
tweek tables by stealing width from one column to give to another spaced
a number of columns away and without changing table width or other
column widths. It is quite cumbersome at present. Possibly I am
manipulating columns incorrectly and this can already be achieved easily
enough.

You can already do this as well...

<http://nabble.documentfoundation.org/file/n4167965/TableProperties_Dialog_Columns.png>

Although not relevant to the original poster's situation, I would like to see a columns tab under the table dialogue that lists the column widths where you can type in the width of each column.

It's there: Table | Table Properties... | Columns | Column width (or right-click | Table... | Columns | Column width). (Yes: you can type in those boxes.)

I frequently have to tweak tables by stealing width from one column to give to another spaced a number of columns away and without changing table width or other column widths. It is quite cumbersome at present. Possibly I am manipulating columns incorrectly and this can already be achieved easily enough.

I suspect it can. I think it is easier if you change column widths from left to right, as consequential changes work that way too. If - as you say - you need make compensatory changes to columns spaced a number of columns apart, one trick would be temporarily to tick "Adapt table width": that way, no consequential changes occur and you can go straight to the distant column and change that. You can remove the tick from "Adapt table width" afterwards if desired, of course.

I trust this helps.

Brian Barker

Although not relevant to the original poster's situation, I would like to see a columns tab under the table dialogue that lists the column widths where you can type in the width of each column.

It's there: Table | Table Properties... | Columns | Column width (or right-click | Table... | Columns | Column width). (Yes: you can type in those boxes.)

I frequently have to tweak tables by stealing width from one column to give to another spaced a number of columns away and without changing table width or other column widths. It is quite cumbersome at present. Possibly I am manipulating columns incorrectly and this can already be achieved easily enough.

I suspect it can. I think it is easier if you change column widths from left to right, as consequential changes work that way too. If - as you say - you need make compensatory changes to columns spaced a number of columns apart, one trick would be temporarily to tick "Adapt table width": that way, no consequential changes occur and you can go straight to the distant column and change that. You can remove the tick from "Adapt table width" afterwards if desired, of course.

Thanks Brian. I will give that a go.

steveedmonds wrote

Although not relevant to the original posters situation, I would like to
see a columns tab under the table dialogue that lists the column widths
where you can type in the width of each column. I frequently have to
tweek tables by stealing width from one column to give to another spaced
a number of columns away and without changing table width or other
column widths. It is quite cumbersome at present. Possibly I am
manipulating columns incorrectly and this can already be achieved easily
enough.

You can already do this as well...

<http://nabble.documentfoundation.org/file/n4167965/TableProperties_Dialog_Columns.png>

Except when you adjust a width in one column another (usually the one you don't want to change) automatically changes.
I would like to adjust all columns then click Apply.

steveedmonds wrote

Although not relevant to the original posters situation, I would like to
see a columns tab under the table dialogue that lists the column widths
where you can type in the width of each column. I frequently have to
tweek tables by stealing width from one column to give to another spaced
a number of columns away and without changing table width or other
column widths. It is quite cumbersome at present. Possibly I am
manipulating columns incorrectly and this can already be achieved easily
enough.

You can already do this as well...

<http://nabble.documentfoundation.org/file/n4167965/TableProperties_Dialog_Columns.png>

If I combine Brians suggestion with the tab you show I can do what I want.
Tick "Adapt width", adjust all the columns as they don't interact, and untick "Adapt width"
Thanks for the discussion, it's helped me greatly.
steve

V Stuart Foote wrote:

steveedmonds wrote

Although not relevant to the original posters situation, I would like to
see a columns tab under the table dialogue that lists the column widths
where you can type in the width of each column. I frequently have to
tweek tables by stealing width from one column to give to another spaced
a number of columns away and without changing table width or other
column widths. It is quite cumbersome at present. Possibly I am
manipulating columns incorrectly and this can already be achieved easily
enough.

You can already do this as well...

<http://nabble.documentfoundation.org/file/n4167965/TableProperties_Dialog_Columns.png>

Perhaps I'm missing something too, but I think I can see where Steve's coming from. For example:
- The table is a fixed width or filling the whole page width (and that's how you want it; selecting "adapt table width" is not desirable)
- Column widths are 1.0", 0.5", 3.0", 3.0", 0.5", 0.5".
- You want to add 2" to column 1 (make it 3.0") and deduct 2" from column 4 (make it 1.0")

To do this, you have to:
- Set column 1 to 3" (column 2 becomes 0.02", column 3 becomes 0.02", column 4 becomes 1.97" - didn't want to change columns 2 and 3)
- Set column 2 back to 0.5"; column 4 becomes 1.48"
- Set column 3 back to 0.5"; column 4 becomes 1.0" (finally what was wanted)

It would be much easier to:
- Set column 1 to 3"; no other widths change (columns don't add up to the total width, but that's OK because we're about to fix that)
- Set column 4 to 1"

Even with this fairly simple example it's a bit tricky, but with more columns at various different widths which may not be nice round numbers it can be quite difficult to ensure the ones you don't want changed finish up with the correct widths.

Mark.

Thanks to Brian, I found tick "Adapt width", make changes as required, un-tick "Adapt width" works as we would hope.
steve

Steve Edmonds wrote:

V Stuart Foote wrote:

steveedmonds wrote

Although not relevant to the original posters situation, I would
like to
see a columns tab under the table dialogue that lists the column widths
where you can type in the width of each column. I frequently have to
tweek tables by stealing width from one column to give to another
spaced
a number of columns away and without changing table width or other
column widths. It is quite cumbersome at present. Possibly I am
manipulating columns incorrectly and this can already be achieved
easily
enough.

You can already do this as well...

<http://nabble.documentfoundation.org/file/n4167965/TableProperties_Dialog_Columns.png>

Perhaps I'm missing something too, but I think I can see where Steve's
coming from. For example:
- The table is a fixed width or filling the whole page width (and
that's how you want it; selecting "adapt table width" is not desirable)
- Column widths are 1.0", 0.5", 3.0", 3.0", 0.5", 0.5".
- You want to add 2" to column 1 (make it 3.0") and deduct 2" from
column 4 (make it 1.0")

To do this, you have to:
- Set column 1 to 3" (column 2 becomes 0.02", column 3 becomes 0.02",
column 4 becomes 1.97" - didn't want to change columns 2 and 3)
- Set column 2 back to 0.5"; column 4 becomes 1.48"
- Set column 3 back to 0.5"; column 4 becomes 1.0" (finally what was
wanted)

It would be much easier to:
- Set column 1 to 3"; no other widths change (columns don't add up to
the total width, but that's OK because we're about to fix that)
- Set column 4 to 1"

Even with this fairly simple example it's a bit tricky, but with more
columns at various different widths which may not be nice round
numbers it can be quite difficult to ensure the ones you don't want
changed finish up with the correct widths.

Mark.

Thanks to Brian, I found tick "Adapt width", make changes as required,
un-tick "Adapt width" works as we would hope.
steve

Is that option available with the table alignment set to automatic? Automatic alignment fixes the table width as the paragraph width, which disables the "adapt table width" option in LibreOffice 4.4.2, but that may have changed in newer versions (I really must update some time, particularly having just advised someone else to try doing that!)

It also doesn't allow the table width to go beyond the width of the paragraph while making adjustments, but that's not so much of a problem since reductions in column width can be done before increases.

Mark.

Perhaps I'm missing something too, but I think I can see where Steve's coming from. For example:
- The table is a fixed width or filling the whole page width (and that's how you want it; selecting "adapt table width" is not desirable)

This is your mistake: denying the very technique which will help you. It's a bit like my saying that I like eating Christmas pudding, but I don't want to put it in my mouth. Er, but that's how eating works.

- Column widths are 1.0", 0.5", 3.0", 3.0", 0.5", 0.5".
- You want to add 2" to column 1 (make it 3.0") and deduct 2" from column 4 (make it 1.0")

To do this, you have to:
- Set column 1 to 3" (column 2 becomes 0.02", column 3 becomes 0.02", column 4 becomes 1.97" - didn't want to change columns 2 and 3)
- Set column 2 back to 0.5"; column 4 becomes 1.48"
- Set column 3 back to 0.5"; column 4 becomes 1.0" (finally what was wanted)

No, you don't *have* to do this.

It would be much easier to:
- Set column 1 to 3"; no other widths change (columns don't add up to the total width, but that's OK because we're about to fix that)

*You* know that you are going to make further compensating changes but LibreOffice doesn't. If you are espousing such a change to LibreOffice, you need to explain, please, exactly what happens if users click OK at this point. Surely, if "columns don't add up to the total width", you can allow LibreOffice to know this - by allowing it to adapt the table width, albeit temporarily.

- Set column 4 to 1"

Try this:
o On the Table tab of the Table Format dialogue, change Alignment from Automatic to something else - perhaps Left.
o On the Columns tab, tick "Adapt table width".
o Enter "1" for column 4. (As you acknowledged in a later message, it's helpful to do the reduction first, before the increase.)
o Enter "3" for column 1.
o Untick "Adapt table width".
o On the Table tab, change Alignment back to Automatic.
o OK.

Brian Barker

Perhaps I'm missing something too, but I think I can see where Steve's coming from. For example:
- The table is a fixed width or filling the whole page width (and that's how you want it; selecting "adapt table width" is not desirable)

This is your mistake: denying the very technique which will help you. It's a bit like my saying that I like eating Christmas pudding, but I don't want to put it in my mouth. Er, but that's how eating works.

- Column widths are 1.0", 0.5", 3.0", 3.0", 0.5", 0.5".
- You want to add 2" to column 1 (make it 3.0") and deduct 2" from column 4 (make it 1.0")

To do this, you have to:
- Set column 1 to 3" (column 2 becomes 0.02", column 3 becomes 0.02", column 4 becomes 1.97" - didn't want to change columns 2 and 3)
- Set column 2 back to 0.5"; column 4 becomes 1.48"
- Set column 3 back to 0.5"; column 4 becomes 1.0" (finally what was wanted)

No, you don't *have* to do this.

It would be much easier to:
- Set column 1 to 3"; no other widths change (columns don't add up to the total width, but that's OK because we're about to fix that)

*You* know that you are going to make further compensating changes but LibreOffice doesn't. If you are espousing such a change to LibreOffice, you need to explain, please, exactly what happens if users click OK at this point. Surely, if "columns don't add up to the total width", you can allow LibreOffice to know this - by allowing it to adapt the table width, albeit temporarily.

- Set column 4 to 1"

Try this:
o On the Table tab of the Table Format dialogue, change Alignment from Automatic to something else - perhaps Left.
o On the Columns tab, tick "Adapt table width".
o Enter "1" for column 4. (As you acknowledged in a later message, it's helpful to do the reduction first, before the increase.)
o Enter "3" for column 1.
o Untick "Adapt table width".
o On the Table tab, change Alignment back to Automatic.
o OK.

I think Mark intimated this, or so I interpreted having just tried it before your post. You have to make sure that reductions are done first as LO will not allow the table to grow outside the (page width-margins).
Steve

Ok, Table -> autofit -> distribute evenly works like a charm.

But that still leaves adjusting width of whole table a cumbersome task. It
seems that getting the width of one cell right, then calculating the width
of table from column count is the only way. What if font size needs
adjusting later? Too bad, adjustments are not "user-friendly" to make.

Sorry, too much text to read all the posts.

Thanks for replies.

Brian Barker wrote:

Perhaps I'm missing something too, but I think I can see where Steve's
coming from. For example:
- The table is a fixed width or filling the whole page width (and
that's how you want it; selecting "adapt table width" is not desirable)

This is your mistake: denying the very technique which will help you.
It's a bit like my saying that I like eating Christmas pudding, but I
don't want to put it in my mouth. Er, but that's how eating works.

But if I want the table to have a fixed width, why should I change it to variable width (even temporarily) every time I want to take a bit off one column width and add it to another which isn't adjacent to it? It's a workable workaround, but not exactly intuitive, nor expressing what I want to achieve (keeping a constant table width).

- Column widths are 1.0", 0.5", 3.0", 3.0", 0.5", 0.5".
- You want to add 2" to column 1 (make it 3.0") and deduct 2" from
column 4 (make it 1.0")

To do this, you have to:
- Set column 1 to 3" (column 2 becomes 0.02", column 3 becomes 0.02",
column 4 becomes 1.97" - didn't want to change columns 2 and 3)
- Set column 2 back to 0.5"; column 4 becomes 1.48"
- Set column 3 back to 0.5"; column 4 becomes 1.0" (finally what was
wanted)

No, you don't *have* to do this.

It would be much easier to:
- Set column 1 to 3"; no other widths change (columns don't add up to
the total width, but that's OK because we're about to fix that)

*You* know that you are going to make further compensating changes but
LibreOffice doesn't. If you are espousing such a change to LibreOffice,
you need to explain, please, exactly what happens if users click OK at
this point.

To be honest, I'm not entirely sure what the best way around it is. Of course, it would need to disallow OKing the dialog at this point, perhaps with a message saying the column widths don't add up to the required total (though I'd agree that isn't particularly elegant), or perhaps by disabling the OK button and showing a message within the dialog itself. A display within the dialog showing the mismatch between required table width and current column widths would also be useful, similar to the existing "remaining space" field (which shows how much space is left to expand the table width when allowing that to change).

For what it's worth, I don't recall MS Word being any easier. From what I recall, it allows you to enter column widths which don't add up to the total table width, but does something like scaling proportionately when displaying the table to make it required width.

Surely, if "columns don't add up to the total width", you
can allow LibreOffice to know this - by allowing it to adapt the table
width, albeit temporarily.

- Set column 4 to 1"

Try this:
o On the Table tab of the Table Format dialogue, change Alignment from
Automatic to something else - perhaps Left.
o On the Columns tab, tick "Adapt table width".
o Enter "1" for column 4. (As you acknowledged in a later message, it's
helpful to do the reduction first, before the increase.)
o Enter "3" for column 1.
o Untick "Adapt table width".
o On the Table tab, change Alignment back to Automatic.
o OK.

So you have to either fiddle about with column widths automatically changing, or change two options which you don't actually want to change and then change them back again after adjusting column widths. I can see why someone might describe either option as "quite cumbersome", when all they want to do is change two column widths.