Automatic Border in LibreOffice Calc

[AniruddhaMohod]

I am using Ubuntu 22.04 and LibreOffice 25.2.1.2.

In LibreOffice writer if I press tab at the last cell it will give me a new row with border. But in LibreOffice Calc if I add data into new row I will have to apply border to those rows. Similarly, if I paste data from other cells the pasted data need to be applied separate border. (I know if I paste the data by Alt+Shift+Control+V I don’t need to apply the border separately.)

I tried conditional formatting by giving condition that if the cell is non-blank it will apply border. But it is applying border to that particular cell only. I wish that if in Cell Range A1:D10, if cell A9 is non-blank it should apply border to A9 to D9. How can I achieve this?

[PKG]

ask_122491.ods (9,9 KB)

[AniruddhaMohod]

It works only if we enter something in column A. Is it possible that if column A is blank and we enter any value in either column B, C, D it will work?

[sokol92]

Try change formula to:

COUNTA($A1:$D1)>0

[AniruddhaMohod]

Also tell me is it possible that if I put data in for example row 6 all the above rows get border. Presently, if there are blank rows above the entered data there is no border get applied to those cells.

[sokol92]

@AniruddhaMohod

tell me is it possible

In LibreOffice everything is possible!

COUNTA($A1:$D$10)>0