Bug 82737 - FORMATTING: text width scaling not working for whole cells
Summary: FORMATTING: text width scaling not working for whole cells
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.5.2 release
Hardware: All All
: low normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-08-17 21:04 UTC by VolkerTwer
Modified: 2019-12-04 13:48 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Mixed results demonstrating this issue (12.45 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-08-18 23:30 UTC, Algot Runeman
Details

Note You need to log in before you can comment on or make changes to this bug.
Description VolkerTwer 2014-08-17 21:04:02 UTC
Scaling the width of characters via (de) _F_ormat - Zei_c_hen -> [Schriftposition] works well unless the whole cell-content is to be scaled. If *all* characters in the cell are scaled (to the same value), the cell-content is displayed at (respectively set to) 100%-width-scaling after hitting [Enter].

Steps to reproduce:
1. open new spreadsheet
2. enter some text into a cell [Enter]
3. select the cell with entered text and open for editing [F2]
4. select *some* (e.g. all but the last) characters in the cell
5. modify character-width scaling ( [Alt] + F , C , (Tab.) "Schriftposition" ) to e.g. 90%
6. select [OK] -> the selected text is displayed scaled to (e.g.) 90%-width.
7. [Enter] -> the text in the cell is displayed with the previosly selected characters scaled to (e.g.) 90%-width.

so far so good

8. edit the cell again [F2]
9. select the previously *not* selected/scaled characters
10. modify the width-scaling as before to the same value - (e.g.) 90%
11. select [OK] -> the whole text in the cell is now displayed scaled (to e.g. 90%-width)
12. [Enter]

current behaviour: the whole text in the cell is reset to 100%-width

expected behaviour: the whole text in the cell should be displayed at the previously set width (e.g. 90%)

OS: Linux (Debian/SolydK)
Version: 4.2.5.2, Build-ID: 420m0(Build:2)
Comment 1 VolkerTwer 2014-08-17 21:46:28 UTC
just updated LibreOffice - same behaviour in

Version: 4.3.0.4, Build-ID: 430m0(Build:4)
Comment 2 Algot Runeman 2014-08-18 23:30:33 UTC
Created attachment 104846 [details]
Mixed results demonstrating this issue

Test System:
Kubuntu (KDE 4.13.3)
LibreOffic 4.2.4.2

I hope I have duplicated the format. In English, I used Format - Character - font position(tab) - text width (used 70% to let me see the difference easier0

I am having mixed results. 
- Some of my text is holding the formatting. More often, it does not.
- Capital vs lower case does not seem to matter.
- I am not satisfied that I have exactly confirmed the problem.

Am I using the intended formatting steps?
Comment 3 VolkerTwer 2014-08-19 05:59:34 UTC
Yes, you do.

The "mixing" behaviour is even more strange ...

Did you format (scale) the whole text-content at once?
And, I guess, you did the same steps for each of the three filled cells in your testfile. Right? Or did you do something different with the "working" cell?
Comment 4 VolkerTwer 2014-08-19 16:13:37 UTC
Ok I just recognised: in the seemingly(!) working cell, you scaled the BEGINNING ("sym") with 60% and the ENDING ("bol") with 70%. So it's NOT THE SAME what I described (scaling all text in the cell to the same value [!=100%] ).

Further details to the BUG(!):
(1) If text with different scaling values is selected (e.g. in the filed testfile "symb" from field A1 - with "sym" scaled to 60% and the "b" scaled to 70%) and the scaling-dialog is called, then the scaling value field is NOT EMPTY (as usual for an attribute of a selection formatted to varying values, e.g. text formatted with various fonts or font-sizes) but shows "100%".

(2) width-scaling for the whole cell-content works, if at the same time the spacing is trimmed (to e.g. "0.1 pt condensed")
Comment 5 QA Administrators 2015-09-04 02:50:00 UTC Comment hidden (obsolete)
Comment 6 Algot Runeman 2015-09-04 12:05:52 UTC
Test System:
Kubuntu (Frameworks version: 5.9.0)
LibreOffice 5.0.1.2

The bug appears to have been squashed. It was possible to set two parts of a word to 70% width in two stages and have 70% width "stick" for the whole cell after the second edit.

NOTE: I was unable to set the status to WORKSFORME because that option was not available to me in the selection tool. I therefore left it unchanged (NEW).
Comment 7 Algot Runeman 2015-09-04 12:09:46 UTC
Follow-up. I see that I was too timid.

Selecting RESOLVED from the tool allowed me further selectable options. I've been away too long.
Comment 8 VolkerTwer 2015-09-04 22:05:01 UTC
Sorry, but this bug is still present ("alive"):
as long as in cell-edit mode (F2) the text remains (e.g.) condensed; after pressing "enter" it swaps back to 100%-width.

I can keep it "stable" with a new generated profile, but ONLY until for the first time formatting all text in a cell *at*once* to a width [!=100%]. After that it always keeps swapping back as soon as all text is formatted to same width [!=100%].

Version: 5.0.1.2
Build-ID: 81898c9f5c0d43f3473ba111d7b351050be20261
Gebietsschema: de-DE (de_DE.UTF-8)
Comment 9 Buovjaga 2015-10-09 18:41:38 UTC
Bug does not meet the criteria for Status 'REOPENED'
https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/REOPENED#Criteria
Status -> UNCONFIRMED
Comment 10 Joel Madero 2015-10-10 16:33:52 UTC
Ubuntu 15.04 x64
LibreOffice 5.0.0.5

Confirmed:
Note: Please don't change the version - as the label says "earliest affected" Version is NOT "latest version tested on).

Setting to:
New
Normal - just a normal run of the mill bug that can potentially prevent high quality work
Low - Not a feature that is going to impact a ton of users (given limited activity over the course of 14 months, no duplicate bugs, experience of this QA member).

If this is tested against older releases and found to be a regression it should:
1) Be bumped to "medium"
2) "regression" should be added to keywords;
3) "bibisectRequest" should be added to whiteboard

To test older versions: http://downloadarchive.documentfoundation.org/libreoffice/old/

Best thing to do is test 3.3 and see if it was around at that point - if it was, version should be updated to "inherited from OOo". Thanks
Comment 11 QA Administrators 2016-11-08 11:41:43 UTC Comment hidden (obsolete)
Comment 12 QA Administrators 2019-12-03 14:19:26 UTC Comment hidden (obsolete)
Comment 13 VolkerTwer 2019-12-04 13:48:03 UTC
Looks like the bug has been cleared.
Thanx a lot!


Info from  < Help - about LO > :

Version: 6.3.3.2.0+
Build-ID: 1:6.3.3-2~bpo10+1
CPU-Threads: 4; BS: Linux 4.19; UI-Render: Standard; VCL: gtk2; 
Gebietsschema: de-DE (de_DE.UTF-8); UI-Sprache: de-DE
Calc: threaded