https://issues.apache.org/ooo/show_bug.cgi?id=123928
--- Comment #4 from Alan <[email protected]> --- Created attachment 82188 --> https://issues.apache.org/ooo/attachment.cgi?id=82188&action=edit Image of the Calc spreadsheet content I could not attach the spreadsheet because the Bugzilla "Browse..." function won't let me. However, the attached JPEG image of the spreadsheet content will hopefully be sufficient to make this clear. The image is of a spreadsheet with two rows. The window over the spreadsheet is the hyperlink menu which shows the value of the hyperlink in the first row, first cell. I want to output the two rows (of two columns) to CSV format (comma separated plain text). The first column has a hyperlink and the second column is just text. The first column has TWO values for each cell. One is the value displayed in the column and the second (not displayed) is the hyperlink content. When using "Save As" and outputting to (apparently) anything but CSV, the hyperlink value is output. For CSV it is not output. The hyperlink value is part of the content of the cell and should be output (in my opinion...) since it is data in the spreadsheet and without it the cell content is useless. The Calc output of the spreadsheet when using Save As to CSV is: open office,some text firefox,some other text and this is useless. The most important content (the hyperlink value) has not been output. >From my perspective, the output to CSV should be: open office,http://www.openoffice.org/,some text firefox,http://www.mozilla.org/en-US/firefox/new/,some other text or http://www.openoffice.org/,open office,some text http://www.mozilla.org/en-US/firefox/new/,firefox,some other text -- 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.
