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