Nick, Ah fun bug, it's in the workbook:
As I don't know how to correctly elide the format, I'll send you the long text. It seems to be a defined name, perhaps some type of print area? Thanks, Brian <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"; xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"; xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"; mc:Ignorable="x15" xmlns:x15=" http://schemas.microsoft.com/office/spreadsheetml/2010/11/main";> <fileVersion appName="xl" lastEdited="6" lowestEdited="4" rupBuild="14420"/> <workbookPr defaultThemeVersion="124226"/> <mc:AlternateContent xmlns:mc=" http://schemas.openxmlformats.org/markup-compatibility/2006";> <mc:Choice Requires="x15"> <x15ac:absPath url="C:\Users\Enrique Beltran\Documents\alpopular\Content\Content S1\Excel\" xmlns:x15ac=" http://schemas.microsoft.com/office/spreadsheetml/2010/11/ac"/> </mc:Choice> </mc:AlternateContent> <bookViews> <workbookView xWindow="0" yWindow="0" windowWidth="20490" windowHeight="7755" tabRatio="917" activeTab="8"/> </bookViews> <sheets> <sheet name="105000" sheetId="151" r:id="rId1"/> <sheet name="110000" sheetId="152" r:id="rId2"/> <sheet name="220000" sheetId="154" r:id="rId3"/> <sheet name="320000" sheetId="156" r:id="rId4"/> <sheet name="410000" sheetId="161" r:id="rId5"/> <sheet name="510000" sheetId="188" r:id="rId6"/> <sheet name="520000" sheetId="187" r:id="rId7"/> <sheet name="610000" sheetId="160" r:id="rId8"/> <sheet name="610000a" sheetId="189" r:id="rId9"/> <sheet name="810000" sheetId="186" r:id="rId10"/> <sheet name="813000" sheetId="61" r:id="rId11"/> <sheet name="819100" sheetId="185" r:id="rId12"/> </sheets> <externalReferences> <externalReference r:id="rId13"/> </externalReferences> <definedNames> <definedName name="_xlnm._FilterDatabase" localSheetId="7" hidden="1">'610000'!$A$10:$DF$27</definedName> <definedName name="_xlnm.Print_Area" localSheetId="0">'105000'!$A$1:$C$8</definedName> <definedName name="_xlnm.Print_Area" localSheetId="1">'110000'!$A$1:$C$20</definedName> <definedName name="_xlnm.Print_Area" localSheetId="2">'220000'!$A$1:$C$52</definedName> <definedName name="_xlnm.Print_Area" localSheetId="3">'320000'!$A$1:$C$41</definedName> <definedName name="_xlnm.Print_Area" localSheetId="4">'410000'!$A$1:$F$36</definedName> <definedName name="_xlnm.Print_Area" localSheetId="5">'510000'!$A$1:$C$77</definedName> <definedName name="_xlnm.Print_Area" localSheetId="6">'520000'!$A$1:$C$83</definedName> <definedName name="_xlnm.Print_Area" localSheetId="7">'610000'!$A$1:$DF$27</definedName> <definedName name="_xlnm.Print_Area" localSheetId="9">'810000'!$A$1:$H$90</definedName> <definedName name="_xlnm.Print_Area" localSheetId="11">'819100'!#REF!</definedName> <definedName name="lsTipoEntidad">[1]!tblTipoEntidad[Llave]</definedName> </definedNames> <calcPr calcId="152511"/> </workbook> On Thu, Dec 3, 2015 at 1:57 PM, Nick Burch <[email protected]> wrote: > On Thu, 3 Dec 2015, Brian Milnes wrote: > >> I have a strange bug that I can't quite grasp. >> >> org.apache.poi.ss.formula.FormulaParseException: Unused input [[llave]] >> after attempting to parse the formula [[1]!tbltipoentidad[llave]] >> > > Do you know what the formula is supposed to mean, and what Excel evaluates > it as? > > I could not find the string involved with searching or dumping >> strings/formulas using POI until I rewrote the sheet as a FOPS >> and it is here in the XML. >> > > Probably the best way to find it without changing things is to save as > .xlsx (if not already), rename to .zip, unzip, and check the sheet xml files > > Nick > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > -- Brian Milnes CIO XBRL Cloud 206 406 7576
