Small template inside of sheet

Hi together,

we are using a calc-Document for our test reports in our factory.
Its a small table fitting on a single paper with 32 columns where the tester can put in target and actual measurments.
Most of the time this 32 columns are enough, but sometimes not.
We currently just copy the sheet inside the workbook and name it manually to site 1 and site 2 (and so on for more sheets)
What i’ve seen a while ago was a way to restrict the sheet to what is visible on 1 page of paper and when you fill in all 32 columns (or click on the columns below) you create a copy of the first page right under it in the same sheet.
Is this possible within Calc or do i need macros for such behaviour.

The help on this page is mostly provided by users like you.
An important aspect is the correct specification of the tags.
Choose at least one of the valid tags that match your situation: Writer, Calc, Draw, Impress, Math, Base or Common.
Your question and its description should be as detailed as possible.
When writing your question and description, please keep in mind that no one can look over your shoulder.
Basically you have to specify the operating system and the LibreOffice version (three digits, e.g. 7.3.2).
Furthermore, specify the file type in which you saved.
All important information about your question should be present in the question box, otherwise edit and complete it.
Do not use comments for this.
If you have already fulfilled some of these requirements, so much the better.
If you have not yet received a response, ask yourself the question, how do I make my description interesting enough for other users to want to respond?

You may want to upload a reduced and anonymized file here.

Here you can find the further regulations for this page:

1 Like

Maybe, what you saw was a database which might be a better match for collecting data.