Apache OpenOffice Community Forum

We have downloaded a spreadsheet that has graphic line items to the left of the normal spreadsheet cells.
We need to locate the row position of these vertical lines. It is probably in the content.xml file.
Can someone advise where we can find data describing these graphics ?
Also how can we add these to our own spreadsheets.

You received answers to all these questions two months ago. Don't you even check your own posts before asking questions? It's discourteous to ask questions you have already received answers to. You are more likely to receive assistance when you attach a document demonstrating the situation (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself).
[Solved] Extra cells outside the normal cells

orgopenoffice1 wrote: ↑Tue Apr 14, 2026 7:27 pm We need to locate the row position of these vertical lines

The position is clearly shown on the screen, is it not?

orgopenoffice1 wrote: ↑Tue Apr 14, 2026 7:27 pm Can someone advise where we can find data describing these graphics ?

Thank you, that has it !!

orgopenoffice1 wrote: ↑Tue Apr 14, 2026 7:27 pm Also how can we add these to our own spreadsheets.

Read about outline controls

If this solved your problem please go to your first post use the Edit ✏️ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

Yes we did get an answer, but at the time we did not need to take it further.
On revisiting the problem we find that the info is difficult to find without some information on the contents.xml file.
We are hoping someone can point us to a description of the file format.

You have been given the link to the file format specification in your other thread.
But I doubt it will help.
If I understand correctly your problem (your other thread), you need to find out what is the pattern leading the grouping of the lines. If the grouping has to do with the addition of new lines.
Else, your best bet is to use formulas to compare the files with its previous version and highlight the differences.