Apache OpenOffice (AOO) Bugzilla – Issue 71293
HTML export joined cells and hidden columns incorrectly
Last modified: 2017-05-20 10:44:45 UTC
See the test case, List3. In the row 1, there are joined cells A-D and E-H. Now try to export the file, or select the table and use clipboard to copy it to, say, NVU. As You can see, the row 1 is crippled. The first joined cell, A-D, now includes E too. The second cell starts at G and ends with H. There are hidden cells B and F. Maybe the export dosen't handle them correctly. Besides, the columns E, G, H are formatted incorrectly -they are too large in export. I don't know, however, whether this is implied by this issue, or is a separate one.
Created attachment 40394 [details] Test case -see List3
I can't export your file at all. Can you download and install the latest version of openoffice.org currently version 2.1, export you file as html and report the results.
The attachment is OK, just the MIME behind is flawed somehow. Right click on the attachment and choose "save link as" to save the file to Your disk. Then open it in OOo. Tested with OOo2.1.0.
Hi, I found a way to reproduce the alignmentbehavour, and can therefore confirm this issue. Enter the following in a new sheet: A B C D E 1 heading test v 2 test test ^ align cell c4: right now, merge cells: A1:C1, and hide column B notice that cellvalues D1 and D2 are still above each-other save the file as an html-file open the html file notice that the values in cells D1 and D2 are not above each-other anymore. I suggest to create a new issue for the cell-formating-problem Confirmed this issue, and enhanced summary
Hi, checked with OOo2.2rc4 and could not reproduce. The resulting HTML file viewed with firefox looks exactly as expected. The third table in the HTML looks the same as in the ODS file. Therefore closed worksforme. Frank
closed wfm
I do not agree. (Tested with OOo 2.2) In the example above, my post from friday march 23, the values in column d are above eachother. when column b is a hidden column, after exporting to a html file, the html file shows column d not aligned anymore... therefore, i reopen this issue...
Created attachment 44372 [details] testdoc for HTML Export
Hi Eike, HTML Export is yours. Can something be done in the case gercokess described ? See the second attachment for the example he gave us. Frank
Accepted. First cell of exported testdoc has colspan=3. For each merged cell it would have to be taken into account whether it spanned hidden cols/rows and decrease the value of the colspan/rowspan attribute accordingly.
Hi, anything new? You have probably more important issues on list, I just wonder, that this one seemed quite simple from what I read here.. Anyway, thank You for the work You have done analysing the issue.
No news, and yes, other things to do, and yes, not that difficult ;-) Adding keyword easy2dev in case someone wants to jump on it.
I would like to handle this bug. Where is the code response for HTML export?
The problem is in bad number of "colspan" in "<td>" After change in HTML from: <td colspan="2" style="text-align:left;width:2.267cm; " class="Default"><p>Heading</p></td> to: <td colspan="3" style="text-align:left;width:2.267cm; " class="Default"><p>Heading</p></td> The html page is displayed correctly
I found following file which export document to html: http://svn.services.openoffice.org/opengrok/xref/DEV300_m83/sd/source/filter/html/htmlex.cxx
I made mistake. Html export file for Calc is located at: http://svn.services.openoffice.org/opengrok/xref/DEV300_m83/sc/source/filter/html/htmlexp.cxx#WriteCell And the interesting thing is located in WriteCell method in line 893 . Why the "nC = rMergeAttr.GetColMerge();" returns "3" for sample document? It should return "2"
gang65, see er's comment above. GetColMerge() includes the hidden column.
The solution is replace ScMergeFlagAttr::GetColMerge() method by subtraction of the number hidden columns that are spanned.
Reset the assignee to the default "issues@openoffice.apache.org".