SOLVED

Insérer une image sans la figer

%3CLINGO-SUB%20id%3D%22lingo-sub-2378677%22%20slang%3D%22fr-FR%22%3EInsert%20an%20image%20without%20freezing%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2378677%22%20slang%3D%22fr-FR%22%3EHello%2C%20here%20I%20am%20back%20with%20a%20new%20question...%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20looking%20to%20integrate%2020%20images%20on%20lines%201%20to%2020%20imagine.%20These%20images%20will%20be%20on%20the%20same%20line%20as%20the%20values%20that%20correspond%20to%20it.%20Once%20the%20values%20are%20sorted%2C%20I%20would%20like%20the%20images%20to%20follow%20the%20relevant%20line%20and%20not%20remain%20in%20their%20baseline%20as%20they%20are%20now.%20Do%20you%20know%20how%20I%20could%20do%20it%20please%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2378677%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2378738%22%20slang%3D%22en-US%22%3ERe%3A%20Ins%C3%A9rer%20une%20image%20sans%20la%20figer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2378738%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1056784%22%20target%3D%22_blank%22%3E%40othonagra%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAssurez-vous%20que%20les%20images%20sont%20d%C3%A9finies%20sur%20%22D%C3%A9placer%20mais%20ne%20pas%20dimensionner%20avec%20les%20cellules%22.%3CBR%20%2F%3EAssurez-vous%20%C3%A9galement%20que%20chaque%20image%20tient%20enti%C3%A8rement%20dans%20une%20cellule.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0441.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F282925iFF37BCEDCBD5FF26%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S0441.png%22%20alt%3D%22S0441.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2378973%22%20slang%3D%22fr-FR%22%3ERe%3A%20Insert%20an%20image%20without%20freezing%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2378973%22%20slang%3D%22fr-FR%22%3EThis%20is%20the%20case%2C%20the%20box%20is%20well%20checked%20and%20yet%20it%20does%20not%20move%20when%20I%20do%20a%20sort.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2379001%22%20slang%3D%22en-US%22%3ERe%3A%20Ins%C3%A9rer%20une%20image%20sans%20la%20figer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2379001%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1056784%22%20target%3D%22_blank%22%3E%40othonagra%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%C3%8Ates-vous%20s%C3%BBr%20d'avoir%20inclus%20la%20colonne%20avec%20les%20images%20dans%20la%20plage%20%C3%A0%20trier%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2379192%22%20slang%3D%22fr-FR%22%3ERe%3A%20Insert%20an%20image%20without%20freezing%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2379192%22%20slang%3D%22fr-FR%22%3EI'll%20send%20you%20the%20file%20as%20it%20is%20as%20soon%20as%20possible%20so%20you%20can%20see%20for%20yourself.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2379237%22%20slang%3D%22en-US%22%3ERe%3A%20Ins%C3%A9rer%20une%20image%20sans%20la%20figer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2379237%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1056784%22%20target%3D%22_blank%22%3E%40othonagra%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EVous%20pouvez%20joindre%20une%20copie%20du%20fichier%20(sans%20donn%C3%A9es%20propri%C3%A9taires)%20%C3%A0%20une%20r%C3%A9ponse%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2379409%22%20slang%3D%22fr-FR%22%3ERe%3A%20Insert%20an%20image%20without%20freezing%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2379409%22%20slang%3D%22fr-FR%22%3EWhat%20do%20you%20mean%20by%20without%20proprietary%20data%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI%20can't%20send%20it%20to%20you%20at%20the%20moment%20not%20having%20access%20to%20my%20computer.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2380094%22%20slang%3D%22fr-FR%22%3ERe%3A%20Insert%20an%20image%20without%20freezing%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2380094%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3EVogelaar%3C%2FA%3E%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F21903%22%20target%3D%22_blank%22%3E%40hans%3C%2FA%3E%20Here's%20the%20current%20file.%26nbsp%3B%20The%20club%20logos%20are%20well%20in%20front%20of%20the%20teams%20because%20I%20put%20them%20like%20that%2C%20however%2C%20as%20soon%20as%20I%20change%20a%20result%2C%20the%20ranking%20changes%20completely%20except%20the%20logos.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2380186%22%20slang%3D%22en-US%22%3ERe%3A%20Ins%C3%A9rer%20une%20image%20sans%20la%20figer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2380186%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1056784%22%20target%3D%22_blank%22%3E%40othonagra%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EVotre%20fichier%20ne%20contient%20aucune%20image...%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0443.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F283078iB325B86B86166D1E%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S0443.png%22%20alt%3D%22S0443.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2380370%22%20slang%3D%22fr-FR%22%3ERe%3A%20Insert%20an%20image%20without%20freezing%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2380370%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3EVogelaar%3C%2FA%3E%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F109770%22%20target%3D%22_blank%22%3E%40Hans%20I%3C%2FA%3E%20didn't%20send%20you%20the%20right%20file...%26nbsp%3B%20From%20now%20on%2C%20I'll%20join%20you%20with%20the%20good%20one%20to%20this%20message.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2380526%22%20slang%3D%22en-US%22%3ERe%3A%20Ins%C3%A9rer%20une%20image%20sans%20la%20figer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2380526%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1056784%22%20target%3D%22_blank%22%3E%40othonagra%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMerci%20beaucoup!%20%3CBR%20%2F%3ELe%20probl%C3%A8me%20est%20caus%C3%A9%20par%20les%20formules%20TRI.PAR.%20Ils%20ne%20bougent%20pas%20les%20cellules!%20Ils%20ne%20renvoient%20qu'un%20r%C3%A9sultat%20diff%C3%A9rent%20dans%20la%20m%C3%AAme%20cellule.%3CBR%20%2F%3EJ'ai%20peur%20de%20ne%20pas%20avoir%20de%20solution%20pour%20%C3%A7a.%20Je%20suis%20d%C3%A9sol%C3%A9!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2380553%22%20slang%3D%22en-US%22%3ERe%3A%20Ins%C3%A9rer%20une%20image%20sans%20la%20figer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2380553%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1056784%22%20target%3D%22_blank%22%3E%40othonagra%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20you%20trying%20to%20have%20the%20image%20follow%20the%20team%20position%20in%20the%20league%3F%3C%2FP%3E%3CP%3EIf%20so%2C%20you%20need%20an%20image%20for%20each%20position%20and%20define%20a%20named%20formula%20to%20link%20it%20to%20the%20correct%20image%20in%20the%20original%20list.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F283100iEA11C9529323850F%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2382754%22%20slang%3D%22fr-FR%22%3ERe%3A%20Insert%20an%20image%20without%20freezing%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2382754%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214174%22%20target%3D%22_blank%22%3Ebartholomew%3C%2FA%3E%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20%3Ca%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22943%22%3E%40peter%3C%2Fa%3E%20I%20tried%20to%20do%20it%20the%20same%20way%20you%20did%20but%20it%20doesn't%20work%2C%20there%20are%20things%20I%20don't%20understand.%26nbsp%3B%20Could%20you%20give%20me%20an%20example%20on%20the%20correct%20file%20I%20please%20send%20you%20below%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor
Bonjour, me voilà de retour avec une nouvelle question...

