import image to be sorted with data

8 replies [Last post]
mattthhdp
Offline
Last seen: 1 day 29 min ago
Title:
Joined: 25 May 2016
Posts: 4
I Hope someone will be able to help me, i have linked an example so it will be better to undestand.

One of my customer need to be able to sort some of is data ( no problem with that)
but he also need to have picture with is customer. i am not able to make the picture “follow” the customer

Is there a way to make a pilot table and been able to sort, let’s say WTW between 5 to 7, and been able to see the picture ?

Thanks you !

Sorry for my bad english im french Smile

AttachmentSize
stats.ods66.53 KB
mark_t
Offline
Last seen: 8 hours 17 min ago
Title: ★★★★
Joined: 26 Apr 2016
Posts: 90
You could put the picture as
You could put the picture as the background to a comment on a cell in the row for that customer. Perhaps the cell that has the customer name. Then when you hover over the customer name cell the comment would show the picture. The comments should follow the cell when you sort or filter the table.

To put picture in comment I was having a little trouble so try this. Select the cell. Right click insert comment. Put a space or new line in the comment box, anything that doesn’t print but don’t leave it empty. Select a different cell, then right click the comment cell and select show comment. Then right click on the comment and select Area, this should give a dialog box. Choose bitmaps, then import the image from a file. On the area tab select the image, set Original size, position top left and clear Tile and Autofit. Then adjust the size of the comment box to suit the image.

Right click and hide image if you only want to see it when you hover over that cell.

I’m not sure how you could do this from a pilot table.

LibreOffice 5.1.3.2, Windows 8.1
mattthhdp
Offline
Last seen: 1 day 29 min ago
Title:
Joined: 25 May 2016
Posts: 4
i have tried your solution
i have tried your solution and it’s work pretty well, but i must be able to sort data. do you have any idea on how to do this with base ?

i already have near 3000 line entered in calc. I also need to be able to use some math equation (hope i can still use base for this)

i am really new to base so i dont know if it’s the right solution for me.

Or any other solution ? if we can sort data with calc without using pilot table its fine for me. My customer is not so good with computer so KISS (Keep it simple, stupid) is the best solution for me/him. But hey, if it’s work i won’t complain and i will take all the time he need to explain.

Thanks for you help !

mark_t
Offline
Last seen: 8 hours 17 min ago
Title: ★★★★
Joined: 26 Apr 2016
Posts: 90
Base might be able to do
Base might be able to do this, but I don’t know how, would recommend you ask in Base forum.

You could check the filtering and sorting of Calc, maybe it’s enough for your application.

Select your data range, then from the toolbar, “Data”, “Autofilter”. Then each of your headings will get a drop down filter menu.

With this method you only apply a sort order to a single column, but you can apply separate filters on any number of columns.

For more advanced sort, after selecting the range of data, “Data”, “Sort”, will give you a dialog box to select up to three columns and sort ascending or descending.

LibreOffice 5.1.3.2, Windows 8.1
mattthhdp
Offline
Last seen: 1 day 29 min ago
Title:
Joined: 25 May 2016
Posts: 4
that’s what im using right
that’s what im using right now, the only problem with this method is the picture. i can put them in comment has you said but do you know any kind of automation because i have to do this for near 3000 entry ?

by the way, thanks a lot for you help ! it’s taking form and i am moving foward Smile i appreciate your help !

mark_t
Offline
Last seen: 8 hours 17 min ago
Title: ★★★★
Joined: 26 Apr 2016
Posts: 90
Do you have a cell in your
Do you have a cell in your data with filename of the picture for that row of the table?

Or does the filename include the customer name that could be matched to the table?

It should be possible to generate a macro to take a selected file and create a comment with picture on a cell in your table. If you need to manually select each picture for 3000 rows, that’s still going to be a lot of effort even if the macro takes care of formatting the comment.

LibreOffice 5.1.3.2, Windows 8.1
Gregm66
Offline
Last seen: 11 hours 36 min ago
Title: ★★★
Joined: 30 Apr 2016
Posts: 42
try this it works for me
try this it works for me showing an image based on validity list item selected.

from a previous post of mine just save workbook and images to a folder called Images.

http://en.libreofficeforum.org/node/13328

hope this helps

mattthhdp
Offline
Last seen: 1 day 29 min ago
Title:
Joined: 25 May 2016
Posts: 4
I do have a cell with the
I do have a cell with the number of the picture (from a-1,a-2…a-8 to g-1…g-8) a-1 is a picture, a-2 an other … g-8 an other .

but if i make a macro, when he will sort his data, he will have to remove all picture before sorting his data, sort his data and finally run the macro to show the image ??

if its work there is no probleme, but the image must really follow the patient it’s important.

mark_t
Offline
Last seen: 8 hours 17 min ago
Title: ★★★★
Joined: 26 Apr 2016
Posts: 90
If the references refer to
If the references refer to the name of the picture file there should be no need to repeat the sorting.

Example if text “a-1” on the row of a patient is a-1.jpg picture file, then even if the list is sorted the text “a-1” will still be on the row for that patient and still refers to a-1.jpg.

With 3000 images, putting them in comments might cause memory problems for Calc and increase the file size.

Greg’s solution might be a better way to go, but possibly using the worksheet selection changed event to trigger the macro instead of using a worksheet function that runs when a specific cell changes value.

LibreOffice 5.1.3.2, Windows 8.1

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.