I really searched for something like this but couldn’t find another feature request for my problem.
A while ago I switched from Microsoft Excel to Google Sheets for a few projects because they have the feature to insert an image into a cell an not just align it with the cell. Currently I am trying to get completly rid of Microsoft office and Google Office but there is a problem.
Only Office Spreadsheet does have a similar option which can move and resize an image with a cell but this is not the same.
What I would need is the following:
allow the insertion of an image inside a cell
allow the image to keep the aspect ratio
don’t allow the image to go over the border of a cell.
Maybe there’s a feature already implemented but I just couldn’t find anything like this.
I don’t know how hard it would be to implement such a feature or if anybody else is interested in such a feature. I really like onlyoffice as an alternative but this is sadly a deal-breaker for some of my tables.
Have a nice evening,
XOYZ
OS version: Manjaro Linux - Kernel: 6.1.38-1-MANJARO (64-bit)
App version: 7.4.0-1
Downloaded from: Manjaro Software Store - Package: onlyoffice-dektopeditors
We have the enhancement suggestion to add insert an image in the cell function or its equivalent to the table editor.
However, we do not have any estimated time frames of the release available yet.
I’ve added your request to mentioned suggestion.
Sorry for the inconvenience caused
I also sometimes want to have this function.
Thank you for evaluating our product! We really appreciate it.
I just want to say I’m also very interested in that feature, none of opensource office alternatives have it as far as I’m aware. On top of it It would be really awesome to be able to use formulas to refer to cells with images. Like making a dropdown menu to select an image from a range of cells with INDEX and MATCH functions.
I’ve added you to the mentioned feature request for inserting images inside cells
As for your suggestion to use formulas to refer to cells with images (e.g., using INDEX and MATCH functions), if you’d like to formally propose these features, feel free to create a separate topic. It would be really helpful if you could provide examples or links to where this functionality is already implemented, so we can better understand your vision for the feature.
Dear @Nikolas I would love the see the requested image insert option in the near future and would be happy to provide a small donation to accelerate its implementation (just pm me if interested).
With utmost respect for your work, I think your are missing a real USP compared to other free spreadsheet apps. I use onlyoffice on linux for home use and frequently encounter situations where the insert option would make sheets just so much more intuitive (eg. imagine hiking kit list, food plans, gardening schedules). Combined with conditional formating this feature would be such a powerful tool. Other apps from your competitor would miss out to one of different reasons:
Thank you so much for your detailed explanation and your willingness to support the development of the image insert feature!
I’ve forwarded your request to our development team. Raising awareness about this feature is already a huge contribution, so you’re definitely making an impact by sharing your needs and use cases.
If you have friends or colleagues who also feel this feature would improve their experience with ONLYOFFICE, we’d love to welcome them on the forum and hear their feedback as well!
Hiya @Nikolas, this is also something that would be really convenient for the projects I usually do.
I’m currently in the process of cataloging several electrical components for a research project, and manually adjusting the corresponding images has been the most tedious aspect of it. It’s not a huge problem when it’s just a few images, but I’ve also got a personal project of 80 images and counting that is gonna have to stay in Google Sheets for the time being.
I completely understand the challenge you’re facing, especially when working with many images. I’ve added you to the list of users interested in the feature request for inserting images inside cells.
I signup for this also. I use catalogues with images for my suppliers. As mostly they don’t use numbers or get confused i would VERY APPRECIATE this feature also.
Great tool i switched recently from google and libreoffice , Thanks
Dear @Nikolas Thank you very much for your answers!
I have reached out to some friends and colleagues and collected use cases from them:
Business:
A personal trainer would like to store different info for each exercise type. For example a picture of pull ups would be stored in a row, followed by info like difficulty level, activated muscles, client feedback, required time, recommended intervals, etc.
A jeweler would love to manage different designs/ finished pieces and their associated info (metal composition, price, production cost, production time, sales time, etc.) in a sheet with a picture for each item and conditional formatting to get a intuitive view of the different properties.
A wood turner has pretty much the same use case. Additionally it would greatly help to manage his wood store. Every wood piece has a different texture which needs to be accounted for, since it limits its suitability for different projects.
A leather artist has the same use case as the jeweler.
Private:
Creating hiking kit list with weights and other statistics for every item (huge in the UL and travel community)
A mushroom club would love to create an info table, listing different mushrooms with their edibility value, typical locations, occurrence frequencies for every year, etc.
Creating a gardening and planting schedule with pictures for every plant or type of work.
Creating references for cooking recipes and their ingredients alongside data like cooking time, cost, nutritional value, etc.
Financial planning with pictures for each (sub-)category
Keeping a record of different collectibles like watches, wet shaving equipment (not so niche as one might think in the beginning; forums and a lot of suppliers exist), coins & stamps, rocks & minerals
Hope this helps accelerate the feature request. Thank you for your great work!
Thank you for your feedback! Your comments have been noted and taken into account. We’ve added your requests to our proposal list for potential inclusion in future updates to the editor.
While there’s no timeline yet for the implementation of this feature, we appreciate you highlighting this necessary functionality. Your input is invaluable in helping us improve our products.
