Description: On cell format box [Ctrl+1]- Align tab - Indent value not editable for right align, but it is for left align. Steps to Reproduce: 1.Open a new spreadsheet. 2.Ctrl+1 3.Choose align tab. 4.Select left align for Horizontal, indent value is editable. 5.Select right align for Horizontal, indent value is not editable. 6.It works with the toolbar. 7.On side bar buttons work but the some issue for edit the value, available for left but not for right align. Actual Results: . Expected Results: Value for right indent editable like it is for left align. Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 Firefox/52.0
It is simply because changing the indent value will move it to the right by the distance you set. Center will put the element in the center and right will simply indent it to the right corner and you cant indent the text because there is no more space.
Sorry, but if you use the toolbar/sidebar button to indent after right aling it works and a value for indent is show.
I think, it is a valid request. It is no bug, because a right indent was not possible in any version before. But the solution has to be discussed. A cell in Calc can contain several paragraphs. Currently it is not possible in Calc, to have different styles for these paragraphs. Such is possible in Writer. From my point of view such feature should be implemented in a way, that it is compatible to the implementation in Writer. There are several ways to implement a feature, that gives a visual "indent", but they behave different when paragraph background and cell background is used. (Try in Writer): (1) Using the padding of the cell. That would be fo:padding in the cell properties in file format. That way is currently used in import, if a file contains a "fo:margin-right" on the paragraph property, because "fo:margin-right" is not implemented. (2) Using "fo:margin-right" on the paragraph property. That would correspond to the "fo:margin-left" which is used for the indent in a left aligned paragraph in Calc, and is used for the 'space before' and 'space after' in Writer. (3) Using "fo:padding-right" on the paragraph property (since LO5.3 possible in Writer). "fo:end-indent" exists in XSL, but is not allowed for paragraphs or cells in ODF 1.2.
As I have been needing the right-align indent more frequently, I have been using this workaround .... Affected dialog box: Format » Format Cells... » Alignment (tab) === Description & Workaround ========== 1.) When Horizontal alignment is "Left", "Indent" value is available (NOT disabled). Adjust the value, and it affects the selected cell or range. 2.) Change to Horizontal alignment to "Right", and the "Indent" value is NOT available (disabled). #3a.) Select the range or cell. Open "Format Cells..." dialog to the "Alignment" tab. #3b.) Change to Horizontal alignment to "Left", and the "Indent" value is available (NOT disabled). Adjust the value -- DO NOT close the dialog box #3c.) Change to Horizontal alignment to "Right", and the "Indent" value is NOT available (disabled) ... However the previously entered value is still shown (though it is greyed out). Click "OK". The selected cell or range now will be right-aligned with an "Indent" of the value that was entered in #3b. #3d.) To remove/adjust the right-aligned "Indent", one must preform #3b, and adjust the value to the desired value then change to Horizontal alignment to back to "Right". Click "OK". The selected cell or range now will be right-aligned with the desired indent. === Recap ============================= Without closing the "Format Cells..." dialog, the right alignment indent can be changed/removed by adjusting the "Indent" value while "Left" alignment is selected, then re-selecting "Right" alignment. Then click "OK". === Environment ======================= Version: 7.1.0.3 (x64) / LibreOffice Community Build ID: f6099ecf3d29644b5008cc8f48f42f4a40986e4c Environment: CPU threads: 4; OS: Windows 6.3 Build 9600; User Interface: UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Misc: Calc: CL
(In reply to DouglasC from comment #4) > As I have been needing the right-align indent more frequently, I have been > using this workaround .... Thanks! This is far quicker/easier than the cumbersome method I'd been using to work around the lack of right indent by adjusting border padding.
(In reply to DouglasC from comment #4) > As I have been needing the right-align indent more frequently, I have been > using this workaround .... I can't believe this even STILL needs a workaround. This is basic stuff!!!