From this example sheet:
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 ?
From this example sheet:
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 ?
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”.
This is the result:
If my answer has solved your problem, please click on the checkmark ✓ in the circle 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.
With me Windows 10 Home; Version 1903; 64-Bit | LibreOffice, Version: 6.2.5.2 (x64).