Created attachment 184486 [details] 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)
Kleiner Nachtrag: Das es im Querdruck klappt habe ich mit der Tabelle "Konfirmation" ausprobiert.
In windows, you can't run directly soffice.bin it is not an executable for the system. You must run soffice.exe or soffice.com. https://mikekaganski.wordpress.com/2018/11/21/proper-console-mode-for-libreoffice-on-windows/
Sorry, please forget the comment, it was for other thread.
Created attachment 184491 [details] Modified sample file If you select Repeat columns : $A :$I, they are repeated on every page, and there is no space for the other data. If you set up the first column with what you need to be on every page it works fine and more columns are allowed on the same page. But seems there are not columns to repeat, so set up the rows to repeat and put the page breaks by hand, easily with Menu/View/Page break, as in the attached sample. BTW and strange way to put that data, IMO every year should be one column, even if for print, you cannot have all the data of one year in the same page, but looks that the relevant it's having the last number of every year.
What you write is correct. However, it also does not work if I insert $1 in the repeat rows and $A in the repeat columns. Because then only the field A1 (which contains the text for the connected cells) should be repeated. In the cross-printing, with the confirmations, there are no problems. And this should also not occur if I enter $1 as the repeating columns$A:$I and $1 as the repeating rows. Then only the cells $A1:I1 should be repeated and not whole columns, here the error seems to have crept in that the repeat rows are not taken into account in portrait format, while it is the case in landscape format. Also, the result seems to be influenced by whether I join the cells concerned or not. P.S. The modified file with the pages formatted by hand and provided with a heading is certainly also a solution to the problem - even if not the desired one.
Isn't the problem that the cell is actually a merged cell? So $1 and $A, are perhaps not enough?
The problem is a misunderstanding of the feature. What you actually want is: Format > Print Ranges > Edit > everything should be blank, empty, no rows nor column to repeat, and the first item should have "entire sheet" selected. Then OK. Then go to: Format > Page Style > Header > Header on (Yes) Format > Page Style > Header > Same content on left and right pages (Yes) Format > Page Style > Header > Same content on first page (No, because you already have "Taufe" there. Alternatively, remove "Taufe" from A1:I1 and set this one to "Yes") You can make additional adjustments here. Now close the Page Style window (OK). Now go to: Insert > Headers and Footers and arrange whatever you want to be in the header (of every page), and then OK. Now go to Print Preview. You might need to arrange some size and/or distance, but the header will be repeated in every page in portrait printing. I am leaving this opened, but as soon as the OP confirms that it is OK, this should be "not a bug".
(In reply to ady from comment #7) > I am leaving this opened, but as soon as the OP confirms that it is OK, this > should be "not a bug". Lehmeier: waiting for your OK.
We have had no more responses since the 5th of January of Lehmeier. Perhaps, we can close this bug all the same?
(In reply to Sophie Sipasseuth from comment #9) > We have had no more responses since the 5th of January of Lehmeier. > Perhaps, we can close this bug all the same? Well, it can be closed, but reports in needinfo will automatically close in 7 months :)