Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Importing Excel time of day issue

  1. #1
    Join Date
    Jul 2008
    Posts
    2

    Unhappy Importing Excel time of day issue

    When attempting to import a sheet from an Excel workbook, that contains cell validation with drop-down lists, sheets saved before noon work fine, but sheets saved after noon fail with 'Unrecognized token'. Touching the file with a new, morning timestamp before running the transformation does not correct the problem, however loading the file into Excel and saving it out again before noon (with no other changes) will correct the error. I have spent some time in the source code of JExcelApi, but replacing the jar in the PDI libext directory does not cause my version to be used either.

    Any insights greatly appreciated!

    Ricky Barron
    Suncorp (Australia)

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    The jar file in the libext is however the one used by PDI, so if you changed that one and you're changes are not visible it's because of something else... other jar file in the path, you made a change an a path not being executed...

    And do raise a JIRA for this.

    Regards,
    Sven

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.