Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Excel Cell Data Limit
I am creating an ASP.NET page to dump data to an excel file. This
works fine, but when I open the excel file I get an error that says 'the cell data is too large'. I heard from somebody that excel cells can hold up to 32,000 character, but can only display 1,024 characters in the formula bar. What restrictions does this impose on the data that cannot be displayed? If I do a keyword search, is that data still going to get searched? Thanks in advance, Ryan |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Excel Cell Data Limit
hil
from excel help. Type specifications. 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar i've never tried to pack 32,767 characters in a cell but if they will display, i would assume you can search them. not real sure how it would display the find. Regards FSt1 " wrote: I am creating an ASP.NET page to dump data to an excel file. This works fine, but when I open the excel file I get an error that says 'the cell data is too large'. I heard from somebody that excel cells can hold up to 32,000 character, but can only display 1,024 characters in the formula bar. What restrictions does this impose on the data that cannot be displayed? If I do a keyword search, is that data still going to get searched? Thanks in advance, Ryan |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Excel Cell Data Limit
Even in the formula bar the entire text is not displayed. I know
there is no problem with the data dump itself because when I try to type more characters in the formula bar I get an error saying that the formula is too long. Any ideas? |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Excel Cell Data Limit
hi.
not really. as i said, you're on ground where i have never been. question. why are you dumping that much data into a single cell. seems to me in that lay the problem. I don't think i could manage data that way. I would seriously consider a better way of bringing it in. the info i posted is from excel help xp2003. copy and paste. sorry i could not be more help. Regards FSt1 " wrote: Even in the formula bar the entire text is not displayed. I know there is no problem with the data dump itself because when I try to type more characters in the formula bar I get an error saying that the formula is too long. Any ideas? |
#5
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Excel Cell Data Limit
I put
=rept("x",32765)&"y" in A1:A5 and converted to values (edit|copy, edit|pastespecial|values) And then I did edit|find to search for y's. It found those y's at the end of those strings. On the other hand, I've used Edit|Replace in long strings and gotten "Formula too long" error messages returned--but never with edit|find. But I'm not sure what a keyword search is for your application. You may want to do some testing. wrote: I am creating an ASP.NET page to dump data to an excel file. This works fine, but when I open the excel file I get an error that says 'the cell data is too large'. I heard from somebody that excel cells can hold up to 32,000 character, but can only display 1,024 characters in the formula bar. What restrictions does this impose on the data that cannot be displayed? If I do a keyword search, is that data still going to get searched? Thanks in advance, Ryan -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Excel Cell Data Limit
If the cell does actually contain a formula (a formula starts with the = character), not a
number or text, then the formula length limit applies. I couldn't find formula length limit in the Limits and Specifications part of Help, but it was 1024 characters in Excel 2000. -- Earl Kiosterud www.smokeylake.com Note: Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- wrote in message ups.com... Even in the formula bar the entire text is not displayed. I know there is no problem with the data dump itself because when I try to type more characters in the formula bar I get an error saying that the formula is too long. Any ideas? |
#7
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Excel Cell Data Limit
If the cell does actually contain a formula (a formula starts with the =
character), not a number or text, then the formula length limit applies. I couldn't find formula length limit in the Limits and Specifications part of Help, but it was 1024 characters in Excel 2000. Same for Excel 2003... http://office.microsoft.com/en-us/ex...992911033.aspx See under the "Calculation Specifications" section. Rick |
#8
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Excel Cell Data Limit
If the cell does actually contain a formula (a formula starts with the =
character), not a number or text, then the formula length limit applies. I couldn't find formula length limit in the Limits and Specifications part of Help, but it was 1024 characters in Excel 2000. Same for Excel 2003... http://office.microsoft.com/en-us/ex...992911033.aspx See under the "Calculation Specifications" section. Just found this.... http://blogs.msdn.com/excel/archive/...26/474258.aspx which says the limit has been raised from 1K to 8K, so I guess that means 8192 characters. Rick |
#9
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Excel Cell Data Limit
Find (in values) in Excel 2003 certainly finds text in a cell
containing a long text string. I have written an Excel addin for dealing with cells containing long text strings. It contains a simple cell viewer/editor to allow you to read and edit the content of a cell. You can download it from http://wwwusers.brookes.ac.uk/p00546...ExcelUtils.xla Once it is installed just use the Escape key to start the cell text edit form. Peter Grebenik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Markers, Limit Qty | Charts and Charting in Excel | |||
Excel Data Markers, Limit Qty | Charts and Charting in Excel | |||
Can excel limit the characters in a cell to 28 automatically? | Excel Worksheet Functions | |||
Is there a limit to the size of a cell containing text in Excel 20 | Setting up and Configuration of Excel | |||
Is there a limit to number of words in a cell in excel? | Excel Discussion (Misc queries) |