OWC Spreedsheet: Format bug

[Patrice Dargenton]

I found a bug with Format using OWC Spreadsheet. The description of this bug
is similar to the three examples I also found in this newsgroup (see below).
Is this bug have been fixed in a patch or in OWC 2002 or 2003? Or is there a
workaround?
Thanks for help.
-------------------------------------------------------
Patrice Dargenton
(e-mail address removed)
http://patrice.dargenton.free.fr/index.html
-------------------------------------------------------

De :Scott Woods ([email protected])
Objet :Auto Formatting on Data load
Groupes de discussion :microsoft.public.office.developer.web.components
Date :2002-07-09 11:24:41 PST

We are using the HTMLUrl property to load data into an OWC9
SpreadSheet object. Is there a way to turn off formatting before we
load the data? What is happening is if the data is a number with a
single letter (either A or P) after it, OWC converts it to a
date-time. So 123A gets converted to `01/04/1900 3:00AM`. We have
tried setting the NumberFormat to TEXT but it will still convert it to
a date-time. Any clues on how to override these automatic changes to
our data? I want to see exactly what we provided it, not what it
thinks it should be.
Any help would be greatly appreciated.


De :Miquel Burns ([email protected])
Objet :Setting the format of the data for spreadsheet
Groupes de discussion :microsoft.public.office.developer.web.components
Date :2003-07-28 09:28:11 PST

The web application I'm working has output for Excel sheets, but the
data from the data is sometimes changed to a date format (And results in
a '#######' cell each time this happens, and the value is not the same
as what was retrieved from the database so that bit of data becomes
worthless).

Question, how to you set the format to plain text so Excel doesn't
reformat certain values to something like date/time and mess up the data
the user recieves?
(And how to format a column to currency would also be useful)

VBScript, the OWC from Office 2000


De :Bernard Sheppard ([email protected])
Objet :OWC Spreadsheet does not recognise regional date formats?
Groupes de discussion :microsoft.public.office.developer.web.components
Date :2000-11-16 18:01:59 PST

I've come across what seems to be a bug in the OWC Spreadsheet.

Using the .CSVData property to load a CSV file that includes dates in the
standard Australian format - DD/MM/YYYY. We have no control over the date
format in the CSV file.

The data is displayed as loaded for dates that cannot be correctly
interpreted as a US format date, and as incorrect dates for those that can
be mis-interpreted.

For example...

30/05/2000,This item is 30 May 2000,other data
01/06/2000,This item is 01 June 2000,other data

is displayed as (assuming Format is set to Medium Date)

30/05/2000 This item is 30 May 2000 other data
06-Jan-2000 This item is 01 June 2000 other data

in the OWC Spreadsheet.

When the same data is loaded into Excel, the dates are correctly
interpreted....
30-May-2000 This item is 30 May 2000 other data
01-Jun-2000 This item is 01 June 2000 other data

Regional settings on the PC are set English (Australian)

Running O2K SP1, on either Win2K SP1 or NT4SP6a

 

[Patrice Dargenton]

I found the cause of the bug: The local parameters "Decimal Separator" must
be a dot, and not a comma "," like this is usually the case in French.
String must be prefixed by a quote (only one quote). If not, the field is
trimmed: the spaces are stripped. It is possible to add a quote in front of
a field in a SQL query (in order to load the entire spreadsheet in one
instruction): a lot of work is required to prefix each string field, but it
works!