Article - CS138332
Excel export/import behavior is not consistent for decimal number separator in French or German language in Windchill PDMLink
Modified: 28-Dec-2016
Applies To
- Windchill PDMLink 10.0 to 10.2
Description
- Excel export/import behavior is not consistent for decimal number separator in French or German language.
- NumberFormatException appears while trying to do an Excel import of a WTPart with attribute decimal number using a comma separator
- Nested exception is: java.lang.NumberFormatException: For input string: "XX,XX"
at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:1222)
at java.lang.Double.parseDouble(Double.java:510)
at wt.ixb.handlers.forattributes.ExpImpForIBAAttr.getAttrValue(ExpImpForIBAAttr.java:2546)
at wt.ixb.handlers.forattributes.ExpImpForIBAAttr.getAttrValue(ExpImpForIBAAttr.java:2504)
at wt.ixb.handlers.forattributes.ExpImpForIBAAttr.importAttrValues(ExpImpForIBAAttr.java:2717)
at wt.ixb.handlers.forattributes.ExpImpForIBAAttr.storeIbaSdaValues(ExpImpForIBAAttr.java:2406)
at wt.ixb.handlers.forattributes.ExpImpForIBAAttr.importIbaSda(ExpImpForIBAAttr.java:2384)
at wt.ixb.handlers.forattributes.ExpImpForIBAAttr.importAttribute(ExpImpForIBAAttr.java:1024)
at wt.ixb.publicforhandlers.IxbHndHelper.importAttribute(IxbHndHelper.java:675)
at wt.ixb.handlers.forclasses.ExpImpForWTPart.importWTPartObjectAttributes(ExpImpForWTPart.java:195)
at wt.ixb.handlers.forclasses.ExpImpForWTPart.importObjectAttributes(ExpImpForWTPart.java:167)
at wt.ixb.actor.ActorTemplateForVersioned.importObjectAttributes(ActorTemplateForVersioned.java:55)
at wt.ixb.publicforhandlers.ExpImpForVersionedObject.importElement(ExpImpForVersionedObject.java:196)
at wt.ixb.publicforapps.Importer.importElement(Importer.java:1173)
at wt.ixb.publicforapps.Importer.doRealImport(Importer.java:997)
at wt.ixb.publicforapps.Importer.finalizeImport(Importer.java:451)
at wt.ixb.publicforapps.Importer.finishImport(Importer.java:701)
at com.ptc.windchill.ixb.importer.part.PartSheetImporter.importSheetElements(PartSheetImporter.java:125)
at com.ptc.windchill.ixb.importer.StandardImportService.doSameTypeSheetImport(StandardImportService.java:936)
at com.ptc.windchill.ixb.importer.StandardImportService.doPreviewOrImport(StandardImportService.java:797)
at com.ptc.windchill.ixb.importer.StandardImportService.importSpreadsheet(StandardImportService.java:194)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at wt.queue.QueueEntry.execute(QueueEntry.java:231)
at wt.queue.ProcessingQueue.execEntry(ProcessingQueue.java:287)
at wt.queue.ProcessingQueue.execEntries(ProcessingQueue.java:877)
at wt.queue.PollingQueueThread.run(PollingQueueThread.java:109)
IMPORT RESULT : FAILED
This is a printer-friendly version of Article 138332 and may be out of date. For the latest version click CS138332