Edit C:\Users\Admin\.m2\repository\org\apache\poi\poi\3.13\org\apache\poi\hssf\dev\FormulaViewer.class
???? 2 O ? G ? ? ? G ? ? ? ? ? ? ? ? ? ? ? ? ? ? G ? G ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? % ? ? % ? ? % ? % ? ? ? ? ? ? ? % ? ? ? ? ? ? ? G ? ? G ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? G ? G ? G ? G ? ? ? L ? ? file Ljava/lang/String; list Z <init> ()V Code LineNumberTable LocalVariableTable this 'Lorg/apache/poi/hssf/dev/FormulaViewer; run record #Lorg/apache/poi/hssf/record/Record; k I fs 2Lorg/apache/poi/poifs/filesystem/NPOIFSFileSystem; is Ljava/io/InputStream; records Ljava/util/List; LocalVariableTypeTable 5Ljava/util/List<Lorg/apache/poi/hssf/record/Record;>; StackMapTable ? ? ? ? ? Exceptions listFormula -(Lorg/apache/poi/hssf/record/FormulaRecord;)V numArg *Lorg/apache/poi/hssf/record/FormulaRecord; sep tokens $[Lorg/apache/poi/ss/formula/ptg/Ptg; token #Lorg/apache/poi/ss/formula/ptg/Ptg; numptgs buf Ljava/lang/StringBuffer; ? ? u ? ? parseFormulaRecord formulaString >(Lorg/apache/poi/hssf/record/FormulaRecord;)Ljava/lang/String; i composeFormula setFile (Ljava/lang/String;)V setList (Z)V main ([Ljava/lang/String;)V viewer e Ljava/lang/Exception; args [Ljava/lang/String; ? SourceFile FormulaViewer.java T U R S 0org/apache/poi/poifs/filesystem/NPOIFSFileSystem java/io/File P Q T ? T ? ? ? ? ? ? ? ? ? ? ? ? !org/apache/poi/hssf/record/Record ? ? (org/apache/poi/hssf/record/FormulaRecord o p ? p ? ? U ~ ? ? %org/apache/poi/ss/formula/ptg/FuncPtg ? ? ? java/lang/StringBuffer $org/apache/poi/ss/formula/ptg/ExpPtg *org/apache/poi/ss/formula/ptg/OperationPtg ? ? ? ? ? ? REF VALUE ARRAY ? ? ============================== java/lang/StringBuilder row = ? ? ? ? , col = ? value = ? xf = ? , number of ptgs = , options = ? RPN List = ? ? Formula text = ? ? (R) (V) (A) ? *org/apache/poi/hssf/usermodel/HSSFWorkbook ? --help ]FormulaViewer .8 proof that the devil lies in the details (or just in BIFF8 files in general) "usage: Give me a big fat file name --listFunctions %org/apache/poi/hssf/dev/FormulaViewer ? ? ? ? [ U java/lang/Exception Whoops! U java/lang/Object java/io/InputStream java/util/List java/lang/String !org/apache/poi/ss/formula/ptg/Ptg (Ljava/io/File;Z)V "org/apache/poi/hssf/dev/BiffViewer getPOIFSInputStream I(Lorg/apache/poi/poifs/filesystem/NPOIFSFileSystem;)Ljava/io/InputStream; (org/apache/poi/hssf/record/RecordFactory createRecords '(Ljava/io/InputStream;)Ljava/util/List; size ()I get (I)Ljava/lang/Object; getSid ()S close getParsedExpression &()[Lorg/apache/poi/ss/formula/ptg/Ptg; valueOf (I)Ljava/lang/String; toFormulaString ()Ljava/lang/String; append ,(Ljava/lang/String;)Ljava/lang/StringBuffer; getPtgClass ()B java/lang/System out Ljava/io/PrintStream; toString java/io/PrintStream println -(Ljava/lang/String;)Ljava/lang/StringBuilder; getRow (I)Ljava/lang/StringBuilder; print getColumn getValue ()D (D)Ljava/lang/StringBuilder; getXFIndex getOptions (C)Ljava/lang/StringBuffer; +org/apache/poi/hssf/model/HSSFFormulaParser d(Lorg/apache/poi/hssf/usermodel/HSSFWorkbook;[Lorg/apache/poi/ss/formula/ptg/Ptg;)Ljava/lang/String; equals (Ljava/lang/Object;)Z printStackTrace ! G O P Q R S T U V <