Created attachment 126114 [details]
file that demonstrates the bug
When a spreadsheet page containing multiple long formulas is accessed for
pagination, by either View->Page Break, Print Preview, or Print (whose
window contains a print preview thumbnail), the text on the page changes
from normal upper/lower format to all uppercase.
The text on the page is obtained by (short) formulae from other pages
which are not affected. Numeric data of the page is looked up by a pair
of complex formulae, which can be 60-100 characters in length, even
though the result is a small integer. There are several hundred
copies of each formula, one set per row of the page.
The problem occurs in both 5.1.3.(?) and 184.108.40.206, in both 32 bit and
64 bit versions. If the offending page is manually edited to remove
most (but not all) of the long formulae, leaving the corresponding cells
empty, then print preview and related commands render the text correctly.
The behavior occurs consistently and repeatably, and a change of +/- one
formula edited out will switch the behavior from correct to incorrect.
The behavior does not occur on other spreadsheets that I use, and does
not occur at all using LibreOffice-220.127.116.11, the only other version I
have on my machine.
The file was sent to the installation maintainer for LibreOffice at
slackbuilds.org, and he stated that on his machine the page came up in all
uppercase when the file was first opened. While we are both running
Slackware-14.2, it is unlikely that our machines are identical in all
respects, particularly installed fonts. My machine is running a new,
default Slackware installation, but LibreOffice is installed via sbopkg,
the standard method for 3rd party software. Unlike most sbopkg packages,
which recompile from source, the LibreOffice package installs from the standard
binary RPM package, so the running code is what was released by ODF.
The offending file - test2.ods - is included. The offending sheet is "alpha".
In order to ensure that the bug was not created by file contents inherited
from older versions of Calc (since this data has a long history), test2.ods
was recreated by manually copying the text and formulae out of the
pre-existing spreadsheet into pure ASCII text files which were examined
with "vi", then reinserted back into a spreadsheet newly created by
LibreOffice-18.104.22.168 using "Copy" and "Paste". So no trace of
old spreadsheet history is present in test2.ods except for the
text and formulae themselves! Simply open test2.ods from the command line,
noting that the "alpha" sheet is displayed. Click the print preview icon
on the toolbar and the error occurs.
This is a bug with Software Interpreter, already reported in bug 75387.
The fix is in 22.214.171.124 release candidate, but as a workaround in your current LibreOffice version please uncheck both checkboxes in 'Tools -> Options... -> LibreOffice -> OpenCL'.
*** This bug has been marked as a duplicate of bug 75387 ***