Beispiel #1
0
        public String ToStringRelative(Boolean includeSheet)
        {
            if (includeSheet)
            {
                return(String.Format("{0}!{1}:{2}",
                                     Worksheet.Name.WrapSheetNameInQuotesIfRequired(),
                                     _firstAddress.ToStringRelative(),
                                     _lastAddress.ToStringRelative()));
            }

            return(_firstAddress.ToStringRelative() + ":" + _lastAddress.ToStringRelative());
        }
Beispiel #2
0
        public String ToStringRelative(Boolean includeSheet)
        {
            if (includeSheet)
            {
                return(String.Format("'{0}'!{1}:{2}",
                                     Worksheet.Name,
                                     _firstAddress.ToStringRelative(),
                                     _lastAddress.ToStringRelative()));
            }

            return(_firstAddress.ToStringRelative() + ":" + _lastAddress.ToStringRelative());
        }
Beispiel #3
0
 public String ToStringRelative(Boolean includeSheet)
 {
     if (includeSheet)
     {
         return(String.Concat(
                    Worksheet.Name.EscapeSheetName(),
                    '!',
                    _firstAddress.ToStringRelative(),
                    ':',
                    _lastAddress.ToStringRelative()));
     }
     else
     {
         return(string.Concat(
                    _firstAddress.ToStringRelative(),
                    ":",
                    _lastAddress.ToStringRelative()));
     }
 }