Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

The original message might be very old but the problems I have including
graphics in Calc sheets is ongoing and VERY recent.


On 17 December 2014 at 10:16, Hedley Finger <> wrote:

Why not stay with the advantages of LibreOffice instead of trying to
it as hideous as MS Office!!?

​Can MS Office be more hideous than this?

I decided to make a small database of bicycle spare parts in Calc, in
which I would include a photo of each part as it's easier to scan a
printout for a picture than look up words.

Copying a graphic file from Gimp, etc. (or even another cell) and pasting
into a cell produces these results:

   - the anchor may be in the selected cell, or it could be to the sheet,
   or in the cell above, or the cell to the left
   - the cell must not only be selected (heavy border) but in direct
   text-entry mode to have any hope of pasting into the cell, otherwise the
   graphic will be anchored to the sheet for sure.

​You can change the anchor so that the graphic is equivalent to a
character, with these results:

   - if you hide the column in which the graphic character is located,
   the graphic is still visible, but it should be hidden like all the other
   text characters in that column. In fact, they are not only not hidden but
   they obscure the contents of the neighbouring visible (= non-hidden) cells
   - the same goes for hiding rows
   - if you resize the cell, the graphic overlaps into neighbouring
   cells, unlike what would happen if it were a real text character or string,
   which gets masked off at the borders.​

​The database file is located in the same folder as the graphic files.
This is important because the graphics are imported by reference, i.e. the
graphics are loaded when the Calc file is opened. Except some aren't but
are randomly not loaded.​

​I was the point of submitting a bug report when I lost all the content
and didn't have the motivation to redo it all.​ Time to copy this email
into a new bug report.


Ubuntu 14.04 LTS Trusty Tahr
LibreOffice (420m0(Build:2))

1/17 Glyndon Road, Camberwell VIC 3124, Australia
Telephone 03 9836 4635
Mobile 0412 461 558 registered computer 576484

1/17 Glyndon Road, Camberwell VIC 3124, Australia
Telephone 03 9836 4635
Mobile 0412 461 558 registered computer 576484

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.