{"id":1207,"date":"2025-09-04T17:25:02","date_gmt":"2025-09-04T08:25:02","guid":{"rendered":"https:\/\/txn.myds.me\/blog\/?p=1207"},"modified":"2025-09-04T17:25:02","modified_gmt":"2025-09-04T08:25:02","slug":"libreoffice-calc-%e3%81%a7%e6%97%a5%e4%bb%98%e3%81%8c%e7%af%84%e5%9b%b2%e5%a4%96%e3%81%ae%e8%a1%8c%e3%82%92%e3%82%a8%e3%83%a9%e3%83%bc%e8%a1%a8%e7%a4%ba%e3%81%97%e3%81%9f%e3%81%84%e3%80%82","status":"publish","type":"post","link":"https:\/\/blog.txn.red\/?p=1207","title":{"rendered":"LibreOffice Calc \u3067\u65e5\u4ed8\u304c\u7bc4\u56f2\u5916\u306e\u884c\u3092\u30a8\u30e9\u30fc\u8868\u793a\u3057\u305f\u3044\u3002"},"content":{"rendered":"\n

Calc \u306b\u9650\u3089\u305a Excel \u3067\u3082\u307b\u3068\u3093\u3069\u540c\u3058\u3060\u304c\u3001\u884c\u306b\u5bfe\u3057\u3066\u6761\u4ef6\u66f8\u5f0f\u3092\u8a2d\u5b9a\u3059\u308b\u65b9\u6cd5\u3067\u3059\u3002
\u3053\u308c\u3082\u6570\u30f6\u6708\u306b \uff11 \u5ea6\u304f\u3089\u3044\u306e\u983b\u5ea6\u3067\u3084\u308b\u306e\u3067\u3059\u304c\u6bce\u56de\u5fd8\u308c\u308b\u306e\u3067 <\/p>\n\n\n\n

\u4e0b\u306e\u8868\u3067\u306f\u3001\u4f5c\u6210\u65e5\u306e\u6708\u3068\u65e5\u4ed8\u5217\u306e\u6708\u304c\u540c\u3058\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002
\u307e\u305f\u3001A\u5217: \u65e5\u4ed8\u304c\u7a7a\u306e\u5834\u5408\u306f\u30a8\u30e9\u30fc\u8868\u793a\u3057\u306a\u3044\u3088\u3046\u306b\u3057\u305f\u3044\u3002 <\/p>\n\n\n\n

A\u5217<\/th>B\u5217<\/th>C\u5217<\/th><\/tr><\/thead>
<\/td>\u4f5c\u6210\u65e5<\/td>2025\/8\/30<\/td><\/tr>
\u65e5\u4ed8<\/td>\u9805\u76ee<\/td>\u91d1\u984d<\/td><\/tr>
2025\/8\/2<\/td>\u66f8\u7c4d\u8cfc\u5165<\/td>880<\/td><\/tr>
2025\/9\/10<\/td>\u4ea4\u901a\u8cbb<\/td>1000<\/td><\/tr>
<\/td>(\u51fa\u5f35\u5148: xxxxx)<\/td><\/td><\/tr>
<\/td>\u5c0f\u8a08<\/td>1880<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

\u3059\u3079\u3066\u306e\u6761\u4ef6\u3092\u5206\u89e3\u3057\u3066\u307f\u308b\u3068\u3053\u3046\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n

    \n
  • \u7bc4\u56f2: A3 \u304b\u3089 C5 \u306e\u7bc4\u56f2\u306b\u30a8\u30e9\u30fc\u8868\u793a\u3092\u51fa\u3059
    \u3064\u307e\u308a\u30bb\u30eb\u306e\u7bc4\u56f2\u3092\u6307\u5b9a\u3059\u308b\u3068\u884c\u8868\u793a\u3067\u304d\u308b<\/strong>\u3002<\/li>\n\n\n\n
  • A3\u3001A4\u3001A5 \u306f C3 \u306e\u65e5\u4ed8\u3068\u540c\u3058\u6708\u3067\u3042\u308b\u5fc5\u8981\u304c\u3042\u308b\u3002<\/li>\n\n\n\n
  • \u3055\u3089\u306b\u3001A3\u3001A4\u3001A5 \u304c\u7a7a\u767d\u306e\u3068\u304d\u306f\u6761\u4ef6\u66f8\u5f0f\u304b\u3089\u9664\u5916\u3059\u308b\u3002<\/li>\n<\/ul>\n\n\n\n

    \u6761\u4ef6\u66f8\u5f0f\u306f\u3001\u6761\u4ef6\u304c\u6e80\u305f\u3055\u308c\u3068\u304d\u306b\u6307\u5b9a\u306e\u66f8\u5f0f\u3092\u8868\u793a\u3059\u308b\u3082\u306e\u306a\u306e\u3067\u3001\u4eca\u56de\u306e\u4f8b\u3067\u306f\u4e0a\u3092\u6e80\u305f\u3055\u306a\u3044\u72b6\u614b\u3092\u5f0f\u306b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u305d\u308c\u306f\u3053\u3046\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n

    $A3<> “” (\u7a7a\u767d\u3067\u306a\u3044)<\/p>\n\n\n\n

    MONTH($C1) <> MONTH($A3) (\u6708\u304c\u540c\u3058\u3058\u3083\u306a\u3044 > \u7570\u306a\u308b)<\/p>\n\n\n\n

    \u3055\u3089\u306b\u3053\u308c\u3089\u3092\u540c\u6642\u306b\u6e80\u305f\u3059\u5fc5\u8981\u304c\u3042\u308b\u306e\u3067 AND() \u95a2\u6570\u30672\u3064\u3092\u7d50\u3073\u3064\u3051\u307e\u3059\u3002<\/p>\n\n\n\n

    \u3053\u3053\u307e\u3067\u6574\u7406\u3067\u304d\u305f\u3089<\/p>\n\n\n\n

    LibreOffice Calc \u306e\u5834\u5408\uff1a<\/p>\n\n\n\n

    \u30e1\u30cb\u30e5\u30fc\u304b\u3089Format > Conditional > Manage..
    (\u624b\u5143\u306e LibreOffice \u306f\u65e5\u672c\u8a9e\u5316\u3057\u3066\u3044\u306a\u304b\u3063\u305f\u306e\u3067\u3001\u9069\u5f53\u306b\u8aad\u307f\u66ff\u3048\u3066\u307b\u3057\u3044\u3002\u591a\u5206\u3001\u66f8\u5f0f > \u6761\u4ef6\u66f8\u5f0f > \u7ba1\u7406 \u304f\u3089\u3044\u306e\u611f\u3058\u3060\u3068\u601d\u3046)<\/p>\n\n\n\n

    \u3067\u3066\u304d\u305f Conditinal Formatting \u306e\u30c0\u30a4\u30a2\u30ed\u30b0\u306b\u4ee5\u4e0b\u306e\u8981\u9818\u3067\u6307\u5b9a\u3059\u308b\u3002<\/p>\n\n\n\n

    Fomula is: AND($A3<>””, MONTH($C1) <> MONTH($A3))
    Apply Style: \u9069\u5f53\u306b Bad \u3068\u304b Warning \u3068\u304b\u597d\u304d\u306a\u306e\u3092\u9078\u3076<\/p>\n\n\n\n

    Cell Range, Range: A1:C5<\/p>\n\n\n\n

    \u30dd\u30a4\u30f3\u30c8\u306f\u3001<\/p>\n\n\n\n

      \n
    • \u8868\u793a\u3057\u305f\u3044\u6761\u4ef6\u306e\u6642\u306b\u771f\u306b\u306a\u308b\u5f0f\u3092\u8a2d\u5b9a\u3059\u308b<\/li>\n\n\n\n
    • \u884c\u8868\u793a\uff08\u7bc4\u56f2\u306b\u540c\u3058\u66f8\u5f0f\uff09\u306b\u3057\u305f\u3044\u3068\u304d\u306f\u3001cell range \u3092\u8a2d\u5b9a\u3059\u308b\u3002<\/li>\n<\/ul>\n\n\n\n

      \u3053\u308c\u3067\u5fd8\u308c\u305a\u306b\u6e08\u3080\u304b\u3082\u3057\u308c\u306a\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

      Calc \u306b\u9650\u3089\u305a Excel \u3067\u3082\u307b\u3068\u3093\u3069\u540c\u3058\u3060\u304c\u3001\u884c\u306b\u5bfe\u3057\u3066\u6761\u4ef6\u66f8\u5f0f\u3092\u8a2d\u5b9a\u3059\u308b\u65b9\u6cd5\u3067\u3059\u3002\u3053\u308c\u3082\u6570\u30f6\u6708\u306b \uff11 \u5ea6\u304f\u3089\u3044\u306e\u983b\u5ea6\u3067\u3084\u308b\u306e\u3067\u3059\u304c\u6bce\u56de\u5fd8\u308c\u308b\u306e\u3067 \u4e0b\u306e\u8868\u3067\u306f\u3001\u4f5c\u6210\u65e5\u306e\u6708\u3068\u65e5\u4ed8\u5217\u306e\u6708\u304c\u540c\u3058\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u307e\u305f\u3001A […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":3,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-1207","post","type-post","status-publish","format-standard","hentry","category-it"],"_links":{"self":[{"href":"https:\/\/blog.txn.red\/index.php?rest_route=\/wp\/v2\/posts\/1207","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.txn.red\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.txn.red\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.txn.red\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.txn.red\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1207"}],"version-history":[{"count":0,"href":"https:\/\/blog.txn.red\/index.php?rest_route=\/wp\/v2\/posts\/1207\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.txn.red\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1207"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.txn.red\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1207"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.txn.red\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}