Results 1 to 2 of 2
  1. #1
    egeesken is offline Member
    Join Date
    Apr 2012
    Posts
    1
    Rep Power
    0

    Default ExcelStyleDateFormatter

    Hi,

    I am trying to insert values in an existing excel sheet (xlsx). This excel sheet is something as a template for my java class.
    I am not the producer of this excel sheet, I just want to use it as it is.
    I am having one problem at the moment, there is a cell which is bound to an ExcelStyleDateFormatter (h:mm).
    When I am typing the value into the cell (online) everything works fine, when i am trying to populate the cell from within my Java Class
    the value is accepted as a text input. When I am inserting a Date object, it is formatted according to the format definition but if i look into the cell
    the value is something like '1.1.1970 13:00:00' and not '13:00'. Can anybody give me a hint how i can come around this problem.


    Regards
    Edmund

  2. #2
    DarrylBurke's Avatar
    DarrylBurke is offline Forum Police
    Join Date
    Sep 2008
    Location
    Madgaon, Goa, India
    Posts
    11,423
    Rep Power
    20

    Default Re: ExcelStyleDateFormatter

    A date value doesn't have a format. the String (or text) representation of a date value has a format.

    db
    If you're forever cleaning cobwebs, it's time to get rid of the spiders.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •