Exporting to Excel, truncated strings. 1

[Kebabmeister]

CR V8.5
ORCL9 DB

When exporting to excel v8 the following long text field:


This workorder is covered by our comprehensive contract with the Client.

If the fault is outside the following scope it is Capex work, and approval is required from TW before carrying out the work - please provide an estimate in this case:-

Filters, valve repair kits, drive belts, fan bearings, drive couplings, switches, seals, electric heating elements, lubricants, manometer fluid, panel gaskets, glass traps, chemicals. Fuses, miniature circuit breakers, residual current devices, isolators, contactors, contacts, over current devices, auxiliary contacts, relays, timers, lamps, push buttons, solenoid valves interlocks, seals, lubricants, impellers fasteners, belts, drive couplings, mechanical seals, stuffing box packing, anti vibration mounting pads, air flow temperature/static pressure sensors. Direct & indirect storage & non-storage humidifier control valves & actuators. Fire and control actuators., motors less than or equal to 5kw, attenuator section



truncates to

This workorder is covered by our comprehensive contract with the Client.

If the fault is outside the following scope it is Capex work, and approval is required from TW before carrying out the work - please provide an estimate in this case:-

Filters,



Any idead as to why?

 

[Madawc]

In 2003, there was a change in Crystal 8.5 exporting that improved it a great deal. If your export-choice says things like Excel Extended rather than MS Excel 97, then an update may fix it. I assume 'BO' still have them for Crystal 8.5 customers.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[IdoMillet]

I wonder if inserting the field into a Text object would solve the issue. Worth a try...

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Kebabmeister]

Genius is a word overused. Fit's though.

Thanks

 

[IdoMillet]

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com