#9777: Maximum string length saved for Excel worksheet - vary the value based on the Excel Format chosen

swissarmyknife(*) reported 2013-08-14T15:29:17Z · last modified 2013-08-19T20:18:03Z

Dev	funfun
QA	swissarmyknife(*)

Priority	Low
Complexity	Unknown

Component	App - Options
Version	14.0

Currently, the default value of

File > Options > Results > Save Results > [Maximum string length saved for Excel worksheet] = 1024.

Consider setting this value to greater than 1024 when a user sets

File > Options > General > [Default Spreadsheet Format] = Excel 2007

see note on Excel 2007 cell character max length

http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx

XLSX ( 2007 )

Total number of characters that a cell can contain: 32,767 characters

All Comments (3) Change History

SachinPrakash 2013-08-14T17:27:04Z · (edited)

Lets set the default to 32,767, regardless of the spreadsheet format chosen.

swissarmyknife(*) 2013-08-14T17:03:14Z

I just tested with the option set to 32767 and there didn't seem to be any problems

funfun 2013-08-16T01:10:39Z

Default now is set to 32,767:
14.0 - SVN r33632/14.0.0-beta-86
trunk - SVN r33633/15.0.0-dev-8