Bug 107213

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.