Bug 136122

Summary: Notes joined to a cell in Calc are not correctly treated when export to xhtml format
Product: LibreOffice Reporter: pierrepetit57 <pierrepetit57>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WONTFIX    
Severity: normal CC: ilmari.lauhakangas
Priority: medium    
Version: 7.0.0.3 release   
Hardware: All   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108799    
Attachments: Original spreadsheet, original export, modified export

Description pierrepetit57@laposte.net 2020-08-25 20:16:44 UTC
Created attachment 164681 [details]
Original spreadsheet, original export, modified export

I put a note for comment the content of a cell in a spreadsheet.
I have exported the spreadsheet in xhtml format to prevent involuntary change and the result is … awfull.
First, (trivial) the tag <title> in <head> section show the value "- no title specified" while the filename (whithout extension) was expected.
Second, the purpose of my message, my comment-note in cell D4 is displayed in an awfull format. I rewrote the sourcefile of my document to show a solution to this problem.
I join 3 documents :
- the spreadsheet : Exemple.ods ;
- the original xhtml file : Exemple.xhtml ;
- the modified xhtml document : Exemple - Modif.xhtml.
I suggest :
1 - insert the name of the spreadsheet in the <title> tag of exported file ;
2 - add style design (lines 74 to 82 of Exemple - Modif.xhtml)  and modify note treatment (line 177 of the same file) to display correctly the comment notes in Calc Export.
Thanks to your attention.
Excuse my poor english, I'm french !
PK1157
Comment 1 Buovjaga 2021-04-19 16:07:49 UTC
If you use Save as - HTML, the comment is implemented in a better way. It is shown as a red square and upon hover you see the comment. Unfortunately we have these two different HTML export filters. I will close this and let's hope for a unified future.