主页 / unix / 问题

问题[libreoffice](unix)

Martin Hope
user429323
Asked: 2023-11-11 08:00:40 +0800 CST
  • 5

我使用的是 LibreOffice v7.1。

我有一个句子必须以引文/脚注结尾。例如，以下句子有单词和脚注“1”。在某些情况下，我的句子有多个引用“1-4”。然而，当我互相插入/脚注几次时，我得到“1234”。

如何在 LibreOffice 中使其看起来像“1-4”？

libreoffice
Martin Hope
Ryan King Art
Asked: 2023-07-02 02:45:44 +0800 CST
  • 5

当我在Libre Office Calc 的列中创建数字值时，如果数字 0 位于数字的最末尾，则它会从视图中隐藏。我想查看所有数字，即使最后一个数字是 0。有什么办法可以做到这一点吗？谢谢！

例子：

  • 我希望它显示什么以及我输入的内容：16.80

  • 输入数字后显示：16.8

libreoffice
Martin Hope
Carter
Asked: 2022-06-30 00:06:53 +0800 CST
  • 0

我正在尝试在 CentOS 5 中安装 Libreoffice。不幸的是，我的系统与 Internet 是分开的。所以我不能使用 YUM 进行安装。

幸运的是我发现

https://downloadarchive.documentfoundation.org/libreoffice/old/3.3.4.1/rpm/x86_64/

你能指导我从哪里开始吗？我需要安装什么文件以及如何在 CentOS 5 中安装？

我只是按照https://vitux.com/how-to-install-libreoffice-on-centos-8/

但是在 yum clean 之后我收到了下面的错误信息

# yum localinstall *.rpm
Loaded plugins: fastestmirror, security
Setting up Local Package Process
Examining libobasis3.6-base-3.6.1.2-2.x86_64.rpm: libobasis3.6-base-3.6.1.2-2.x86_64
Marking libobasis3.6-base-3.6.1.2-2.x86_64.rpm to be installed
Loading mirror speeds from cached hostfile
http://vault.centos.org/5.11/os/x86_64/repodata/repomd.xml: [Errno 4] IOError: <urlopen error (-3, 'Temporary failure in name resolution')>
Trying other mirror.
Error: Cannot retrieve repository metadata (repomd.xml) for repository: base. Please verify its path and try again
[worker@localhost RPMS]#

当我检查 /etc/yum.repos.d

[worker@localhost yum.repos.d]# ll
total 4
-rwxr-xr-x 1 root root 1906 Jan  1  2018 CentOS-Base.repo

CentOS-Base.repo 如下所示

# CentOS-Base.repo
#
# The mirror system uses the connecting IP address of the client and the
# update status of each mirror to pick mirrors that are updated to and
# geographically close to the client.  You should use this for CentOS updates
# unless you are manually picking other mirrors.
#
# If the mirrorlist= does not work for you, as a fall back you can try the
# remarked out baseurl= line instead.
#
#
# http://vault.centos.org/?release=5&arch=i386&repo=os

[base]
name=CentOS-$releasever - Base
#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=os
baseurl=http://vault.centos.org/5.11/os/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5

#released updates
[updates]
name=CentOS-$releasever - Updates
#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=updates
baseurl=http://vault.centos.org/5.11/updates/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5

#additional packages that may be useful
[extras]
name=CentOS-$releasever - Extras
#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=extras
baseurl=http://vault.centos.org/5.11/extras/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5

#additional packages that extend functionality of existing packages

＃更新

在 * rpm -ivh .rpm之后 ，我得到了以下内容

