{"id":1741,"date":"2021-05-21T12:13:15","date_gmt":"2021-05-21T03:13:15","guid":{"rendered":"https:\/\/knowhow.hirohiro716.com\/?p=1741"},"modified":"2024-05-05T10:50:05","modified_gmt":"2024-05-05T01:50:05","slug":"libreoffice%e3%81%a7%e4%bb%96%e3%81%ae%e3%83%89%e3%82%ad%e3%83%a5%e3%83%a1%e3%83%b3%e3%83%88%e3%81%ae%e3%83%9e%e3%82%af%e3%83%adfunction%e3%82%92%e5%ae%9f%e8%a1%8c%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/weblog.hirohiro716.com\/?p=1741","title":{"rendered":"LibreOffice\u3067\u4ed6\u306e\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306e\u30de\u30af\u30ed(Function)\u3092\u5b9f\u884c\u3059\u308b"},"content":{"rendered":"<p>\nCalc\u3092\u4f7f\u7528\u3057\u3066\u300ctest.ods\u300d\u304b\u3089\u300c\u547c\u3073\u51fa\u3055\u308c\u308b\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8.ods\u300d\u306eFunction\u3092\u547c\u3073\u51fa\u3057\u3066\u7d50\u679c\u3092\u53d6\u5f97\u3059\u308b\u306e\u304c\u76ee\u7684\u3002Version: LibreOffice 6.4.7.2\n<\/p>\n<p style=\"margin-top:2em;\">\n\u547c\u3073\u51fa\u3055\u308c\u308b\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8.ods\u306eFunction\u306f\u4e0b\u8a18\u306e\u901a\u308a\u3002\n<\/p>\n<pre class=\"brush: vb; title: ; notranslate\" title=\"\">\r\nFunction Test(a, b)\r\n    Print a\r\n    b = &quot;test3&quot;\r\n    Test = 1\r\nEnd Function\r\n<\/pre>\n<p style=\"margin-top:2em;\">\ntest.ods\u304b\u3089\u547c\u3073\u51fa\u3057\u3066\u7d50\u679c\u3092\u53d6\u5f97\u3059\u308b\u3002\n<\/p>\n<pre class=\"brush: vb; title: ; notranslate\" title=\"\">\r\nDim document As Object\r\ndocument = StarDesktop.loadComponentFromURL(ConvertToUrl(&quot;\/home\/user\/Desktop\/\u547c\u3073\u51fa\u3055\u308c\u308b\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8.ods&quot;), &quot;_blank&quot;, 0, Array())\r\nDim scriptProvider As Object\r\nscriptProvider = document.getScriptProvider()\r\nDim url As String\r\nurl =&quot;vnd.sun.star.script:Standard.Module1.Test?language=Basic&amp;location=document&quot;\r\nDim script As Object\r\nscript = scriptProvider.getScript(url)\r\nDim args As Object\r\nargs = array(&quot;test1&quot;, &quot;test2&quot;)\r\nDim argsAfterFinishing As Object\r\nargsAfterFinishing = array()\r\n'test1\u30681\u304c\u8868\u793a\u3055\u308c\u308b\r\nPrint script.invoke(args, 0, argsAfterFinishing)\r\n'test2\u304c\u8868\u793a\u3055\u308c\u308b\r\nPrint args(1)\r\n'test3\u304c\u8868\u793a\u3055\u308c\u308b\r\nPrint argsAfterFinishing(1)\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Calc\u3092\u4f7f\u7528\u3057\u3066\u300ctest.ods\u300d\u304b\u3089\u300c\u547c\u3073\u51fa\u3055\u308c\u308b\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8.ods\u300d\u306eFunction\u3092\u547c\u3073\u51fa\u3057\u3066\u7d50\u679c\u3092\u53d6\u5f97\u3059\u308b\u306e\u304c\u76ee\u7684\u3002Version: LibreOffice 6.4.7.2 \u547c\u3073\u51fa\u3055\u308c\u308b\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8.od [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[],"class_list":["post-1741","post","type-post","status-publish","format-standard","hentry","category-libreoffice-calc"],"views":1387,"_links":{"self":[{"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=\/wp\/v2\/posts\/1741","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=1741"}],"version-history":[{"count":8,"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=\/wp\/v2\/posts\/1741\/revisions"}],"predecessor-version":[{"id":1749,"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=\/wp\/v2\/posts\/1741\/revisions\/1749"}],"wp:attachment":[{"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}