Package org.apache.poi.hssf.record

Class NameRecord

    • Field Detail

      • BUILTIN_CONSOLIDATE_AREA

        public static final byte BUILTIN_CONSOLIDATE_AREA
        Included for completeness sake, not implemented
        See Also:
        Constant Field Values

      • BUILTIN_AUTO_OPEN

        public static final byte BUILTIN_AUTO_OPEN
        Included for completeness sake, not implemented
        See Also:
        Constant Field Values

      • BUILTIN_AUTO_CLOSE

        public static final byte BUILTIN_AUTO_CLOSE
        Included for completeness sake, not implemented
        See Also:
        Constant Field Values

      • BUILTIN_DATABASE

        public static final byte BUILTIN_DATABASE
        Included for completeness sake, not implemented
        See Also:
        Constant Field Values

      • BUILTIN_CRITERIA

        public static final byte BUILTIN_CRITERIA
        Included for completeness sake, not implemented
        See Also:
        Constant Field Values

      • BUILTIN_RECORDER

        public static final byte BUILTIN_RECORDER
        Included for completeness sake, not implemented
        See Also:
        Constant Field Values

      • BUILTIN_DATA_FORM

        public static final byte BUILTIN_DATA_FORM
        Included for completeness sake, not implemented
        See Also:
        Constant Field Values

      • BUILTIN_AUTO_ACTIVATE

        public static final byte BUILTIN_AUTO_ACTIVATE
        Included for completeness sake, not implemented
        See Also:
        Constant Field Values

      • BUILTIN_AUTO_DEACTIVATE

        public static final byte BUILTIN_AUTO_DEACTIVATE
        Included for completeness sake, not implemented
        See Also:
        Constant Field Values

      • BUILTIN_SHEET_TITLE

        public static final byte BUILTIN_SHEET_TITLE
        Included for completeness sake, not implemented
        See Also:
        Constant Field Values

    • Constructor Detail

      • NameRecord

        public NameRecord()
        Creates new NameRecord

      • NameRecord

        public NameRecord​(NameRecord other)

      • NameRecord

        public NameRecord​(byte builtin,
                  int sheetNumber)
        Constructor to create a built-in named region
        Parameters:
        builtin - Built-in byte representation for the name record, use the public constants
        sheetNumber - the sheet which the name applies to

      • NameRecord

        public NameRecord​(RecordInputStream ris)
        called by the constructor, should set class level fields. Should throw runtime exception for bad/icomplete data.
        Parameters:
        ris - the RecordInputstream to read the record from

    • Method Detail

      • setOptionFlag

        public void setOptionFlag​(short flag)
        sets the option flag for the named range
        Parameters:
        flag - option flag

      • setKeyboardShortcut

        public void setKeyboardShortcut​(byte shortcut)
        sets the keyboard shortcut
        Parameters:
        shortcut - keyboard shortcut

      • getSheetNumber

        public int getSheetNumber()
        For named ranges, and built-in names
        Returns:
        the 1-based sheet number.

      • getFnGroup

        public byte getFnGroup()
        Returns:
        function group
        See Also:
        FnGroupCountRecord

      • setSheetNumber

        public void setSheetNumber​(int value)

      • setNameText

        public void setNameText​(String name)
        sets the name of the named range
        Parameters:
        name - named range name

      • setCustomMenuText

        public void setCustomMenuText​(String text)
        sets the custom menu text
        Parameters:
        text - custom menu text

      • setDescriptionText

        public void setDescriptionText​(String text)
        sets the description text
        Parameters:
        text - the description text

      • setHelpTopicText

        public void setHelpTopicText​(String text)
        sets the help topic text
        Parameters:
        text - help topix text

      • setStatusBarText

        public void setStatusBarText​(String text)
        sets the status bar text
        Parameters:
        text - status bar text

      • getOptionFlag

        public short getOptionFlag()
        gets the option flag
        Returns:
        option flag

      • getKeyboardShortcut

        public byte getKeyboardShortcut()
        returns the keyboard shortcut
        Returns:
        keyboard shortcut

      • isHiddenName

        public boolean isHiddenName()
        Returns:
        true if name is hidden

      • setHidden

        public void setHidden​(boolean b)

      • isFunctionName

        public boolean isFunctionName()
        Returns:
        true if name is a function

      • setFunction

        public void setFunction​(boolean function)
        Indicates that the defined name refers to a user-defined function. This attribute is used when there is an add-in or other code project associated with the file.
        Parameters:
        function - true indicates the name refers to a function.

      • hasFormula

        public boolean hasFormula()
        Returns:
        true if name has a formula (named range or defined value)

      • isCommandName

        public boolean isCommandName()
        Returns:
        true if name is a command

      • isMacro

        public boolean isMacro()
        Returns:
        true if function macro or command macro

      • isComplexFunction

        public boolean isComplexFunction()
        Returns:
        true if array formula or user defined

      • isBuiltInName

        public boolean isBuiltInName()
        Convenience Function to determine if the name is a built-in name
        Returns:
        true, if the name is a built-in name

      • getNameText

        public String getNameText()
        gets the name
        Returns:
        name

      • getBuiltInName

        public byte getBuiltInName()
        Gets the Built In Name
        Returns:
        the built in Name

      • getNameDefinition

        public Ptg[] getNameDefinition()
        gets the definition, reference (Formula)
        Returns:
        the name formula. never null

      • setNameDefinition

        public void setNameDefinition​(Ptg[] ptgs)

      • getCustomMenuText

        public String getCustomMenuText()
        get the custom menu text
        Returns:
        custom menu text

      • getDescriptionText

        public String getDescriptionText()
        gets the description text
        Returns:
        description text

      • getHelpTopicText

        public String getHelpTopicText()
        get the help topic text
        Returns:
        gelp topic text

      • getStatusBarText

        public String getStatusBarText()
        gets the status bar text
        Returns:
        status bar text

      • getExternSheetNumber

        public int getExternSheetNumber()
        gets the extern sheet number
        Returns:
        extern sheet index

      • getSid

        public short getSid()
        return the non static version of the id for this record.
        Specified by:
        getSid in class Record
        Returns:
        he id for this record