GNOME Bugzilla – Bug 757998
batch image insertion
Last modified: 2018-05-04 17:50:20 UTC
This enchancement is dependent upon my previous enchancement request, Options for image insertion: https://bugzilla.gnome.org/show_bug.cgi?id=757993 If that request gets implemented I would love to see the ability to batch insert images into a selected range of cells with one image per cell. The user would have to select multiple consecutive cells either in a single row or in the same column. They would then right-click the cells, choose 'Insert Images...' at which point they'd see the enhanced image insertion window discussed in the above linked, previous request. After the user has selected muliple images files they would then get inserted alphabetically into the selected range of cells. It would be nice if this feature wasn't too fussy about making the user choose the exact number of cells required to insert the selected images. It could show a warning when the user hasn't selected enough cells to insert all the selected images but if they've selected more cells than there are images it should work without warning provided the cells are empty.
What is the use case for this?
In my case I am using an image downloader browser plugin to download many images off the web. I usually then have to do some manual renaming or sorting but after that I would like a quick and easy way to import them into a spreadsheet. Being able to easily import images into gnumeric seems greatly preferable to the open source alternative of creating a database and a web site to view images alongwith their data. As far as I can tell, MySQL workbench cannot display or embed images in its tables and nor does it have any simple way to batch import images like I'm suggesting here. You'd have to write some PHP to view your images on a local webpage using a DB for a task like this.
You can now paste multiple pictures into Gnumeric. They end up in the same spot so there is some sorting out to do afterwards. Alternatively you might be able to do this in python with the new introspection support. That's as far as I think we will go with this. We are, after all, trying to make a spreadsheet and not a database. --> FIXED. (Because none of the options really describe the resolution right.)