id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release
10623,[patch] use excel cell type standard for cols with long text content_ character replacement,jholg,jun66j5,Hi_\r\ngreat plugin!\r\n\r\nFor my use case I noticed that often the resulting spreadsheets display "hash marks" for cells containing lots of text_ which ticket descriptions and comments regularly do.\r\n\r\nThis is due to some Excel "feature"_ see http://excelribbon.tips.net/T008444_Hash_Marks_Displayed_Instead_of_Cell_Contents.html for explanations.\r\n\r\nTherefore I added the possibility to configure columns as "long text columns" which will then get the Excel cell type "Standard" instead of "Text" which doesn't suffer from this particular problem. Per default_ columns 'description' and 'comment' are qualified as "long text columns".\r\n\r\nAdditionally I encountered some problems with characters in ticket descriptions that aren't displayed nicely in the spreadsheets_ e.g. Tab characters and stuff_ probably put into ticket comments and descriptions by cut-and-paste. To handle this I added a possibility to specify simple text replacement rules to remove or change such characters_ by using `re.sub(...)`. Per default_ no replacement is done.\r\n\r\nLooks like this in trac.ini:\r\n{{{\r\n[exceldownload]\r\n# Example: switch off long-text-column treatment \r\n# (default is long_text_columns = description_comment)\r\n#long_text_columns = \r\n# replace tabs and carriage return characters with 4 blanks '=>' is the split\r\n# character to split match expression and replacement string in the rules\r\nreplace_text = (\\t|\\r)=>"    "\r\n\r\n# Example: if you can't use the default split character(s) '=>' due to \r\n# your regexp or replacement string you can configure a different split text:\r\n#replace_text = (\\t=>|\\r):"    "\r\n#replace_text_split_char = :\r\n}}}\r\n\r\nFind patch attached.\r\n\r\nHolger\r\n,enhancement,new,normal,ExcelDownloadPlugin,normal,,,,0.12