- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
So, I just don't get it, and I can't find it.
The official documentation available to me shows both a simple method of creating a default border ("Set oBorder = oSheet.AddDefaultBorder()") and a more involved method (in "Public Sub InsertDefaultBorder()"). However, neither the Sheet.Border object, nor the DrawingDocument.BorderDefinitions object actually contain a DefaultBorder object anywhere; at least anywhere I can find. Sure, they have BorderDefinition objects, but those objects, to take just one example, do not have a BorderLabelModeEnum property, among several others. (To mention it again, see "Public Sub InsertDefaultBorder()" for more examples of DefaultBorder properties not in evidence in either Border or BorderDefinition objects.)
So, BorderDefinition <> DefaultBorder <> Border, and I cannot find any information about where the mythical BorderDefinition object ends up living, either in the DrawingDocument or in the drawing template files. Further, spelunking through the objects and properties available in those objects, there is nothing that appears to me to be (as it were) the object of my quest.
Further, while the twice-referenced standard InsertDefaultBorder sub shows a call that creates a default border, the last three properties referenced therein (BorderLineWidth, TextLabelHeight, and Font) are not properties of the DefaultBorder object, at least as far as my journey through any object defined as, shows me.
As well, calling the border.delete method on the "Default Border" appears to have no effect.
So what's the deal? How can one find the DefaultBorder object in a DrawingDocument (if that's where it lives), and when one finds that DefaultBorder object, where do the three apparently non-attached properties live?
Once I can find that object and the three associated properties, my assumption is that if nothing else, I can use the process shown in InsertDefaultBorder() (where I am getting the property values from the object I have found instead of hard-coding them), to re-define the "Default Border" object. Is that correct?
Solved! Go to Solution.