import image to be sorted with data
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
Attachment | Size |
---|---|
stats.ods | 66.53 KB |
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 !
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.
by the way, thanks a lot for you help ! it’s taking form and i am moving foward i appreciate your help !
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.
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
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.
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.
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.