'Old Limit' here includes the version with Office 2003, the 32k is referring to the version currently under development. As well as the 1k characters per cell there's also a 255 character limit on copied cells, e.g. if you make a copy of a sheet with over 255 characters in any cell, only the first 255 get copied. We've been caught out by both of these recently!
Regards, AndyG > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Darren > Sent: 15 January 2006 21:36 > To: 'Protel EDA Discussion List' > Subject: Re: [PEDA] Large BOM line items > > > Hi Harry, > > Sorry, I should have taken more time to read your post. > > I have Office 2002 and it has the limit I posted, and from > the version number looks to be office 10. Seems like the blog > is not completely correct, unless I'm missing something. > > These are bits from that blog, looks to me like depending on > the cell format it can still display 1k characters. > > The total number of characters that can display in a cell > Old Limit: 1k (when the text is formatted) > New Limit: 32k or as many as will fit in the cell > (regardless of > formatting) > > The number of characters per cell that Excel can print > Old Limit: 1k > New Limit: 32k > > The number of characters that can be stored and displayed in a > cell formatted as Text > Old Limit: 255 > New Limit: 32k > > Regards, > Darren Moore > > ****************** This e-mail has been sent from Imagination Technologies Limited. PowerVR, Metagence, Ensigma and PURE Digital are divisions of Imagination Technologies Limited. The information contained in this e-mail, including any attachment, is confidential and may be legally privileged. It is intended solely for the addressee(s) and access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying or distribution or use of the information contained in this e-mail, is prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender by return e-mail and then delete it from your system. Internet communications cannot be guaranteed to be secure, error or virus-free. The sender does not accept liability for any errors or omissions which arise as a result. Any views expressed in this message are those of the author, except where the author specifies and, with authority, states them to be the views of Imagination Technologies Limited. ____________________________________________________________ You are subscribed to the PEDA discussion forum To Post messages: mailto:[email protected] Unsubscribe and Other Options: http://techservinc.com/mailman/listinfo/peda_techservinc.com Browse or Search Old Archives (2001-2004): http://www.mail-archive.com/[email protected] Browse or Search Current Archives (2004-Current): http://www.mail-archive.com/[email protected]
