Multilne comment in an excel cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Icemokka - 26 Feb 2007 17:18 GMT

Hi,

I've made an app in VB6 that allows export to excel.
Everything works fine except for some multiline texts, he only
displays ############ instead of the full text.

I've also tried to correct the problem in the excelsheet itself to see
what I need to change in my export-code.
But even in excell I don't get the cell correctly filled in.

For what reasons does excel display ###### instead of the multiline
text ( cell formatiing is text )?

PS : I can provide the problem excel by mail ...

Regards,
Sven Peeters

Reply to this Message

Dave Peterson - 26 Feb 2007 17:48 GMT

Try formatting the cell as General--not Text.

> Hi,
>
[quoted text clipped - 13 lines]
> Regards,
> Sven Peeters

Signature

Dave Peterson

Reply to this Message

Icemokka - 27 Feb 2007 07:35 GMT

> Try formatting the cell as General--not Text.
>
[quoted text clipped - 7 lines]
> > what I need to change in my export-code.
> > But even in excell I don't get the cell correctly filled in.

That worked, Thank you very much !!!!!!!!!!!!!!!!!!!!!!

> > For what reasons does excel display ###### instead of the multiline
> > text ( cell formatiing is text )?
[quoted text clipped - 9 lines]
>
> - Tekst uit oorspronkelijk bericht weergeven -

Reply to this Message