How to Format a Cell as pure Text

[MW]

Hi,

i have problem to format a Cell as pure Text.
To format as date/datetime, currency, integer etc isn't a Problem.
This is possible with the NumberFormat property.

But what is to do, if i want to format the cell as pure Text, not as standard ?

Has sombody an idea ?

[larsa]

Hello

I'm not really sure on what you mean. If you want text, just add a cell value without any formattin, FormatIndex := -1.


Lars Arvidsson

[Guest]

Hi,

I have the same problem than MW. I add a cell with a value like '3165140022018' as textvalue to the sheet (it have to be a textvalue and not a numbervalue).

For example:
XLS.Sheet[0].AsWideString[1,1] := '3165140022018';

In the Excelsheet the value is represented accurately. But when I change the value in the Excelsheet in '3165140022019' the represented value will changed in '316514E+12'.
The reason for this is the default (standard) cell format. The '...E+...'-value will not apear with the cell format "text".

Is it possible to set the cell format to "text"?

[KenWhite]

Sure you can:

Code: Select all

XLS.Sheets[0].Cell[Col, Row].NumberFormat := '@';


Ken

[Guest]

now it works! Thanks a lot to KenWhite!

[grchristin]

Anyone have ideas on how to fix this? I have strings with leading spaces and I want them to stay there. The spaces appear to be there after XLSDbRead reads in the data but after writing it out and opening the spreadsheet the leading spaces are all gone.

FYI - this only happens when exporting to Excel2007. Works fine in with Excel97!

Thx in advance!