Excel : Unexpected merged cell range in Table

Create issue
Issue #1143 resolved
Philippe Henri created an issue

Hello,

A one line/ one column table (with no headers) in an excel file causes an exception in openxml/CellReferencesRange.java, function Split()

→ Unexpected merged cell range

(the cell reference is A6 and not A6:A6…)

example excel attached

regards

Phil

Comments (5)

  1. Denis Konovalyenko

    Below is a stack trace for this:

    java.lang.IllegalStateException: Unexpected merged cell range: A6
    
        at net.sf.okapi.filters.openxml.CellReferencesRange.split(CellReferencesRange.java:66)
        at net.sf.okapi.filters.openxml.CellReferencesRange.first(CellReferencesRange.java:51)
        at net.sf.okapi.filters.openxml.CellReferencesRange.rows(CellReferencesRange.java:75)
        at net.sf.okapi.filters.openxml.CellReferencesRange.anyMatch(CellReferencesRange.java:123)
        at net.sf.okapi.filters.openxml.CellReferencesRange.anyMatch(CellReferencesRange.java:129)
        at net.sf.okapi.filters.openxml.SharedStringsPart.lambda$formEventsFor$0(SharedStringsPart.java:173)
        at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:176)
        at java.base/java.util.HashMap$EntrySpliterator.forEachRemaining(HashMap.java:1746)
        at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
        at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
        at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
        at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
        at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
        at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
        at net.sf.okapi.filters.openxml.SharedStringsPart.formEventsFor(SharedStringsPart.java:176)
        at net.sf.okapi.filters.openxml.SharedStringsPart.open(SharedStringsPart.java:105)
        at net.sf.okapi.filters.openxml.OpenXMLFilter.nextInDocument(OpenXMLFilter.java:447)
        at net.sf.okapi.filters.openxml.OpenXMLFilter.next(OpenXMLFilter.java:254)
        at net.sf.okapi.filters.openxml.OpenXMLFilter.next(OpenXMLFilter.java:263)
    

  2. Log in to comment