|
PureBytes Links
Trading Reference Links
|
Ton:
So there seems to be no problem when Excel expresses the DownLoader dates in
text format -- which yyyymmdd (your testing) and m/dd/yy (my testing)
seems to consistently return. For me, the problem appeared when DownLoader
handed the dates to Excel as dd/mm/yy, in which case Excel tried to express
the post-September dates in date format (rather than text) and incorrectly.
Were you able run any tests with Control Panel's Regional Settings set to
dd/mm/yy ?
Regards.
----- Original Message -----
From: A.J. Maas <anthmaas@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: October 11, 1999 16:25
Subject: Re: Strange bug?
> Glen,
>
> I replicated your "month-switch-over" and have no problems whatsoever.
>
> Here the "Control Panel|Regional Settings" for the Windows' OS dates
> is set to: yyyymmdd
> and data "copied" from the Downloader and pasted into a new Excel
> spreadsheet instance, automatically gets the Equis' default
> notation: mm/dd/yyyy
> and is also seen by the Excel program as text.
> This text-bit I have tested by the =IsText(A1:A6) function, and the
results
> were True.
> Here the cell properties-tab also states that the cells are in the
'Standard' format
> (eg common for/in the default xlb-Workbook Template).
> Going into the cells properties further, will allow me to change this
arrangement to
> my likings (whatever line up I prefer), and can be done pre or after the
pasting.
>
> Also my Excel's default "blanc-spreadsheet-on-opening" (eg the xlb
workbook
> template used by the Excel program on start up) here does have the
settings for
> its cell properties set to the common "Standard" option (eg when I open a
new instance
> and right click for instance cell A1|Properties).
> And this is still my 'original' first template created after the
installation of the Excel
> program a couple of years ago, when only some of my Tools|Options|......
settings
> were implemented, like the amount of sheets that a workbook should hold,
> my user name, the default folder etc. etc. .
>
> Therefore, imo, your Excel's template for "new sheets on opening" has
slightly
> been "corrupted", eg you should try and replace it by a copy of the one
that always
> gets copied (gets created) on such a standard Excel installation, eg you
will just
> have to re-create it.
>
> To re-create:
> -go to the C:\Windows folder or do a search, eg search for the file
Excel8.xlb
> -also search for the file xxxx8.xlb (where xxxx is your Excel's user
name,
> see for your username Tools|Options|General)
> -rename the original xxxx8.xlb to xxxx8-old.xlb
> -copy the file Excel8.xlb to another folder and rename it to the
original xxxx8.xlb
> (eg where xxxx is your Excel's user name)
> -move this renamed "yourname"8.xlb to the C:\Windows folder (or to the
folder
> where you have first found it)
> -Run Excel
>
> Note that the C:\Windows folder was also the folder automatically picked
by
> the Excel set-up for storing the Workbook Template and that "8" is the
version # of
> my Excel program.
>
> Regards,
> Ton Maas
> ms-irb@xxxxxxxxxxxxxxxx
> Dismiss the ".nospam" bit (including the dot) when replying and
> note the new address change. Also for my Homepage
> http://home.planet.nl/~anthmaas
>
>
> ----- Original Message -----
> From: Glen Wallace <gcwallace@xxxxxxxx>
> To: MetaStock listserver <metastock@xxxxxxxxxxxxx>
> Cc: MetaStock Support <support@xxxxxxxxx>
> Sent: zondag 10 oktober 1999 20:31
> Subject: Strange bug?
>
> > MetaStalkers:
> >
> > I display my data in dd/mm/yy format, and Ken (wander@xxxxxxxx) and I
have
> > noticed a problem when it's copied to an Excel spreadsheet.
> >
> > DownLoader converts it automatically to mm/dd/yyyy format. That in
itself
> > is fine, but either DownLoader or Excel has trouble with dates beginning
> > October 1, 1999. Attached are two .gif files -- the first is the
> > DownLoader file showing September 30 and October 1 data. The second is
the
> > Excel file for the same period. The September 30 dates in the Excel
file
> > appear to be text fields and the October 1 dates have been converted to
> > January 10. If you try to work with this or convert it back to
MetaStock,
> > you will have problems.
> >
> > Kind of strange, but it doesn't appear to be anything more than an
annoyance
> > and something for non-U.S. users to be aware of.
> >
> > No apparent problems when the Windows Regional Settings are set to
m/dd/yy
> > format.
> >
> > cc: Technical Support
|