[worker@localhost RPMS]# rpm -ivh *.rpm
Preparing...                ########################################### [100%]
   1:libreoffice3.6-ure     ########################################### [  2%]
   2:libobasis3.6-core01    ########################################### [  4%]
   3:libobasis3.6-core02    ########################################### [  6%]
   4:libobasis3.6-core03    ########################################### [  7%]
   5:libobasis3.6-core04    ########################################### [  9%]
   6:libobasis3.6-core05    ########################################### [ 11%]
   7:libobasis3.6-core06    ########################################### [ 13%]
   8:libobasis3.6-core07    ########################################### [ 15%]
   9:libobasis3.6-en-US     ########################################### [ 17%]
  10:libobasis3.6-base      ########################################### [ 19%]
  11:libobasis3.6-impress   ########################################### [ 20%]
  12:libobasis3.6-en-US-base########################################### [ 22%]
  13:libobasis3.6-en-US-calc########################################### [ 24%]
  14:libobasis3.6-en-US-math########################################### [ 26%]
  15:libobasis3.6-en-US-res ########################################### [ 28%]
  16:libobasis3.6-en-US-writ########################################### [ 30%]
  17:libobasis3.6-calc      ########################################### [ 31%]
  18:libobasis3.6-draw      ########################################### [ 33%]
  19:libobasis3.6-images    ########################################### [ 35%]
  20:libreoffice3.6         ########################################### [ 37%]
  21:libobasis3.6-math      ########################################### [ 39%]
  22:libobasis3.6-writer    ########################################### [ 41%]
  23:libobasis3.6-binfilter ########################################### [ 43%]
  24:libobasis3.6-extension-########################################### [ 44%]
  25:libobasis3.6-extension-########################################### [ 46%]
  26:libobasis3.6-extension-########################################### [ 48%]
  27:libobasis3.6-extension-########################################### [ 50%]
  28:libobasis3.6-extension-########################################### [ 52%]
  29:libobasis3.6-extension-########################################### [ 54%]
  30:libobasis3.6-extension-########################################### [ 56%]
  31:libobasis3.6-extension-########################################### [ 57%]
  32:libobasis3.6-extension-########################################### [ 59%]
  33:libobasis3.6-gnome-inte########################################### [ 61%]
  34:libobasis3.6-graphicfil########################################### [ 63%]
  35:libobasis3.6-javafilter########################################### [ 65%]
  36:libobasis3.6-kde-integr########################################### [ 67%]
  37:libobasis3.6-ogltrans  ########################################### [ 69%]
  38:libobasis3.6-onlineupda########################################### [ 70%]
  39:libobasis3.6-ooofonts  ########################################### [ 72%]
  40:libobasis3.6-ooolinguis########################################### [ 74%]
  41:libobasis3.6-postgresql########################################### [ 76%]
  42:libobasis3.6-pyuno     ########################################### [ 78%]
  43:libobasis3.6-xsltfilter########################################### [ 80%]
  44:libreoffice3.6-base    ########################################### [ 81%]
  45:libreoffice3.6-calc    ########################################### [ 83%]
  46:libreoffice3.6-dict-en ########################################### [ 85%]
  47:libreoffice3.6-dict-es ########################################### [ 87%]
  48:libreoffice3.6-dict-fr ########################################### [ 89%]
  49:libreoffice3.6-draw    ########################################### [ 91%]
  50:libreoffice3.6-en-US   ########################################### [ 93%]
  51:libreoffice3.6-impress ########################################### [ 94%]
  52:libreoffice3.6-math    ########################################### [ 96%]
  53:libreoffice3.6-stdlibs ########################################### [ 98%]
  54:libreoffice3.6-writer  ########################################### [100%]

但是100%之后就什么都没有了。如何启动 libreoffice？我还需要别的吗？

centos libreoffice
Martin Hope
Sadi
Asked: 2022-05-12 05:39:30 +0800 CST
  • 1

我通过文件管理器上下文菜单使用脚本将各种文档格式（例如 *.DOC）转换为 ODT 格式，如下所示：

for filename in "${@}"; do
    if [[ -f "${filename%.*}.odt" ]]
    then
        newfile="${filename%.*}_$(stat "$filename" | grep "Modify" | awk -F " " '{print $2}').odt"
        mv "${filename%.*}.odt" "${filename%.*}.tmp"
        libreoffice --headless --convert-to odt "$filename"
        mv "${filename%.*}.odt" "$newfile"
        touch "$newfile" -r "$filename"
        mv "${filename%.*}.odt.tmp" "${filename%.*}.odt"
        rm "$filename"
    else
        libreoffice --headless --convert-to odt "$filename"
        touch "${filename%.*}.odt" -r "$filename"
        rm "$filename"
    fi
done

不幸的是，如果文件受密码保护，这会导致删除文件而不进行转换。

这种情况下的终端输出是“错误：无法加载源文件”

我想（并希望）只需要更多的 shell 脚本技能来改进上面的非常基本的脚本，这样输入文件就不会被删除，而只是被跳过（可能还有错误消息或日志文件）。

shell-script libreoffice
Martin Hope
showkey
Asked: 2022-01-16 19:28:18 +0800 CST
  • 0

我已经安装了最新的 libre-office 版本 7.2 ，并编写了一个可填充的 odt 文件。
在 libre-office 中可以选择选项按钮，我已经上传了整个示例 odt 文件，您可以下载并尝试。

https://www.dropbox.com/s/3e5wy3l5k1r7mh5/mytest.odt?dl=0

将 odt 转换为可填写的 pdf，从 odt 上传转换后的 pdf。

在此处输入图像描述

https://www.dropbox.com/s/olwsohhyad0lsj7/mytest.pdf?dl=0

我不能用鼠标选择选项Travel by，Travel along但是可以用鼠标选择复选框I accept the terms and conditions，如何使所有选项都可以选择？请同时下载mytest.odt并mytest.pdf检查您的环境（debian11+libreoffice7.2）会发生什么？

pdf libreoffice
Martin Hope
Lonnie Best
Asked: 2021-12-01 03:39:31 +0800 CST
  • 1

