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: