Somewhere the cell changes from displaying as it does - like date - in Excel
to a number it has been translated to in J

It is possibly stored in Excel as a number and Excel has a marking somewhere
that it is really a date that needs to be translated before it is displayed
If Excel knows it is a date that info must be somewhere in the file -
marking that cell as a date

2006/11/16, bill lam <[EMAIL PROTECTED]>:

Björn Helgason wrote:
> I guess you have a way of letting tara tell you if a cell should contain
> date.

I just checked test.xls. Theoretically, this is possible.

If a cell contains a date, its cell format string should be something like
d-mmm-yyyy but there a lot of variations (localisation) and also there are
user
defined formats. It requires some guesswork and can not be 100% correct.

--
regards,
bill
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm




--
Björn Helgason, Verkfræðingur
Fugl&Fiskur ehf, Þerneyjarsund 23, Box 127
801 Grímsnes ,t-póst: [EMAIL PROTECTED]
Skype: gosiminn, gsm: +3546985532
Landslags og skrúðgarðagerð, gröfuþjónusta
http://groups.google.com/group/J-Programming


Tæknikunnátta höndlar hið flókna, sköpunargáfa er meistari einfaldleikans

góður kennari getur stigið á tær án þess að glansinn fari af skónum
         /|_      .-----------------------------------.
        ,'  .\  /  | Með léttri lund verður        |
    ,--'    _,'   | Dagurinn í dag                     |
   /       /       | Enn betri en gærdagurinn  |
  (   -.  |        `-----------------------------------'
  |     ) |        (\_ _/)
 (`-.  '--.)       (='.'=)
  `. )----'        (")_(")
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm

Reply via email to