public StringPtg(RecordInputStream in) 
{
           
        field_1_length = in.readUByte();
        field_2_options = in.readByte();
        if (fHighByte.isSet(field_2_options)) {
            field_3_string = in.readUnicodeLEString(field_1_length);
        } else {
            field_3_string = in.readCompressedUnicode(field_1_length);
        }
        // setValue(new String(data, offset+3, data[offset+1] + 256*data[offset+2]));
}

Create a StringPtg from a stream

 public StringPtg(String value) 
{
        if (value.length()  > 255) {
            throw new IllegalArgumentException(
                    "String literals in formulas can't be bigger than 255 characters ASCII");
        }
        field_2_options = (byte) fHighByte.setBoolean(0, StringUtil.hasMultibyte(value));
        field_3_string = value;
        field_1_length = value.length(); // for the moment, we support only ASCII strings in formulas we create
}

Create a StringPtg from a string representation of the number Number format is not checked, it is expected to be validated in the parser that calls this method.

Parameters:

value - : String representation of a floating point number

 public int getSize() 
{
        if (fHighByte.isSet(field_2_options)) {
            return 2 * field_1_length + 3;
        } else {
            return field_1_length + 3;
        }
}

 public String getValue() 
{
        return field_3_string;
}

 public String toFormulaString(HSSFWorkbook book) 
{
        String value = field_3_string;
        int len = value.length();
        StringBuffer sb = new StringBuffer(len + 4);
        sb.append(FORMULA_DELIMITER);
        for (int i = 0; i <  len; i++) {
            char c = value.charAt(i);
            if (c == FORMULA_DELIMITER) {
                sb.append(FORMULA_DELIMITER);
            }
            sb.append(c);
        }
        sb.append(FORMULA_DELIMITER);
        return sb.toString();
}

 public String toString() 
{
        StringBuffer sb = new StringBuffer(64);
        sb.append(getClass().getName()).append(" [");
        sb.append(field_3_string);
        sb.append("]");
        return sb.toString();
}

 public  void writeBytes(byte[] array,
    int offset) 
{
        array[offset + 0] = sid;
        array[offset + 1] = (byte) field_1_length;
        array[offset + 2] = field_2_options;
        if (fHighByte.isSet(field_2_options)) {
            StringUtil.putUnicodeLE(getValue(), array, offset + 3);
        } else {
            StringUtil.putCompressedUnicode(getValue(), array, offset + 3);
        }
}