如何在 Libre Office Calc 中更改电子表格网格的默认颜色？

我尝试过应用暗模式主题，但我尝试过的所有主题仍然使网格保持白色。

在此处输入图像描述

如果这在 Libre Calc 中根本不是一个选项，那么是否有另一个电子表格应用程序允许这样做？

libreoffice
Martin Hope
raratiru
Asked: 2021-10-20 04:17:12 +0800 CST
  • 0

我从头开始安装 Debian 11（它不是 Debian 10 升级）。

当我打开 Calc 并按任意一个键时，Libreoffice 会崩溃，并且在安全模式下也会发生这种情况。

我试图收集一些日志，但恐怕它们没有包含足够的信息。

更新

这是命令的结果 strace libreoffice 2>&1：：

https://pastebin.com/eipFqXvu

自由办公室：

Version: 7.0.4.2
Build ID: 00(Build:2)
CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: gtk3
Locale: en-US (en_US.utf8); UI: en-US
Debian package version: 1:7.0.4-4+deb11u1
Calc: threaded

unname -a

Linux flyer 5.10.0-9-amd64 #1 SMP Debian 5.10.70-1 (2021-09-30) x86_64 GNU/Linux

一些硬件信息

OptiPlex 790
Intel(R) Core(TM) i5-2400 CPU @ 3.10GHz
4GiB DIMM DDR3 Synchronous 1333 MHz (0.8 ns)
4GiB DIMM DDR3 Synchronous 1333 MHz (0.8 ns)

