Bug 100803 - iPrint Preview changes text data to all upper case for a specific file.
Summary: iPrint Preview changes text data to all upper case for a specific file.
Status: RESOLVED DUPLICATE of bug 75387
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.3.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-07-08 02:02 UTC by schmidtrod
Modified: 2016-07-08 02:59 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
file that demonstrates the bug (56.08 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-07-08 02:02 UTC, schmidtrod
Details

Note You need to log in before you can comment on or make changes to this bug.
Description schmidtrod 2016-07-08 02:02:49 UTC
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.
Comment 1 Aron Budea 2016-07-08 02:59:12 UTC
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 ***