https://issues.apache.org/ooo/show_bug.cgi?id=123928
Alan <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |UNCONFIRMED Resolution|NOT_AN_ISSUE |--- --- Comment #8 from Alan <[email protected]> --- Ref [1] does not specify that hypertext link values are not output. Ref [2] RFC4180 does NOT specify what fields are or are not output in CSV. It specifies the formatting of the lines and that the content is plain text. Ref [3] states: "Files that contain markup or other meta-data are generally considered plain-text" So meta-data is considered (by the references that you provided) to be plain text. The hyperlink value is meta-data for the cell. You output the meta-data to other formats (XML & HTML) -- you even output cell comments!! The only explicitly stated exclusion of output from a spreadsheet (in any of the provided references) is FORMULAs. The hypertext link value is not a formula, it is TEXT. By refs [1], [2] and [3], the hyperlink value should be output. As to stating that users do not expect the hyperlink value to be output, that is opinion, not fact. There has been at least one other written complaint about Calc not outputting the hyperlink value in CSV format. I think you will find that most people who need the hyperlink value work around the bug by using either HTML or XML output. Sorry but failure to output a TEXT value that is meta-data for a spreadsheet cell is a bug. The hyperlink is text, it is a value of the cell, it is plain text, it is meta-data, and it is inconsistent that Calc outputs meta-data for HTML and XML but not 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.
