Ask Your Question

How can I set the default in Calc to first row as column labels?

asked 2018-10-12 05:12:25 +0200

When I read in a document into calc, I'd like for the default setting to be that the first row is column labels.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-10-12 07:24:15 +0200

JohnSUN gravatar image

Have you tried enabling this option - Automatically find column and row labels?

Automatically find column and row labels.png

edit flag offensive delete link more


Enabling that option can break hell lose because when compiled formula expressions try to find the nearest cell content that matches a name, so once an expression found a name and later a cell with an identical content is added nearer to the formula expression's cell position, loading the document again will result in the newer cell being found instead.

Rather use menu Sheet -> Named Ranges and Expressions -> Labels... to define label ranges.

erAck gravatar imageerAck ( 2018-10-12 17:57:08 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-10-12 05:12:25 +0200

Seen: 40 times

Last updated: Oct 12 '18