Ask Your Question

Keep Calc from removing duplicate cells... [closed]

asked 2013-03-20 17:48:01 +0200

Developforyahu gravatar image

updated 2013-03-20 17:49:10 +0200


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?


edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-02 02:59:33.146823



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?

Mark12547 gravatar imageMark12547 ( 2013-03-20 18:19:35 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2013-04-14 11:41:51 +0200

ProLogic gravatar image

updated 2013-06-07 05:51:42 +0200

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

edit flag offensive delete link more

answered 2013-06-07 10:19:17 +0200

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.

edit flag offensive delete link more

Question Tools


Asked: 2013-03-20 17:48:01 +0200

Seen: 217 times

Last updated: Jun 07 '13