Keep Calc from removing duplicate cells

[Developforyahu]

Hi,

I don’t know how calc is doing this, but I two column with numbers, the first column will contain a page of a book and the second column will have chapters. So I will have some cell with the same chapter number. For example: (page, chater)

(1, 1)
(1, 2)
(1, 3)
(1, 4)
etc…

When saved I use another program to read and extract the content.xml and I look at the xml data with MS XML Notepad and notice the chapters with the same page numbers are missing.

Is there a setting where I can tell calc not to do this?

Thanks!..

[Mark12547]

Is it Calc? If you use Calc to reopen the file you had it write, does it still have the cells? And what program are you using to convert the file to an XML?

[ProLogic]

I don’t think that’s Calc’s mistake, i think it’s MS XML Notepad witch is not able to fully read an standard XML document, coz Microsoft XML is not a standard and have his own way to read XML

[mmohrhard]

It looks like you need to read a bit of the ODF standard if you want to process documents manually.

I suppose that without having a test file you have a case where Calc writes table:number-rows-repeated which means that the same row is repeated several times. The default value is 1 which is why you won’t see it most of the time but if it is there you need to just use the same row several times.

Depending on how complex your spreadsheets become you’ll find more and more such cases. All in all processing complex ODS documents is not a trivial task and normally requires some insight into the standard.