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 5.1.4.2, 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-5.0.4.2, 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-5.1.4.2 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 5.2.0.2 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 ***