[patch] cut off text longer than Excel cell restrictions

[jholg]

Excel has a limit of 32767 characters for cells.

This patch allows for configurable setting of a max. number of characters for (text) fields, defaulting the Excel limit of 32767.

When cutting off text an ellipsis string gets added to the end of the cut-off string to mark that the string has been truncated. The default ellipsis is "[...]".

trac.ini example:

[exceldownload]
# Example: Set another ellipsis string (default: ellipsis = [...])
ellipsis = .....
# Example: unset limits (default: max_text_size = 32767)
max_text_size = 0

Find patch based on r12346 of ExcelDownloadPlugin attached.

Note: Patch diff has been generated from ExcelDownloadPlugin patched with the (somewhat related) exceldownload_longtext_patch.diff​ as proposed in #10623.

So ideally exceldownload_longtext_patch.diff​ should be applied first and then this patch afterwards ;-). Apart from that I guess it's trivial enough to do manually, if interested.

Holger

[jholg]

Patch to cut off text that breaks Excel 32767 character cell limits

[Jun Omae]

In 14858:

ExcelDownloadPlugin: cut off text in cell longer than 32,767 characters (closes #10624)