Invalid formula syntax while loading a spreadsheet with viewfile macro

XMLWordPrintable

    • Type: Bug
    • Resolution: Duplicate
    • Priority: High
    • 4.1
    • Affects Version/s: 3.3.3
    • Component/s: None
    • Environment:

      operating.system: Linux
      os.architecture: 32/64bits
      application.server: Apache Tomcat/6.0.26
      java.version: 1.6.0_26

      Problem

      When loading a spreadsheet with viewfile macro that refers to external files, a number of this message is shown in the catalina.out file:

      Cell:row:2 col:3 Formula:[/Documents%20and%20Settings/user/My%20Documents/file.xlsx]Sheet1!$B$10
com.jxcell.CellException: Invalid formula syntax.
	at I.V.getSheetNumber(EYFN)
	at I.V.getCol1(EYFN)
	at I.V.I(EYFN)
	at I.C.I(EYFN)
	at com.jxcell.TD.eWarning(EYFN)
	at com.jxcell.TD.eTime(EYFN)
	at com.jxcell.TD.eDecimal(EYFN)
	at com.jxcell.TD.eDate(EYFN)
	at com.jxcell.TD.I(EYFN)
	at com.jxcell.View.readXLSX(EYFN)

      It might cause instance crash depending on the load accessing this page.

      Example of reference into the spreadsheet file:

      ='file:///Documents and Settings/user/My Documents/file.xlsxD8x'#$Sheet1.$B$10

      Fix

      There is none yet.

      Workaround

      There is none yet.

              Assignee:
              Unassigned
              Reporter:
              Tiago Comasseto
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: