1
1

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

macOS+LibreOffice25に上げたらマクロの順番が壊れたのでLibreOffice24に戻した

1
Posted at

概要

macOS+LibreOffice25に上げたらマクロの順番が壊れたのでLibreOffice24に戻した

環境

macOS Tahoe 26.2
LibreOffice 25.8.4

やったこと

LibreOffice 24.8.7に戻した

壊れたファイルを修正

mkdir h
cp -p ./../hoshitori_2026.ods .
unzip hoshitori_2026.ods
rm -i hoshitori_2026.ods

grep -R "InsertEkaki" *

Basic/Standard/A05_InsertEkaki.xml:<script:module xmlns:script="http://openoffice.org/2000/script" script:name="A05_InsertEkaki" script:language="StarBasic" script:moduleType="normal">REM  *****  BASIC  *****
Basic/Standard/script-lb.xml: <library:element library:name="A05_InsertEkaki"/>
Binary file hoshitori_2026.ods matches
META-INF/manifest.xml: <manifest:file-entry manifest:full-path="Basic/Standard/A05_InsertEkaki.xml" manifest:media-type="text/xml"/>

Basic/Standard/script-lb.xmlにマクロの順番が記載されているので修正する

cd Basic/Standard 
vi script-lb.xml 

修正したxmlファイルの内容

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE library:library PUBLIC "-//OpenOffice.org//DTD OfficeDocument 1.0//EN" "library.dtd">
<library:library xmlns:library="http://openoffice.org/2000/library" library:name="Standard" library:readonly="false" library:passwordprotected="false">
 <library:element library:name="A01_InsertSleep"/>
 <library:element library:name="A01_InsertDeepSleep3Hour"/>
 <library:element library:name="A02_InsertWalk"/>
 <library:element library:name="A03_InsertRun"/>
 <library:element library:name="A04_InsertNippo"/>
 <library:element library:name="A05_InsertEkaki"/>
 <library:element library:name="CopySheet"/>
 <library:element library:name="CopyMonth"/>
 <library:element library:name="CopyCoure"/>
 <library:element library:name="DeleteSheet"/>
 <library:element library:name="InsertSheet"/>
</library:library>
cd ./../../
zip -r h.ods *
open h.ods

マクロの順番が壊れていないのを確認し、前に使っていたodsファイルのバックアップを取り置き変えた。

以上でLibreOffice25に上げたらマクロの順番が壊れたのを修正した。メモです。

1
1
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
1
1

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?