I tried to use OLE copied from Calc to Writer, but I did not find any method to repeat rows from the calc’s OLE with Writer’s Page.
Is there any method to do this or maybe any alternative?
I do not know it (never tried it): can an OLE object overflow between the Writer pages?? Or where you want to apply the repeated rows?
Tip:
If you not need the (re-)calculation feature of the Calc document, but you need only the view of the once calculated result, then you can copy the Calc data into a Writer Table.
How do you copy? Or are you just pasting as formatted text?
I think that for the second page, you would need to copy and paste the OLE object. You would then need to hide the data rows that were visible in the first page so you can see the heading row(s) followed by the continuation rows not included in the first page. It would be tedious to do for many pages. Freeze pane does not work.
It might be worth considering if there is another way to achieve a finished document
Copied as ~“Libreoffice Calc Object”
how to link multiple OLE cell values?
I thought you wanted to repeat the heading rows on each sheet. Now you talk of linked cells and I don’t understand what it was that you want.
Please explain your goal and how embedding a spreadsheet achieves that