Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel: Can you print more than 1,024 characters in a cell?

Status
Not open for further replies.

kitchej

MIS
May 27, 2003
16
US
I have a user that has several Excel 2000 spreadsheets used as BOM's (bill of materials) Several cells have over 1,024 characters but she can't print them. They are set for general text format with word wrap enabled. She can edit them no problem but nothing past 1,024 characters will print. We've looked at this but have not found anyway to make it work. I been trying for a couple of days to search the forum but search feature has been down. Any clues?

Thanks in advance!
Jim
 
Length of cell contents (text) : 32,767 characters. Only 1,024 characters display in a cell; all 32,767 display in the formula bar.


Thus, Excel will only print what is visible.

Software: XL2002 on Win2K
Humanware: Older than dirt
 
kitchej,

Holy Macrel! 1024?

You're stuck, I'm afraid with some limit of characters, I'm not exactly sure how many.

But what kind of BoM data has 1000+ characters?

Skip,
[sub]
[glasses] [red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!
[tongue][/sub]
 
Thanks for the quick response guys.

That's pretty much what I expected.

Skip, the BOM's are for large printed wiring boards and the culprits have been the decoupling capacitors. There are well over a hundred with 4 character length numbering, i.e. C001, C044, C101, etc.

Now the hard part, I have to tell the user!

Jim
 


But why in one cell? Are not each of the capcaitors a BoM element?

Skip,
[sub]
[glasses] [red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!
[tongue][/sub]
 


But why in one cell? Are not each of the capcaitors a BoM element?

How can I rename a table as it changes size faq68-1331

Skip,
[sub]
[glasses] [red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!
[tongue][/sub]
 
I know someone who had the same problem. I think he solved it by opening the spreadsheet in Word and printing from there.
 
Skip, the BOM's are setup with one row per component type/value no matter if it's used once or a thousand times. What varies is quantity and component designators in the associated columns.

Pbrodsky, thanks! I just tried it and it works. The user will have to play a little with margins and paper size to get it to fit but at least she can print.

Jim

 


So the component's quantities and component designators are in other columns.

Where are the 1000+ characters coming from?

I deal with large BoMs alot - commercial aricraft manufacturing with hundreds of thousands of components.

Each component and each of it's related properties are stored in separate table elements (Cells) Having a hard time visualizing the source of the problem.

Skip,
[sub]
[glasses] [red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!
[tongue][/sub]
 
Skip, reference designators are in one column so there may be several hundred of them in one cell.

A=BOM Level, B=Find#, C=Item#, D=Desc, E=Qty, F=RefDes, etc.

Jim
 
So why are they not in separate columns? That is how the data is normally organized -- NOT in a single field.

Skip,
[sub]
[glasses] [red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!
[tongue][/sub]
 
Skip, maybe I should back this up some. These BOM's were generated differently from our normal ERP built BOM's. I don't know the reason why, guess I should ask the buyer, but she pulled me in to see if the printing problem could be fixed.

Jim
 


I'd be addressing why the BoM output is screwed up rather than doing a work around for a condition that should not exist!

Skip,
[sub]
[glasses] [red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!
[tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top