Description: Table width increases entering column width in % Steps to Reproduce: 1. Open the attached file 2. Table -> Properties -> Column tab 3. Check adjust columns proportionally 4. Enter 20% in column 1 width box 5. Press OK Actual Results: Alignement lost Table increases size Expected Results: Don't allow % or decent behaviour Reproducible: Always User Profile Reset: No Additional Info: Version: 7.0.0.1 Build ID: 04ba7e3f1e51af6c5d653e543a620e36719083fd CPU threads: 4; OS: Mac OS X 10.12.6; UI render: default; VCL: osx Locale: nl-NL (nl_NL.UTF-8); UI: en-US Calc: threaded
Created attachment 163228 [details] Example file
For the question should % be allowed
Cannot confirm: Check Adjust col prop, enter 20 at col 1 = 8.5cm for both, 0cm left. What do you expect? Help says: Adjust columns proportionally If possible, change in column width will be equal for each column. This option is not available if Automatic is selected in the Alignment area on the Table tab. Remaining space Displays the amount of space that is available for adjusting the width of the columns. To set the width of the table, click the Table tab.
Created attachment 163310 [details] Screencast Table size should be reset by columns.. columns size should stick within table size set. If doesn't fit, it should correct or show a warning.. but not change the size of the table
[Automated Action] NeedInfo-To-Unconfirmed
You enter "20%" which is taken as 20cm (or in depending on your locale). And since 20cm is too large for the page it's reduced to the maximum. "Proportionally" rather means equally here.
(In reply to Heiko Tietze from comment #6) > You enter "20%" which is taken as 20cm (or in depending on your locale). And > since 20cm is too large for the page it's reduced to the maximum. > "Proportionally" rather means equally here. Yes, but the maximum is the size of the table I defined. If it supposed to interact with width should be really really clear Another example 1. Insert a table 2. table -> Properties -> column tab. Check Adjust columns proportionally 3. Go to table tab 4. Set the alignment to manual 5. Define the size to -0,50 at left and right (so crossing page margin) 6. Go to Column tab -> check size 7. Go to Table tab -> 17 cm...
(In reply to Telesto from comment #7)and right (so crossing page margin) > 6. Go to Column tab -> check size 9cm > 7. Go to Table tab -> 17 cm... 18cm Anyway, my point is: You cannot enter % in a numerical input field and expect the program to interpret this correctly. I wish it was like this (bug 72662).
I don't agree with Telesto here. It's a number field. Should remain like this.
(In reply to BogdanB from comment #9) > I don't agree with Telesto here. It's a number field. Should remain like > this. Not my intention to change it to percent by default ;-). Some field take different inputs etc. I think it should accept percentage (even with relative unchecked). Similar to Format -> Character -> Font tab Font size tab allowing to enter CM instead of points. They % could calculated based on the table width. But that's technically not the first thing I had in mind when writing the bug report. Comment 7 is probably better way to illustrate the issue (I this case it shrinks), but same thing
(In reply to BogdanB from comment #9) > I don't agree with Telesto here. It's a number field. Should remain like > this. I think this report should be like "Number fields shouldn't allow any symbols except numbers"
(In reply to Roman Kuznetsov from comment #11) > "Number fields shouldn't allow any symbols except numbers" Exactly. Telesto, resolve as WF, keep open with recommendation to set WF, or hijack and disable alphanumeric characters. What do you like?
(In reply to Roman Kuznetsov from comment #11) > (In reply to BogdanB from comment #9) > > I don't agree with Telesto here. It's a number field. Should remain like > > this. > > I think this report should be like "Number fields shouldn't allow any > symbols except numbers" In principle I agree with Roman, except everything is in % when Relative is checked.. So this maybe relative hard to archive... So going for WFM