Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merged cells text 255 chars causes "#" to be displayed
I have one cell on a template that displays all "#########....." when I
insert more than 255 characters, although all text is present and can be edited. Merged cells are formatted as Text, Wrap=true, merged over 10 columns and 2 rows. No validation or conditional formatting applied. No code running upon change. Reading: http://office.microsoft.com/en-us/as...992911033.aspx shows no reason for this behaviour. If the merged cells are formatted as General, then text is displayed as usual. As barcodes may be inserted in this area, I need it formatted as Text. NickHK |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merged cells text 255 chars causes "#" to be displayed
Nick, It's not merged cells that's causing the problem, Appears to be the use of @ in the (custom) numberformat when applied to text 255 char. Also i cant see that you have a problem: I've never heard of a valid barcode that was longer than 255 chars.. ... so just insert multiple barcodes in multiple cells. or start the string with an apostrophe or vblf/linefeed -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam NickHK wrote : I have one cell on a template that displays all "#########....." when I insert more than 255 characters, although all text is present and can be edited. Merged cells are formatted as Text, Wrap=true, merged over 10 columns and 2 rows. No validation or conditional formatting applied. No code running upon change. Reading: http://office.microsoft.com/en-us/as...992911033.aspx shows no reason for this behaviour. If the merged cells are formatted as General, then text is displayed as usual. As barcodes may be inserted in this area, I need it formatted as Text. NickHK |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merged cells text 255 chars causes "#" to be displayed
what can I say? there's plenty of 16bit legacy in Excel. and plenty of trouble with strings 255 content is truncated when sheets are copied. many functions wont work on "long" strings. editing formulas/names etc etc etc silly?.. i'd use a stronger word myself. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam NickHK wrote : keepITcool, I can work around, but it seems pretty silly that the only format specifically for text cannot handle more than 255 characters, whilst all the others display correctly. Correction to above: Looking at the Format cellsNumber dialog, the "Sample" frame at the top display correctly for all formats except General, Accounting & Text which show "#####.." instead of the correct text. Of these 3, Accounting & Text cause the cell to display "####..." NickHK "keepITcool" wrote in message ft.com... Nick, It's not merged cells that's causing the problem, Appears to be the use of @ in the (custom) numberformat when applied to text 255 char. Also i cant see that you have a problem: I've never heard of a valid barcode that was longer than 255 chars.. .. so just insert multiple barcodes in multiple cells. or start the string with an apostrophe or vblf/linefeed -- keepITcool www.XLsupport.com | keepITcool chello nl | amsterdam NickHK wrote : I have one cell on a template that displays all "#########....." when I insert more than 255 characters, although all text is present and can be edited. Merged cells are formatted as Text, Wrap=true, merged over 10 columns and 2 rows. No validation or conditional formatting applied. No code running upon change. Reading: http://office.microsoft.com/en-us/as...992911033.aspx shows no reason for this behaviour. If the merged cells are formatted as General, then text is displayed as usual. As barcodes may be inserted in this area, I need it formatted as Text. NickHK |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merged cells text 255 chars causes "#" to be displayed
keepITcool,
I can work around, but it seems pretty silly that the only format specifically for text cannot handle more than 255 characters, whilst all the others display correctly. Correction to above: Looking at the Format cellsNumber dialog, the "Sample" frame at the top display correctly for all formats except General, Accounting & Text which show "#####.." instead of the correct text. Of these 3, Accounting & Text cause the cell to display "####..." NickHK "keepITcool" wrote in message ft.com... Nick, It's not merged cells that's causing the problem, Appears to be the use of @ in the (custom) numberformat when applied to text 255 char. Also i cant see that you have a problem: I've never heard of a valid barcode that was longer than 255 chars.. .. so just insert multiple barcodes in multiple cells. or start the string with an apostrophe or vblf/linefeed -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam NickHK wrote : I have one cell on a template that displays all "#########....." when I insert more than 255 characters, although all text is present and can be edited. Merged cells are formatted as Text, Wrap=true, merged over 10 columns and 2 rows. No validation or conditional formatting applied. No code running upon change. Reading: http://office.microsoft.com/en-us/as...992911033.aspx shows no reason for this behaviour. If the merged cells are formatted as General, then text is displayed as usual. As barcodes may be inserted in this area, I need it formatted as Text. NickHK |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merged cells text 255 chars causes "#" to be displayed
Given that I have just now seen this, after many years of Excel, it can't be
a major problem for me, just annoying. NickHK "keepITcool" wrote in message ft.com... what can I say? there's plenty of 16bit legacy in Excel. and plenty of trouble with strings 255 content is truncated when sheets are copied. many functions wont work on "long" strings. editing formulas/names etc etc etc silly?.. i'd use a stronger word myself. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam NickHK wrote : keepITcool, I can work around, but it seems pretty silly that the only format specifically for text cannot handle more than 255 characters, whilst all the others display correctly. Correction to above: Looking at the Format cellsNumber dialog, the "Sample" frame at the top display correctly for all formats except General, Accounting & Text which show "#####.." instead of the correct text. Of these 3, Accounting & Text cause the cell to display "####..." NickHK "keepITcool" wrote in message ft.com... Nick, It's not merged cells that's causing the problem, Appears to be the use of @ in the (custom) numberformat when applied to text 255 char. Also i cant see that you have a problem: I've never heard of a valid barcode that was longer than 255 chars.. .. so just insert multiple barcodes in multiple cells. or start the string with an apostrophe or vblf/linefeed -- keepITcool www.XLsupport.com | keepITcool chello nl | amsterdam NickHK wrote : I have one cell on a template that displays all "#########....." when I insert more than 255 characters, although all text is present and can be edited. Merged cells are formatted as Text, Wrap=true, merged over 10 columns and 2 rows. No validation or conditional formatting applied. No code running upon change. Reading: http://office.microsoft.com/en-us/as...992911033.aspx shows no reason for this behaviour. If the merged cells are formatted as General, then text is displayed as usual. As barcodes may be inserted in this area, I need it formatted as Text. NickHK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text stored in a cell is displayed as a string of "#####..." | Excel Discussion (Misc queries) | |||
sort spreadsheet, "merged cells" comes up. Find cells? Unmerge ? | Excel Discussion (Misc queries) | |||
How to turn off the large text "Page 1" etc, displayed in spreadsh | Excel Discussion (Misc queries) | |||
When is "?" really a "?" (.SaveAs with Chinese chars) | Excel Programming | |||
Convert "merged" cells to "CenterAcrossSelection" | Excel Programming |