Data displayed to left of spreadsheet

Discuss the spreadsheet application
Locked
orgopenoffice1
Posts: 13
Joined: Sat Aug 20, 2011 11:34 am

Data displayed to left of spreadsheet

Post by orgopenoffice1 »

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.
Portable OpenOffice 3.2 xp
User avatar
MrProgrammer
Moderator
Posts: 5430
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Data displayed to left of spreadsheet

Post by MrProgrammer »

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.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.7.8, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
orgopenoffice1
Posts: 13
Joined: Sat Aug 20, 2011 11:34 am

Re: Data displayed to left of spreadsheet

Post by orgopenoffice1 »

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.
Portable OpenOffice 3.2 xp
User avatar
Hagar Delest
Moderator
Posts: 33629
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Data displayed to left of spreadsheet

Post by Hagar Delest »

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.
LibreOffice 25.2 on Linux Mint Debian Edition (LMDE 7 Gigi) and 25.2 portable on Windows 11.
Locked