Bug 74513 - Underlined Words in Calc When Pasted as GDI Metafile into Writer Do Not Appear
Summary: Underlined Words in Calc When Pasted as GDI Metafile into Writer Do Not Appear
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version: 4.2.0.4 release
Hardware: Other Mac OS X (All)
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard: bibisectRequest
Keywords: regression
Depends on:
Blocks:
 
Reported: 2014-02-04 16:25 UTC by noibsguy
Modified: 2015-01-24 12:58 UTC (History)
3 users (show)

See Also:
i915 platform:
i915 features:


Attachments
Shows Lack of Underlined Items from Calc when Pasted into Writer as GDI Metafile (112.88 KB, application/pdf)
2014-02-04 16:25 UTC, noibsguy
Details
Show Lack of Underlining in GDI Metafile Objects Pasted from Calc into Writer (369.48 KB, image/jpeg)
2014-02-04 18:31 UTC, noibsguy
Details
Another simple example of this bug (112.01 KB, image/jpeg)
2014-03-05 15:44 UTC, noibsguy
Details
Shows the Underline Bug (20.71 KB, application/pdf)
2014-10-06 17:30 UTC, noibsguy
Details

Description noibsguy 2014-02-04 16:25:58 UTC
Created attachment 93371 [details]
Shows Lack of Underlined Items from Calc when Pasted into Writer as GDI Metafile

Create some things in Calc. Underline some of the words or numbers. For example, add some numbers and underline the last number in the column before the sum. Select that stuff in Calc and paste as a GDI Metafile object into Writer. The underlined items are no longer underlined in Writer. They are not visible and do not print. GDI Metafile objected pasted into a Writer document under previous versions of LibreOffice no longer appear either. That's the bigger problem for people like me. That means is a Writer problems and not a Calc problem.

I'm a college professor (accounting) who has five different 300-plus page Writer documents that my students use in my classes. They have hundreds of GDI Metafile objects pasted from Calc. There are thousands of underlined items (mostly numbers in various calculations) that no longer appear in all of these files under LO 4.2.0. For me this is a critical bug.

I will have to use the LO 4.1.X until this is fixed. Please see the attached pdf file that shows what I've described above.
Comment 1 noibsguy 2014-02-04 18:31:03 UTC
Created attachment 93399 [details]
Show Lack of Underlining in GDI Metafile Objects Pasted from Calc into Writer
Comment 2 noibsguy 2014-02-04 18:33:08 UTC
The encoding for the PDF attachment is wrong. Ignore it.

View the JPEG attachment to see an illustration of this bug.
Comment 3 noibsguy 2014-03-05 15:44:50 UTC
Created attachment 95173 [details]
Another simple example of this bug

My original description of this bug said that it involved pasting a GDI Metafile object into a writer document. It's broader than that. If part of a spreadsheet is copied and then pasted into the same spreadsheet as a GDI Metafile object, nothing underlined in the spreadsheet appears in the GDI Metafile object. See the last attachment.

As I described in my previous description, this bug prevents from from upgrading to 4.2.x. BTW--it's also present in 4.2.1.
Comment 4 Jacques Guilleron 2014-03-06 13:07:56 UTC
Hello noibsguy,

I reproduce with LO 4.2.0.4 but not with LO 4.3.0.0.alpha0+
Build ID: 95700a2d7d09893fe16aadb406e93bf7164f7422
TinderBox: Win-x86@47-TDF, Branch:MASTER, Time: 2014-02-25_10:03:20

I think your report is related to Bug 74584 - Can no longer copy spreadsheet cells from libreoffice calc to another app like thunderbird and paste as html table,
where all formated texts could not be pasted to another external application. 
This was fixed and patch would be available with LO 4.2.2.
I set status to DUPLICATE of this bug. 

Kind regards,

Jacques

