Example #1
0
        public override string ToString()
        {
            string name = Name.Value;

            if (fBuiltin)
            {
                string builtinName = ExcelHelperClass.getNameStringfromBuiltInFunctionID(Name.Value);

                if (Name.Value.Length > 1)
                {
                    builtinName += new String(Name.Value.Skip(1).ToArray());
                }
                name = builtinName;
            }

            string labelString = string.Format(
                "Lbl (0x{0} bytes) - flags: 0x{1} | fBuiltin: {2} | fHidden: {3} | Name [unicode={4}]: {5}",
                Length.ToString("X"),
                Flags.ToString("X"),
                fBuiltin,
                fHidden,
                Name.fHighByte,
                name);

            if (rgce != null && rgce.Count > 0)
            {
                string labelRgceContent = "";

                switch (rgce.First())
                {
                //When we reference a different name
                case PtgName ptgName:
                    labelRgceContent = ptgName.ToString();
                    break;

                case PtgRef3d ptgRef3d:
                    labelRgceContent = ptgRef3d.ToString();
                    break;

                default:
                    labelRgceContent = PtgHelper.GetFormulaString(rgce);
                    break;
                }

                if (IsAutoOpenLabel())
                {
                    labelString += " !AUTO_OPEN!";
                }

                labelString += " | Formula: " + labelRgceContent;
            }

            return(labelString);
        }
Example #2
0
 public string ToFormulaString(bool showAttributes = false)
 {
     return(string.Format("Formula[{0}]", GetCellName()) + ": " + PtgHelper.GetFormulaString(ptgStack, showAttributes));
 }