https://issues.apache.org/ooo/show_bug.cgi?id=123928
--- Comment #6 from Alan <[email protected]> --- Created attachment 82192 --> https://issues.apache.org/ooo/attachment.cgi?id=82192&action=edit Calc Spreadsheet with two rows of data in two columns I have attached a zip file with six items. The readme.txt file contains basically what is in this comment. bugzillaError.jpg shows the error I get when attempting to attach an .ods file using the "Browse..." function of the Bugzilla WEB page. The other five files demonstrate the issue. The spreadsheet testSheet.ods has one row and two columns. The first column contains text (visible) and a hyperlink (hidden). The second column contains text. If I output as XML (using Save As) the hyperlink value is output to the XML file (testSheet.xml) as shown by this content in the XML file: <Cell ss:HRef="http://www.openoffice.org/";><Data ss:Type="String">open office</Data></Cell> If I output as HTML (using Save As) the hyperlink value is output to the HTML file (testSheet.html) as shown by this content in the HTML file: <TD WIDTH=84 HEIGHT=18 ALIGN=LEFT><A HREF="http://www.openoffice.org/";>open office</A></TD> If I output as CSV (using Save As) the hyperlink value is NOT output to the CSV file (testSheet.csv) as shown by this content in the CSV file: open office,some text Hidden values are being output to XML and HTML as part of the cell contents. So saying that hidden values are not output is incorrect. They are output. My issue is that they are not output when the output format is CSV. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
