Calc: Newlines don't work in all cells

asked 2019-03-21 21:54:41 +0200

CRussell gravatar image

Calc Version: 6.0.7.3 on Linux Mint 19.

A formula with an inserted newline was copied into cells 2-640. In cells 11-640 the formula is displayed in the formula bar as: =IF(SUM(IFNA(MATCH($A635,$A$2:$A634,0),0),IFNA(MATCH($A635,$A636:$A$99999,0),0))>0, SUM(IFNA(MATCH($A635,$A$2:$A634,0)+1,0),IFNA(MATCH($A635,$A636:$A$99999,0)+ROW(A635),0)),"")

In cells 2-10 the formula is displayed in the formula bar as: =IF(SUM(IFNA(MATCH($A3,$A$2:$A2,0),0),IFNA(MATCH($A3,$A4:$A$99999,0),0))>0,SUM(IFNA(MATCH($A3,$A$2:$A2,0)+1,0),IFNA(MATCH($A3,$A4:$A$99999,0)+ROW(A3),0)),"")

If the formula above is copied into an editor, it appears as the first one.

Any suggestions as to how to get cells 2-10 to display as cells 11-640?

edit retag flag offensive close merge delete

Comments

It may be related, but I just tried copying cell 11 (ctrl_c) into cell 10 (ctrl-v); cell10 formula displayed with out newline.

CRussell gravatar imageCRussell ( 2019-03-21 22:58:33 +0200 )edit