我发现的日志：

    # journalctl -e
    Oct 18 22:44:12 flyer soffice.bin[12165]: Negative content width -12 (allocation 1, extents 6x7) while allocating gadget (node button, owner GtkButton)
    Oct 18 22:44:12 flyer soffice.bin[12165]: Negative content width -12 (allocation 1, extents 6x7) while allocating gadget (node button, owner GtkButton)
    Oct 18 22:44:12 flyer soffice.bin[12165]: Negative content width -12 (allocation 1, extents 6x7) while allocating gadget (node button, owner GtkButton)
    Oct 18 22:44:12 flyer soffice.bin[12165]: Negative content width -12 (allocation 1, extents 6x7) while allocating gadget (node button, owner GtkButton)
    Oct 18 22:44:12 flyer soffice.bin[12165]: Negative content width -12 (allocation 1, extents 6x7) while allocating gadget (node button, owner GtkButton)
    Oct 18 22:44:30 flyer audit[12165]: AVC apparmor="ALLOWED" operation="open" profile="libreoffice-soffice" name="/usr/local/lib/libpython3.9.so.1.0" pid=12165 comm="soffice.bin" requested_mask="r" denied_mask="r>
    Oct 18 22:44:30 flyer audit[12165]: AVC apparmor="ALLOWED" operation="file_mmap" profile="libreoffice-soffice" name="/usr/local/lib/libpython3.9.so.1.0" pid=12165 comm="soffice.bin" requested_mask="rm" denied_m>
    Oct 18 22:44:30 flyer kernel: audit: type=1400 audit(1634586270.897:77): apparmor="ALLOWED" operation="open" profile="libreoffice-soffice" name="/usr/local/lib/libpython3.9.so.1.0" pid=12165 comm="soffice.bin" >
    Oct 18 22:44:30 flyer kernel: audit: type=1400 audit(1634586270.897:78): apparmor="ALLOWED" operation="file_mmap" profile="libreoffice-soffice" name="/usr/local/lib/libpython3.9.so.1.0" pid=12165 comm="soffice.>
    Oct 18 22:44:30 flyer audit[12165]: AVC apparmor="ALLOWED" operation="open" profile="libreoffice-soffice" name="/home/flyer/.local/lib/python3.9/site-packages/distutils-precedence.pth" pid=12165 comm="soffice.b>
    Oct 18 22:44:30 flyer kernel: audit: type=1400 audit(1634586270.913:79): apparmor="ALLOWED" operation="open" profile="libreoffice-soffice" name="/home/flyer/.local/lib/python3.9/site-packages/distutils-preceden>
    Oct 18 22:45:01 flyer CRON[12280]: pam_unix(cron:session): session opened for user root(uid=0) by (uid=0)
    Oct 18 22:45:01 flyer CRON[12281]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    Oct 18 22:45:01 flyer CRON[12280]: pam_unix(cron:session): session closed for user root
    Oct 18 22:48:27 flyer gnome-shell[2713]: libinput error: event4  - Logitech USB Keyboard: client bug: event processing lagging behind by 25ms, your system is too slow
    Oct 18 22:50:43 flyer systemd[1]: Starting system activity accounting tool...
    Oct 18 22:50:43 flyer systemd[1]: sysstat-collect.service: Succeeded.
    Oct 18 22:50:43 flyer systemd[1]: Finished system activity accounting tool.
    Oct 18 22:50:54 flyer gnome-shell[2713]: libinput error: event3  - Logitech USB-PS/2 Optical Mouse: client bug: event processing lagging behind by 13ms, your system is too slow
    Oct 18 22:50:59 flyer systemd[2539]: Started Application launched by gnome-shell.
    Oct 18 22:51:00 flyer rtkit-daemon[963]: Supervising 6 threads of 3 processes of 1 users.
    Oct 18 22:51:00 flyer rtkit-daemon[963]: Supervising 6 threads of 3 processes of 1 users.
    Oct 18 22:51:00 flyer rtkit-daemon[963]: Supervising 6 threads of 3 processes of 1 users.
    Oct 18 22:51:00 flyer rtkit-daemon[963]: Supervising 6 threads of 3 processes of 1 users.
    Oct 18 22:51:00 flyer rtkit-daemon[963]: Successfully made thread 12513 of process 12442 owned by '1000' RT at priority 10.
    Oct 18 22:51:00 flyer rtkit-daemon[963]: Supervising 7 threads of 4 processes of 1 users.
    Oct 18 22:51:00 flyer rtkit-daemon[963]: Supervising 7 threads of 4 processes of 1 users.
    Oct 18 22:51:00 flyer rtkit-daemon[963]: Supervising 7 threads of 4 processes of 1 users.
    Oct 18 22:51:01 flyer rtkit-daemon[963]: Supervising 7 threads of 4 processes of 1 users.
    Oct 18 22:51:01 flyer rtkit-daemon[963]: Supervising 7 threads of 4 processes of 1 users.
    Oct 18 22:51:02 flyer rtkit-daemon[963]: Supervising 7 threads of 4 processes of 1 users.
    Oct 18 22:51:02 flyer rtkit-daemon[963]: Supervising 7 threads of 4 processes of 1 users.
    Oct 18 22:51:03 flyer rtkit-daemon[963]: Supervising 7 threads of 4 processes of 1 users.
    Oct 18 22:51:03 flyer rtkit-daemon[963]: Supervising 7 threads of 4 processes of 1 users.
    Oct 18 22:51:03 flyer systemd[2539]: app-gnome-firefox\x2desr-4679.scope: Succeeded.
    Oct 18 22:51:03 flyer systemd[2539]: app-gnome-firefox\x2desr-4679.scope: Consumed 50min 25.087s CPU time.
    Oct 18 22:51:59 flyer systemd[2539]: Started Application launched by gnome-shell.
    Oct 18 22:51:59 flyer libreoffice-calc.desktop[12680]: Warning: failed to read path from javaldx
    Oct 18 22:52:00 flyer gnome-shell[2713]: libinput error: event3  - Logitech USB-PS/2 Optical Mouse: client bug: event processing lagging behind by 22ms, your system is too slow
    Oct 18 22:52:01 flyer systemd[2539]: app-gnome-libreoffice\x2dcalc-12680.scope: Succeeded.
    Oct 18 22:52:01 flyer systemd[2539]: app-gnome-libreoffice\x2dcalc-12680.scope: Consumed 1.412s CPU time.
    Oct 18 22:52:18 flyer audit[12226]: AVC apparmor="ALLOWED" operation="open" profile="libreoffice-soffice" name="/usr/local/lib/libpython3.9.so.1.0" pid=12226 comm="soffice.bin" requested_mask="r" denied_mask="r>
    Oct 18 22:52:18 flyer audit[12226]: AVC apparmor="ALLOWED" operation="file_mmap" profile="libreoffice-soffice" name="/usr/local/lib/libpython3.9.so.1.0" pid=12226 comm="soffice.bin" requested_mask="rm" denied_m>
    Oct 18 22:52:18 flyer kernel: audit: type=1400 audit(1634586738.092:80): apparmor="ALLOWED" operation="open" profile="libreoffice-soffice" name="/usr/local/lib/libpython3.9.so.1.0" pid=12226 comm="soffice.bin" >
    Oct 18 22:52:18 flyer kernel: audit: type=1400 audit(1634586738.092:81): apparmor="ALLOWED" operation="file_mmap" profile="libreoffice-soffice" name="/usr/local/lib/libpython3.9.so.1.0" pid=12226 comm="soffice.>
    Oct 18 22:52:18 flyer audit[12226]: AVC apparmor="ALLOWED" operation="open" profile="libreoffice-soffice" name="/home/flyer/.local/lib/python3.9/site-packages/distutils-precedence.pth" pid=12226 comm="soffice.b>
    Oct 18 22:52:18 flyer kernel: audit: type=1400 audit(1634586738.112:82): apparmor="ALLOWED" operation="open" profile="libreoffice-soffice" name="/home/flyer/.local/lib/python3.9/site-packages/distutils-preceden>
debian libreoffice