https://bugs.documentfoundation.org/show_bug.cgi?id=152879
Bug ID: 152879
Summary: Problems with the repeat rows / repeat columns
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: r.lehme...@freenet.de
Created attachment 184486
--> https://bugs.documentfoundation.org/attachment.cgi?id=184486&action=edit
Hier mal die Datei die Probleme macht. Sie enthält auch keine kritischen Daten.
Good day!
I'm trying to use the repeat rows / columns on a table ($a1:BA43) and I don't
get a display - as long as I don't work in landscape mode, then everything
works as it should.
If I work in portrait format, there are problems.
The table is in the fields $A1:$BA43. The top row is empty and contains the
text. The columns are 2.16 cm wide and it is DIN A4 with left and right margins
of 0.6 cm.
I have connected the fields $A1:$I1 and added a centred text.
I want to repeat this text on another page to be printed.
But either the text is not printed or only on the far right.
If I enter the following under "Format => Print areas => Edit" :
Repeat lines : $1
Repeat columns : $A
I only get the text on the first page and it is missing on the second page.
Repeat lines : $1
Repeat columns : $A :$I
If I get the text on every page, but the first 9 columns remain the same, only
the small visible part of the 10th column is displayed.
With each further click, a small part of the next column is displayed. So after
column J => K => L etc.
This applies to connected cells as well as to disconnected cells.
I have noticed this with versions 7.3.7.2 and 7.4.3.2.
My system is a Linux Manjaro on this maschine:
inxi -Fxxxzo
System:
Kernel: 5.10.161-1-MANJARO arch: x86_64 bits: 64 compiler: gcc v: 12.2.0
Desktop: Xfce v: 4.18.0 tk: Gtk v: 3.24.35 info: xfce4-panel wm: xfwm
v: 4.18.0 vt: 1 dm: LightDM v: 1.32.0 Distro: Manjaro Linux
base: Arch Linux
Machine:
Type: Desktop System: Dell product: OptiPlex 360 v: N/A
serial: <superuser required> Chassis: type: 6 serial: <superuser required>
Mobo: Dell model: 0T656F v: A01 serial: <superuser required> BIOS: Dell
v: A07 date: 06/18/2012
CPU:
Info: dual core model: Pentium E5200 bits: 64 type: MCP smt: <unsupported>
arch: Penryn rev: 6 cache: L1: 128 KiB L2: 2 MiB
Speed (MHz): avg: 2494 min/max: N/A cores: 1: 2494 2: 2494 bogomips: 9978
Flags: ht lm nx pae sse sse2 sse3 ssse3
Graphics:
Device-1: NVIDIA GT218 [GeForce 210] driver: nouveau v: kernel arch: Tesla
pcie: speed: 2.5 GT/s lanes: 16 ports: active: DVI-I-1 empty:
HDMI-A-1,VGA-1
bus-ID: 01:00.0 chip-ID: 10de:0a65 class-ID: 0300 temp: 41.0 C
Device-2: Microsoft LifeCam HD-5000 type: USB
driver: snd-usb-audio,uvcvideo bus-ID: 2-1:2 chip-ID: 045e:076d
class-ID: 0102
Display: x11 server: X.Org v: 21.1.6 compositor: xfwm v: 4.18.0 driver: X:
loaded: modesetting alternate: fbdev,vesa dri: nouveau gpu: nouveau
display-ID: :0 screens: 1
Screen-1: 0 s-res: 1680x1050 s-dpi: 96 s-size: 444x277mm (17.48x10.91")
s-diag: 523mm (20.6")
Monitor-1: DVI-I-1 model: LG (GoldStar) E2210 serial: <filter>
res: 1680x1050 hz: 60 dpi: 90 size: 474x296mm (18.66x11.65")
diag: 552mm (21.7") modes: max: 1680x1050 min: 720x400
API: OpenGL v: 3.3 Mesa 22.3.1 renderer: NVA8 direct render: Yes
Audio:
Device-1: Intel NM10/ICH7 Family High Definition Audio vendor: Dell
driver: snd_hda_intel bus-ID: 2-1:2 v: kernel bus-ID: 00:1b.0
chip-ID: 045e:076d class-ID: 0102 chip-ID: 8086:27d8 class-ID: 0403
Device-2: NVIDIA High Definition Audio driver: snd_hda_intel v: kernel
pcie: speed: 2.5 GT/s lanes: 16 bus-ID: 01:00.1 chip-ID: 10de:0be3
class-ID: 0403
Device-3: Microsoft LifeCam HD-5000 type: USB
driver: snd-usb-audio,uvcvideo
Sound API: ALSA v: k5.10.161-1-MANJARO running: yes
Sound Interface: sndio v: N/A running: no
Sound Server-1: PulseAudio v: 16.1 running: no
Sound Server-2: PipeWire v: 0.3.63 running: yes
Network:
Device-1: Broadcom NetLink BCM5784M Gigabit Ethernet PCIe vendor: Dell
driver: tg3 v: kernel pcie: speed: 2.5 GT/s lanes: 1 port: N/A
bus-ID: 02:00.0 chip-ID: 14e4:1698 class-ID: 0200
IF: enp2s0 state: down mac: <filter>
Device-2: Realtek RTL-8100/8101L/8139 PCI Fast Ethernet Adapter
driver: 8139too v: 0.9.28 port: cc00 bus-ID: 03:00.0 chip-ID: 10ec:8139
class-ID: 0200
IF: enp3s0 state: up speed: 100 Mbps duplex: full mac: <filter>
Drives:
Local Storage: total: 990.99 GiB used: 744.87 GiB (75.2%)
ID-1: /dev/sda vendor: Samsung model: SSD 860 QVO 1TB size: 931.51 GiB
speed: <unknown> type: SSD serial: <filter> rev: 2B6Q scheme: GPT
ID-2: /dev/sdd type: USB vendor: Generic model: MassStorageClass
size: 59.48 GiB type: N/A serial: <filter> rev: 1209 scheme: MBR
Partition:
ID-1: / size: 105.18 GiB used: 84.91 GiB (80.7%) fs: ext4 dev: /dev/sda2
ID-2: /boot size: 973.4 MiB used: 150.8 MiB (15.5%) fs: ext4
dev: /dev/sda1
ID-3: /home size: 779.45 GiB used: 657.13 GiB (84.3%) fs: ext4
dev: /dev/sda3
Swap:
ID-1: swap-1 type: partition size: 30.12 GiB used: 2.69 GiB (8.9%)
priority: -2 dev: /dev/sda4
Unmounted:
ID-1: /dev/sdd1 size: 59.48 GiB fs: ext4
Sensors:
System Temperatures: cpu: 52.0 C mobo: N/A gpu: nouveau temp: 41.0 C
Fan Speeds (RPM): N/A
Info:
Processes: 193 Uptime: 1h 14m wakeups: 0 Memory: 3.77 GiB
used: 3.06 GiB (81.2%) Init: systemd v: 252 default: graphical Compilers:
gcc: 12.2.0 clang: 14.0.6 Packages: 2437 pm: pacman pkgs: 2425 pm: flatpak
pkgs: 12 Shell: Bash v: 5.1.16 running-in: yakuake inxi: 3.3.24
Thanks in advance.
Sincerely R.Lehmeier
Translated with www.DeepL.com/Translator (free version)
--
You are receiving this mail because:
You are the assignee for the bug.
