Exporting to Excel formatting question

[Guest_imported]

when I export a report from crystal to excel, the formatting does odd things. For example, if I click onto a cell and then go up the area where I want to change the value and then click back to a different cell, the original cell I clicked on moves to the right justified position...even thought it was left justified at the beginning. The second odd thing it does is it doesn't allow me to do vlookup, unless I've clicked on the cells, excel doesn't recognize them. any help out there? thank you, thank you in advance.

 

[kenhamady]

What version of CR/excel are you using to read the file, and what version of the export driver are you using?

What do you mean by:
"if I click onto a cell and then go up the area where I want to change the value"
What area?



Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[Guest_imported]

What I mean by clicking into an area is this...ya know how if you click onto a cell in excel, for example a cell that has the value "today". Well, if you want to change that cell to read the value "tomorrow" you can go to the formula bar and put your new value in. Then when you click on the cell or press enter, the new value is in your cell.

The version of Crystal is 7.0 and Excel is '97-sr2

thanks in advance for any help...

 

[kenhamady]

You probably had a character field to begin with (even if it contained numbers), and your new value is numeric. Chars are left aligned, and numerics are right aligned.

Start your entry with an apostrophe, and it should be a string and left align.

When you export, what version of Excel do you select for export format?

Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)