Je cherche à intégrer 20 images sur les lignes 1 à 20 imaginons. Ces images seront sur la même ligne que les valeurs qui lui correspondent. J'aimerais, une fois que les valeurs sont triées, que les images suivent la ligne concernée et qu'elles ne restent pas dans leur ligne de base comme actuellement. Savez-vous comment je pourrais faire s'il vous plaît ?
14 Replies

@othonagra 

Assurez-vous que les images sont définies sur "Déplacer mais ne pas dimensionner avec les cellules".
Assurez-vous également que chaque image tient entièrement dans une cellule.

 

S0441.png

C'est pourtant le cas, la case est bien cochée et pourtant ça ne se déplace pas quand je fais un tri.

@othonagra 

Êtes-vous sûr d'avoir inclus la colonne avec les images dans la plage à trier?

Je vous envoie le fichier en l'état dès que possible pour que vous puissiez voir par vous même.

@othonagra 

Vous pouvez joindre une copie du fichier (sans données propriétaires) à une réponse

Qu'entendez vous par sans données propriétaires ?

Je ne peux pas vous l'envoyer pour le moment n'ayant pas accès à mon ordinateur.

@othonagra Sans des données sensibles, privées.

@Hans Vogelaar 

Voici le fichier actuel. Les logos des clubs sont bien en face des équipes car je les ai mis comme ça, cependant, dès que je change un résultat, le classement se change entièrement sauf les logos.

@othonagra 

Votre fichier ne contient aucune image...

 

S0443.png

@Hans Vogelaar 

Je ne vous avais pas envoyé le bon fichier... Désormais, je vous joins le bon à ce message.

@othonagra 

Merci beaucoup!
Le problème est causé par les formules TRI.PAR. Ils ne bougent pas les cellules! Ils ne renvoient qu'un résultat différent dans la même cellule.
J'ai peur de ne pas avoir de solution pour ça. Je suis désolé!

best response confirmed by othonagra (Occasional Contributor)
Solution

@othonagra 

Are you trying to have the image follow the team position in the league?

If so, you need an image for each position and define a named formula to link it to the correct image in the original list.

image.png

@Peter Bartholomew 

J'ai essayé de faire de la même manière que vous mais ça ne fonctionne pas, il y a des choses que je ne comprends pas. Pourriez-vous me faire un exemple sur le bon fichier que je vous transmets ci-dessous svp ?

C'est bon j'ai trouvé la solution, merci à vous deux de m'avoir aidé.