This is perhaps similar to a very OLD issue, 54930 (https://bz.apache.org/ooo/show_bug.cgi?id=54930), which probably no longer applies since the version is very old.  However, this issue is detailed here: https://forum.openoffice.org/en/forum/viewtopic.php?f=7&t=96203

Problem:
Writer seems to be using the old JFIF standard which Adobe says is obsolete and not compatible with EXIF. Adobe uses the EXIF standard only. Using exiftool to extract the metadata in groups shows that the files which are correctly sized by Writer include a JFIF group containing resolution data. The files from Photoshop Elements don't have the JFIF group.

If I use exiftool to change the JFIF resolution but not the EXIF resolution for a .jpg that is displayed with the correct size, then Writer uses the new JFIF resolution and the image size changes. If I completely remove the JFIF settings then Writer uses 96ppi on my system and again the image size changes. In both cases, Writer ignores the EXIF resolution settings stored in the file.