 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / May 2008Maximum text length in a cell
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: intel Could-it be possible the maximum text length is now limited in a text cell. I have a lot of Excel 2004 files with cell with long text writen in it. I was able (using 2004 Excel) to view, print with no problem but it is impossible to exceed these limits in 2008 version : Display text cell : maximum 255 characters Print text cell : maximum 226 characters When maximun is reached, "XXXXXXX..." are displayed instead of the text on screen and it is not printing (but the space normaly use by the text area is). I would like to know if this is a new limitation in Excel 2008 or a bug that will be fixed in a future patch. If this is a new limitation, then why it is not working for both (display and print) using the same limits ? Thank's I'm sorry I don't have a solution for you, but I can confirm that the Limits & Specifications for Excel 2008 are identical in this regard to those of Excel 2004: 32,767 characters per cell capable of displaying all in the Formula Bar but only 1,024 in the cell. AFAIK there is no preference setting that would change that. Can you provide more specific detail about your OS & Office versions, Mac specs any anything additional you can share about the files themselves. Odd as it may seem, also check to see if there may be an update available for your printer driver. I am seeing some unexpected behavior in what I've been playing with but want to test further before commenting. I hope to be able to do so later this evening or tomorrow.  SignatureRegards |:>) Bob Jones [MVP] Office:Mac > Version: 2008 > Operating System: Mac OS X 10.5 (Leopard) [quoted text clipped - 22 lines] > > Thank's On 5/8/08 5:47 PM, in article OKzCIUVsIHA.484@TK2MSFTNGP04.phx.gbl, > I'm sorry I don't have a solution for you, but I can confirm that the Limits > & Specifications for Excel 2008 are identical in this regard to those of [quoted text clipped - 10 lines] > to test further before commenting. I hope to be able to do so later this > evening or tomorrow. If a cell displays "XXXX" (I think you really mean "####") this means that the column width is not large enough to display the result of a formula. What is the actual text in that column, and how is it derived? SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom Hi CyberTaz and Bob, Thank's for your reply. Here is some more détails : MAC OS 10.5.2 ( I did apply ALL automatic Apple's update available) OFFICE 2008 (Excel 12.0.1) French Yes it is "####" instead of "XXXXX" that are displayed on the screen. But this behavior is only happening when I change the Cell format from "Standard" to 'Text". The printer driver is the latest I could find from the manufacturer Web Site. Cell Format (for text) are : Standard, Top - Left - Wrap mode (of course) Geneva - Normal - 9 - Color automatic No border (only the one in printing format) No background color Unlocked cell Text is directly entered in the cell If necessary, I can arrange the file to be available from a ftp site Thank's for your help On 5/14/08 7:53 AM, in article ee9a91e.2@webcrossing.caR9absDaxw, > Hi CyberTaz and Bob, > [quoted text clipped - 22 lines] > > Thank's for your help What is the text? Is the cell wide enough for the first word and a space character? Does it show #### in normal view, or just print preview? Try updating to SP1 to see if that makes a difference. SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom > Try updating to SP1 to see if that makes a difference. > > -- > Bob Greenblatt [MVP], Macintosh > bobgreenblattATmsnDOTcom Yahooo !!!! he application of the SP1 solve the problem. Thank you very much again Bob |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.