Ask Your Question

How do I right align with an indent in a Calc cell?

asked 2017-04-16 22:32:00 +0200

LorenzoPearson gravatar image

I could do this in the Excel and it has been in the formats available since they first started making Excel. I just want to format a cell with what I said, a right alignment with indentation inside a cell.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-04-16 23:08:42 +0200

m.a.riosv gravatar image

On the side bar you have the buttons to increase and decrease the indent, and on the toolbar. image description

But seems on the cell format [Ctrl+1] it's only possible to change for left align, not for right align.

edit flag offensive delete link more

answered 2017-04-17 14:18:24 +0200

Regina gravatar image

The method using the "Indent:" buttons mentioned in the post by m.a.riosv, looks good optical. But if you look into the file format, you will notice, that it is stored as fo:margin-left. That makes it a candidate for trouble in future. You can get the same visual result, if you go to the Borders tab of the cell properties and set the right Spacing to content. That will be stored as fo:padding-right in the cell-properties. Besides that it has the advantage to allow more precise adjustment .

edit flag offensive delete link more


Maybe your comment is the reason for the tdf#107213 being not editable the value for right indent. It was closed as not a bug, but I'm not too much agree, I think something it's not right.

m.a.riosv gravatar imagem.a.riosv ( 2017-04-17 14:27:26 +0200 )edit

Cells aren't little text documents. Every step in that direction may be another approach to more unsoundness.
Tere are lots of unfixed bugs concerning actual spreadsheet functionality.

Lupp gravatar imageLupp ( 2017-04-17 15:22:13 +0200 )edit

I have put tdf#107213 to enhancement and have written tdf#107233 for the current wrong behavior.

Regina gravatar imageRegina ( 2017-04-17 15:57:34 +0200 )edit

Lupp: Each table cell can contain "text-content" and that is a lot. Have a look at line 226 in or at section 9.1.4 in . The fact, that LibreOffice implements Writer tables different from Calc tables, is only given by the history of office applications, but not by the ODF 1.2 file format.

Regina gravatar imageRegina ( 2017-04-17 16:21:32 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-04-16 22:32:00 +0200

Seen: 1,171 times

Last updated: Apr 17 '17