pictures rotated but not rotated

[yky]

Recently, I switched to the 64 bit version of IrfanView and there is a problem.

I have photos that are rotated 90 degrees. They are rotated when appearing in Windows' large icon view. I opened them in irfanview 64 and they are rotated. I opened them in Paint and they are rotated. However, after pasting to Excel by a VBA script, they are NOT rotated. (The script doesn't rotate pictures. It only inserts pictures.)

If I manually copy the picture from IrfanView and paste it to Excel, it stays rotated. However, when the script inserts the picture, the picture somehow is restored to its original state.

I have been using the script for more than a year and I have never encountered this problem. Does the 64 bit version rotate pictures in a way different from the 32 bit?

How does Excel know the original state of the picture? Do image programs do some cleaver tricks to rotate pictures which Excel, not an image program, ignores?

Seems to me I have to go back to using the 32 bit version of IrfanView.

[Bhikkhu Pesala]

The orientation of photos is stored in Exif data. If you remove that, they won't get autorotated.

[yky]

Thank you for the reply.

I did not do anything to the file. Does the fact that the files display correctly in IrfanView and Paint indicating that the Exif data is not removed?

I'm using the same Excel, same script. So, they should have no effect of the picture orientation. The thing that is changed is the switching of IrfanView from 32 to 64 bit.

I'll download the 32 bit version and see if the same problem occurs.

[Bhikkhu Pesala]

I did not do anything to the file. Does the fact that the files display correctly in IrfanView and Paint indicating that the Exif data is not removed?

Yes. Some programs detect the Exif data (the orientation of the camera when the picture was taken), and autorotate it on opening the JPG image.

It is nothing to do with 32-bit or 64-bit, but each version uses it's open INI file and therefore it's own settings. If you uncheck this box in Settings, the photo will not be autorotatted on opening it. If you want to remove the rotation, open it and save it without the Exif data.

It is recommended to use 32-bit IrfanView unless you need to work with very large images.

If you want to rotate it without losing the Exif data, uncheck the box, use Lossless Rotation from the Options menu, then save it.

[yky]

Thank you for the reply.

I unchecked "auto-rotate image according to EXIF info if available" and now, the pictures are not rotated. After they are inserted into Excel files, they still are not rotated.

What I really want is for the pictures to be rotated not only in IrfanView and Paint but also in Excel. Before, I rotated the pictures using Windows Explorer and they appear rotated in all image programs and also Excel.

Now that I think about it, I think of a difference. Before, I had done this in Windows 7 but now I'm doing it in Windows 8.1. Maybe these two versions of Windows rotate pictures differently. Perhaps Windows7 really rotates pictures but Windows 8.1 only change the EXIF data.

[yky]

I had been using Windows' built-in function to rotate pictures. I just used IrfanView's function to rotate one picture. I rotated the picture and deselect the auto-rotate. When I opened the picture in IrfanView and Paint, it's rotated. Another picture is not rotated using IrfanView's function. It appears rotated if I check the "auto-rotate" option. If the option is not checked, it stays horizontal.

Yet, in Excel, both are NOT rotated.

[Bhikkhu Pesala]

I think this thread is going round in circles.

[Mij]

The effects of the auto-rotate function are difficult for users to understand but even more difficult to explain. I have tried to do so in a number of threads over the years. This thread was one of them.

[yky]

I think this thread is going round in circles.

After some tests, I now believe Explorer doesn't really rotate pictures pixel by pixel. Although the icons appear rotated, when the pictures are opened in IrfanView, they are not rotated.

Is Lossless rotation the solution? Does it really rotate all the pixels or it just manipulate EXIF data? Since JPEG is a lossy compression and rotation involves decompression, rotation, compression, I don't see how lossless compression is done.

If lossless rotation is the solution, can it be incorporated into batch conversion? Right now, it doesn't show up as an option in batch conversion.

[yky]

The effects of the auto-rotate function are difficult for users to understand but even more difficult to explain. I have tried to do so in a number of threads over the years. This thread was one of them.

Thank you for the link.

All I want is to have Excel display pictures the way they appear in IrfanView. If a picture is upright in IrfanView, it is also upright in Excel. Right now, rotated pictures appear in Excel as non-rotated.

[Bhikkhu Pesala]

All I want is to have Excel display pictures the way they appear in IrfanView. If a picture is upright in IrfanView, it is also upright in Excel. Right now, rotated pictures appear in Excel as non-rotated.

If Excel is not rotating the images according to the Exif data, you will have to edit them in IrfanView to remove the Exif data. I think if you open them with the autorotate flag enabled, then save them without Exif data they will be rotated in Excel.

If you want to retain the Exif data, try resetting the rotation flag.