Ask Your Question

Each cell content report

asked 2019-07-21 09:50:25 +0100

lonk gravatar image

updated 2019-07-23 05:55:11 +0100

From this example sheet:

image description

Once upon a time, I just thought of it. Lotus123 Spreadsheet could report :

A 1 Rice

A 2 Iron

B 1 Vegetable

B 2 Copper

C 1 Vitamin

C 2 Aluminum

Can Calc do like that ?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-07-23 15:11:13 +0100

ebot gravatar image

No, I do not know this form of expression.

You can print it out with the headings of the columns and rows.

Choose Format>Page from the menu. In the "Page Style: Default" dialog box, select the "Sheet" tab, set checkmark to "Print" - "Column and Row headers".

image description

This is the result:

image description

If my answer has solved your problem, please click on the checkmark ✓ in the circle image description to the left of the answer and click on the arrow ^ for upvote. This will tell the community that the question has been answered correctly.

edit flag offensive delete link more


With me Windows 10 Home; Version 1903; 64-Bit | LibreOffice, Version: (x64).

ebot gravatar imageebot ( 2019-07-23 15:11:46 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-07-21 09:50:25 +0100

Seen: 53 times

Last updated: Jul 23 '19