{"id":731,"date":"2017-05-21T10:45:05","date_gmt":"2017-05-21T01:45:05","guid":{"rendered":"https:\/\/knowhow.hirohiro716.com\/?p=731"},"modified":"2024-05-06T21:51:46","modified_gmt":"2024-05-06T12:51:46","slug":"libreoffice-calc%e3%81%aestyle%e3%82%92%e5%a4%89%e6%9b%b4%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/weblog.hirohiro716.com\/?p=731","title":{"rendered":"LibreOffice\u306eCalc\u3067\u30da\u30fc\u30b8\u30b9\u30bf\u30a4\u30eb\u3092\u5909\u66f4\u3059\u308b"},"content":{"rendered":"<pre class=\"brush: vb; title: ; notranslate\" title=\"\">\r\nDim styleFamilies As Object\r\nstyleFamilies = ThisComponent.StyleFamilies\r\nDim styles As Object\r\nstyles = styleFamilies.getByName(&quot;PageStyles&quot;)\r\nDim style As Object\r\nstyle = styles.getByName(&quot;\u6a19\u6e96&quot;)\r\nstyle.HeaderIsOn = False '\u30d8\u30c3\u30c0\u30fcOFF\r\nstyle.FooterIsOn = False '\u30d5\u30c3\u30bf\u30fcOFF\r\nstyle.CenterHorizontally = True '\u6a2a\u65b9\u5411\u4e2d\u592e\u914d\u7f6e\r\nstyle.Height = 25000 '\u7528\u7d19\u9ad8\u3055250mm\r\nstyle.Width = 17600 '\u7528\u7d19\u5e45176mm\r\nstyle.scaleToPages = 1 '1\u30da\u30fc\u30b8\u306b\u53ce\u3081\u308b\r\n<\/pre>\n<h3>\u4e3b\u306a\u30d7\u30ed\u30d1\u30c6\u30a3<\/h3>\n<table>\n<tr>\n<th>\n      \u30d7\u30ed\u30d1\u30c6\u30a3\n    <\/th>\n<th>\n      \u578b\n    <\/th>\n<\/tr>\n<tr>\n<th>\n      CenterHorizontally\n    <\/th>\n<td>\n      boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      CenterVertically\n    <\/th>\n<td>\n      boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      PrintAnnotations\n    <\/th>\n<td>\n      boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      PrintGrid\n    <\/th>\n<td>\n      boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      PrintHeaders\n    <\/th>\n<td>\n      boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      PrintCharts\n    <\/th>\n<td>\n      boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      PrintObjects\n    <\/th>\n<td>\n      boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      PrintDrawing\n    <\/th>\n<td>\n      boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      PrintFormulas\n    <\/th>\n<td>\n      boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      PrintZeroValues\n    <\/th>\n<td>\n      boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      PrintDownFirst\n    <\/th>\n<td>\n      boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      LeftPageHeaderContent\n    <\/th>\n<td>\n      XHeaderFooterContent\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      LeftPageFooterContent\n    <\/th>\n<td>\n      XHeaderFooterContent\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      RightPageHeaderContent\n    <\/th>\n<td>\n      XHeaderFooterContent\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      RightPageFooterContent\n    <\/th>\n<td>\n      XHeaderFooterContent\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FirstPageNumber\n    <\/th>\n<td>\n      short\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      PageScale\n    <\/th>\n<td>\n      short\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      ScaleToPages\n    <\/th>\n<td>\n      short\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      ScaleToPagesX\n    <\/th>\n<td>\n      short\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      ScaleToPagesY\n    <\/th>\n<td>\n      short\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      BackColor\n    <\/th>\n<td>\n      ::com::sun::star::util::Color\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      BackGraphicURL\n    <\/th>\n<td>\n      string\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      BackGraphicFilter\n    <\/th>\n<td>\n      string\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      BackGraphicLocation\n    <\/th>\n<td>\n      GraphicLocation\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      BackTransparent\n    <\/th>\n<td>\n      boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      LeftMargin\n    <\/th>\n<td>\n      long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      RightMargin\n    <\/th>\n<td>\n      long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      TopMargin\n    <\/th>\n<td>\n      long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      BottomMargin\n    <\/th>\n<td>\n      long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      LeftBorder\n    <\/th>\n<td>\n      ::com::sun::star::table::BorderLine\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      RightBorder\n    <\/th>\n<td>\n      ::com::sun::star::table::BorderLine\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      TopBorder\n    <\/th>\n<td>\n      ::com::sun::star::table::BorderLine\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      BottomBorder\n    <\/th>\n<td>\n      ::com::sun::star::table::BorderLine\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      LeftBorderDistance\n    <\/th>\n<td>\n      long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      RightBorderDistance\n    <\/th>\n<td>\n      long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      TopBorderDistance\n    <\/th>\n<td>\n      long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      BottomBorderDistance\n    <\/th>\n<td>\n      long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      ShadowFormat\n    <\/th>\n<td>\n      ::com::sun::star::table::ShadowFormat\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      IsLandscape\n    <\/th>\n<td>\n      boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      NumberingType\n    <\/th>\n<td>\n      short\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      PageStyleLayout\n    <\/th>\n<td>\n      PageStyleLayout\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      PrinterPaperTray\n    <\/th>\n<td>\n      string\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      RegisterModeActive\n    <\/th>\n<td>\n      boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      RegisterParagraphStyle\n    <\/th>\n<td>\n      string\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      Size\n    <\/th>\n<td>\n      ::com::sun::star::awt::Size\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      Width\n    <\/th>\n<td>\n      long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      Height\n    <\/th>\n<td>\n      long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      TextColumns\n    <\/th>\n<td>\n      ::com::sun::star::text::XTextColumns\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      UserDefinedAttributes\n    <\/th>\n<td>\n      ::com::sun::star::container::XNameContainer\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderBackColor\n    <\/th>\n<td>\n      [ maybevoid ] ::com::sun::star::util::Color\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderBackGraphicURL\n    <\/th>\n<td>\n      [ maybevoid ] string\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderBackGraphicFilter\n    <\/th>\n<td>\n      [ maybevoid ] string\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderBackGraphicLocation\n    <\/th>\n<td>\n      [ maybevoid ] GraphicLocation\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderLeftMargin\n    <\/th>\n<td>\n      [ maybevoid ] long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderRightMargin\n    <\/th>\n<td>\n      [ maybevoid ] long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderBackTransparent\n    <\/th>\n<td>\n      [ maybevoid ] boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderLeftBorder\n    <\/th>\n<td>\n      [ maybevoid ] ::com::sun::star::table::BorderLine\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderRightBorder\n    <\/th>\n<td>\n      [ maybevoid ] ::com::sun::star::table::BorderLine\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderTopBorder\n    <\/th>\n<td>\n      [ maybevoid ] ::com::sun::star::table::BorderLine\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderBottomBorder\n    <\/th>\n<td>\n      [ maybevoid ] ::com::sun::star::table::BorderLine\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderLeftBorderDistance\n    <\/th>\n<td>\n      [ maybevoid ] long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderRightBorderDistance\n    <\/th>\n<td>\n      [ maybevoid ] long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderTopBorderDistance\n    <\/th>\n<td>\n      [ maybevoid ] long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderBottomBorderDistance\n    <\/th>\n<td>\n      [ maybevoid ] long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderShadowFormat\n    <\/th>\n<td>\n      [ maybevoid ] ::com::sun::star::table::ShadowFormat\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderBodyDistance\n    <\/th>\n<td>\n      [ maybevoid ] long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderIsShared\n    <\/th>\n<td>\n      [ maybevoid ] boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderHeight\n    <\/th>\n<td>\n      [ maybevoid ] long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderIsDynamicHeight\n    <\/th>\n<td>\n      [ maybevoid ] boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderIsOn\n    <\/th>\n<td>\n      boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderText\n    <\/th>\n<td>\n      [ maybevoid ] ::com::sun::star::text::XText\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderTextLeft\n    <\/th>\n<td>\n      [ maybevoid ] ::com::sun::star::text::XText\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderTextRight\n    <\/th>\n<td>\n      [ maybevoid ] ::com::sun::star::text::XText\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterBackColor\n    <\/th>\n<td>\n      [ maybevoid ] ::com::sun::star::util::Color\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterBackGraphicURL\n    <\/th>\n<td>\n      [ maybevoid ] string\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterBackGraphicFilter\n    <\/th>\n<td>\n      [ maybevoid ] string\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterBackGraphicLocation\n    <\/th>\n<td>\n      [ maybevoid ] GraphicLocation\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterLeftMargin\n    <\/th>\n<td>\n      [ maybevoid ] long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterRightMargin\n    <\/th>\n<td>\n      [ maybevoid ] long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterBackTransparent\n    <\/th>\n<td>\n      [ maybevoid ] boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterLeftBorder\n    <\/th>\n<td>\n      [ maybevoid ] ::com::sun::star::table::BorderLine\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterRightBorder\n    <\/th>\n<td>\n      [ maybevoid ] ::com::sun::star::table::BorderLine\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterTopBorder\n    <\/th>\n<td>\n      [ maybevoid ] ::com::sun::star::table::BorderLine\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterBottomBorder\n    <\/th>\n<td>\n      [ maybevoid ] ::com::sun::star::table::BorderLine\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterLeftBorderDistance\n    <\/th>\n<td>\n      [ maybevoid ] long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterRightBorderDistance\n    <\/th>\n<td>\n      [ maybevoid ] long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterTopBorderDistance\n    <\/th>\n<td>\n      [ maybevoid ] long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterBottomBorderDistance\n    <\/th>\n<td>\n      [ maybevoid ] long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterShadowFormat\n    <\/th>\n<td>\n      [ maybevoid ] ::com::sun::star::table::ShadowFormat\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterBodyDistance\n    <\/th>\n<td>\n      [ maybevoid ] long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterIsDynamicHeight\n    <\/th>\n<td>\n      [ maybevoid ] boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterIsShared\n    <\/th>\n<td>\n      [ maybevoid ] boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterHeight\n    <\/th>\n<td>\n      [ maybevoid ] long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterIsOn\n    <\/th>\n<td>\n      boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterText\n    <\/th>\n<td>\n      [ maybevoid ] ::com::sun::star::text::XText\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterTextLeft\n    <\/th>\n<td>\n      [ maybevoid ] ::com::sun::star::text::XText\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterTextRight\n    <\/th>\n<td>\n      [ maybevoid ] ::com::sun::star::text::XText\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FootnoteHeight\n    <\/th>\n<td>\n      long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FootnoteLineWeight\n    <\/th>\n<td>\n      short\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FootnoteLineColor\n    <\/th>\n<td>\n      ::com::sun::star::util::Color\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FootnoteLineRelativeWidth\n    <\/th>\n<td>\n      byte\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FootnoteLineAdjust\n    <\/th>\n<td>\n      short\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FootnoteLineTextDistance\n    <\/th>\n<td>\n      long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FootnoteLineDistance\n    <\/th>\n<td>\n      long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      WritingMode\n    <\/th>\n<td>\n      short\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      GridMode\n    <\/th>\n<td>\n      short\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      GridColor\n    <\/th>\n<td>\n      ::com::sun::star::util::Color\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      GridLines\n    <\/th>\n<td>\n      short\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      GridBaseHeight\n    <\/th>\n<td>\n      long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      GridRubyHeight\n    <\/th>\n<td>\n      long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      GridRubyBelow\n    <\/th>\n<td>\n      boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      GridPrint\n    <\/th>\n<td>\n      boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      GridDisplay\n    <\/th>\n<td>\n      boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderDynamicSpacing\n    <\/th>\n<td>\n      [ maybevoid ] boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterDynamicSpacing\n    <\/th>\n<td>\n      [ maybevoid ] boolean\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      BorderDistance\n    <\/th>\n<td>\n      long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      FooterBorderDistance\n    <\/th>\n<td>\n      [ maybevoid ] long\n    <\/td>\n<\/tr>\n<tr>\n<th>\n      HeaderBorderDistance\n    <\/th>\n<td>\n      [ maybevoid ] long\n    <\/td>\n<\/tr>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>Dim styleFamilies As Object styleFamilies = ThisComponent.StyleFamilies Dim styles As Object styles = styleFam [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[],"class_list":["post-731","post","type-post","status-publish","format-standard","hentry","category-libreoffice-calc"],"views":1575,"_links":{"self":[{"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=\/wp\/v2\/posts\/731","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=731"}],"version-history":[{"count":6,"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=\/wp\/v2\/posts\/731\/revisions"}],"predecessor-version":[{"id":2551,"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=\/wp\/v2\/posts\/731\/revisions\/2551"}],"wp:attachment":[{"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=731"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=731"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=731"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}