[Libreoffice-bugs] [Bug 132133] New: Can't protect only the format of a sheet

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=132133

            Bug ID: 132133
           Summary: Can't protect only the format of a sheet
           Product: LibreOffice
           Version: 6.3.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: crl at chrblee.net

I've designed a spreadsheet with particular cell borders, column heights &
widths, and font sizes. Nothing elaborate.

My students have to enter data by whatever means they wish, but without
altering the formatting; for the spreadsheet to be of any use, the appearance
of the data has to remain compliant with a particular pattern.

I can't find a way of protecting only the formatting of a sheet.

Paste-Special, and macros which I don't know how to write (in the absence of an
ecosystem to match VBA), are not solutions for 12-year olds.

Bug 88108 dating from 2015 is nearly a duplicate, but apparently there has been
no action on the necessary changes to the odf standard.

I've marked this report critical because it concerns one of the missing
features that are critical for a competitive position of LO in the educational
field.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200415/0d40f543/attachment.htm>