Importing png files to the spreadsheet

Discuss the spreadsheet application

Importing png files to the spreadsheet

Postby templii » Sun Apr 05, 2020 12:32 pm

I have been successfully adding png picture files to my spreadsheet from webpages by this method:
Right click on the image
Save image as
Select show in folder
Drag the image from the folder into the spreadsheet
I have just tried to add an image within a series of similar images and when I try to drag it into the spreadsheet I am confronted with the ASCII Filter Options box

Can this be explained and resolved please?
OpenOffice 4.1.7 on Windows 10 only
Posts: 1
Joined: Sun Dec 22, 2019 5:32 pm

Re: Importing png files to the spreadsheet

Postby Zizi64 » Sun Apr 05, 2020 1:09 pm

Do not drag pictures into a document. Use the regular method from the Menu.

Insert - Image...

And always optimize the pictures before you embed them into a document file. Decrease the color depth, resize, resample the image to the optimal values.

Otherwise a Calc spreadsheet document is not the best way for create a "photoalbum".
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Posts: 9431
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Importing png files to the spreadsheet

Postby RoryOF » Sun Apr 05, 2020 1:16 pm

The ASCII filter message usually indicates that OpenOffice does not understand the file format. If these are images stored on your computer, are they corrupt?
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
Posts: 31232
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Importing png files to the spreadsheet

Postby John_Ha » Sun Apr 05, 2020 4:01 pm

An image from the web often include additional content. See the item about web images in [Tutorial] Some useful hints on using images.

It is quite OK to drag an image file from your PC into a program.
LO, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Posts: 7774
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 6 guests