######## in Excel cells

[z96andh]

Hi!

When i export from Crystal Report 8 with u2fxls.dll (2000-01-26) i get ######## in all cells that are 0 (zero). If Í look at the cell format it is:

0_);-0;&quot;<Default Format>&quot;

I haven't received this error before...

BR
/Anders

 

[synapsevampire]

It's not an error.

Widen the column when in Excel.

-k

 

[z96andh]

When I widen the column the following is shown in the cells:

<Default Format>

 

[IdoMillet]

The format applied to these cells specifies that a zero value should result in the text &quot;Default Format&quot; to appear there.

hth,
- Ido



CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[z96andh]

Hi!

But why should it result in &quot;Default Format&quot;? Where is that configured in Crystal Reports?

 

[kimchavis]

Try this:

If you go into the field this is happening to and go to format field. You can go into customize. You will see under &quot;Show zero values as&quot; You can change this from <default format> to 0. See if that works.

Kim Chavis

 

[synapsevampire]

In newer versions of Crystal you have some control over the export for numbers and dates.

Perhaps there's a hotfix on the crystaldecisions, er, businessobjects website to correct it:

http://support.businessobjects.com/search/advsearch.asp?ref=default.asp_selectlist

BTW, are we to refer to ourselves as Businessobjects consultants now?

-k