*** This bug has been marked as a duplicate of bug 74584 ***
Comment 5 noibsguy 2014-03-06 18:30:40 UTC
Let me add some more detail to this bug (and I do hope it's fixed in LO 4.3).

It's not necessarily related to pasting in the current LO. It relates to any GDI metafile object copied from the spreadsheet and pasted into any LO document in ANY VERSION of LibreOffice but displayed in LO 4.2.X. I have many files that go back to LO 4.0 and before.

If I open any of those files in LO 4.2.X and if those files contain GDI Metafile objects created from the spreadsheet and if those objects contain any underlined words or numbers, none of those items are underlined in LO 4.2.X but they are underlined in every previous version of LO.

This bug relates to the incorrect display of GDI Metafile objects in the current version of LO. Anything underlined (it doesn't relate to spreadsheet borders) in a GDI Metafile displays in LO 4.2.X without the underlining, whether or not the file was created in LO 4.2.2.

I wish I had not used the "paste" word in my original description of this bug. It's a display issue that affects every LO module.

I've checked all pre-release version of LO as of today and this isn't fixed in those versions.
Comment 6 noibsguy 2014-03-06 18:33:55 UTC
The problem now is that this bug is associated with other pasting bugs when that's not the issue. Is it possible for any of the admins to change the title of this bug to more accurately reflect it's nature?
Comment 7 noibsguy 2014-07-30 17:16:34 UTC
One more bump for this bug....

First, it's still present is the most recent release of LO (as of 7/30/14) and is still present in the latest nightly developmental releases (4.3.X).  It's also now present in the most recent release of OpenOffice.

Second, reproducing this bug is easy if you're a Mac user: Start a new calc document. Put a word in several cells in the spreadsheet. Underline the words. Copy the cells. Paste as a GDI Metafile object into a Writer doc or even back into the same spreadsheet as a GDI Metafile oject. Nothing underlined in the source spreadsheet will have an underline in the GDI Metafile object. The underlines don't print either.

Third, the underlines are apparently present because if you view the GDI Metafile object as a bitmap, the underlines are present. I believe that for some unknown reason, the underlines are too thin to appear in LibreOffice under the Mac operating system. It seems unlikely that this bug also affects Windows because ther would be more people reporting it.

Fourth, I am unable to update LO to any version past 4.1.X because of this bug. I have five 300+ page Writer documents with several hundred complex calculations from Calc appearing as GDI Metafile objects. Before literally thousands of totals and subtotals is an underlined number...that is not underlined any more if I use LO 4.2.X+.
Comment 8 Joel Madero 2014-08-05 23:47:52 UTC
REOPENED is reserved for a bug that:

1. a developer has marked as FIXED;
2. a developer is assigned to the bug that is marked as FIXED;

In this case the bug report was never independently confirmed so correct status is UNCONFIRMED. Thanks!
Comment 9 Alex Thurgood 2014-10-06 15:01:57 UTC
Confirming - bug also present in my own master build on OSX 10.9.5
Comment 10 Alex Thurgood 2014-10-06 15:04:32 UTC
To reproduce, follow submitter's instructions in Comment 7
Comment 11 Alex Thurgood 2014-10-06 15:06:36 UTC
Works in
Version: 4.1.4.2
Build ID: 0a0440ccc0227ad9829de5f46be37cfb6edcf72

regression
Comment 12 Alex Thurgood 2014-10-06 15:09:32 UTC
This still works for me in 

Version: 4.2.4.2
Build ID: 63150712c6d317d27ce2db16eb94c2f3d7b699f8
Comment 13 Alex Thurgood 2014-10-06 15:13:27 UTC
OK, so this is weird, it also works for me in

Version: 4.3.2.2
Build ID: edfb5295ba211bd31ad47d0bad0118690f76407d


which would tend to indicate that it is a configuration profile problem, as my LO dev build has a separate profile.
Comment 14 Alex Thurgood 2014-10-06 15:15:58 UTC
@noibsguy : did you let LO create a new user profile, or use an existing one ?
Comment 15 Alex Thurgood 2014-10-06 15:19:31 UTC
Works for me in Version: 4.3.2.2
Build ID: edfb5295ba211bd31ad47d0bad0118690f76407d

with clean profile
Comment 16 Alex Thurgood 2014-10-06 15:21:38 UTC
setting back to default priority/severity pending reproducible conditions
Comment 17 noibsguy 2014-10-06 17:30:17 UTC
Created attachment 107440 [details]
Shows the Underline Bug

See how the underline, when pasted as a GDI Metafile Object, appears to be white. You can see it crossing the bottom of the "g" character.
Comment 18 noibsguy 2014-10-06 17:34:29 UTC
After reading the comments today, I was hopeful. I deleted my user profile (the entire folder within the user Application Support folder).

I'm still seeing the bug. I just created a small PDF file showing how the bug looks. See the Example.pdf file.

What's interesting is that the underline appears to be a white underline that you can see crossing over the bottom the "g" character.

I'm running Mac OS X 10.9.5 on a 2014 retina MacBook Pro.

The PDF I created was from Writer. The first pasted object was a calc8 object. The second was a gdi metafile object.
Comment 19 noibsguy 2014-10-06 17:40:00 UTC
I forgot...I was using a freshly downloaded LO 4.3.2.2.
Comment 20 noibsguy 2014-10-06 21:28:02 UTC
Some additional observations regarding this display bug:

1. It's now present in the latest version of OpenOffice.

2. The missing underline is actually present. If you copy the GDI metafile object pasted into a Writer document and paste it back as a bitmap, the underline shows up--albeit at too low a resolution to make it a good fix.

3. If you right click on the GDI metafile object and compress the image, the underline mostly shows up. The fact that it's kind of distorted might be a clue that someone smarter than I can use.

4. Having antialiasing turned on or off in LO's General preferences doesn't affect the bug.

5. The bug is present under Mac OS 10.9.5 on both a retina MacBook Pro and an older Macbook Air without a retina display. Thus, it's not related to retina displays.

I'm not a programmer so take this with a grain of salt; however, I believe this bug reflects changes in the underlying Mac antialiasing (font smoothing) and how it interacts with the VERY thin underlining in LibreOffice and OpenOffice. I can't test this because Apple has apparently made it very difficult to turn off font smoothing in later version of the Mac OS. Terminal commands I used to use are no longer effective.
Comment 21 Beluga 2014-11-27 11:01:35 UTC
(In reply to noibsguy from comment #17)
> Created attachment 107440 [details]
> Shows the Underline Bug
> 
> See how the underline, when pasted as a GDI Metafile Object, appears to be
> white. You can see it crossing the bottom of the "g" character.

Reproduced.

Win 7 64-bit Version: 4.5.0.0.alpha0+
Build ID: b144f0ac8695dd62a2053b4e88212d0b109c9a41
TinderBox: Win-x86@51-TDF, Branch:MASTER, Time: 2014-11-25_00:14:54
Comment 22 Beluga 2015-01-10 19:37:57 UTC
LINUX:
No repro in 3.5.
Repro in 4.5.

Ubuntu 14.10 64-bit
LibreOffice 3.5.0rc3 
Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735

Version: 4.5.0.0.alpha0+
Build ID: 9763b55eb946cf425220d26dab91bf220890b180
TinderBox: Linux-rpm_deb-x86_64@46-TDF-dbg, Branch:master, Time: 2015-01-08_12:56:53


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.