Description: ref: https://github.com/jmcnamara/XlsxWriter/issues/1089 If I add an image at a position where y > 2147483648 (2**31), the image doesn't get rendered at the expected position. Note: The value of y is in the file in character(?) units. In UI, I can move the image downwards but when I save and reopen, the image moves back to it's original position. As I documented in the referenced issue, it appears that we are using a signed 32 bit integer to get this value and probably preventing integer overflow. Just a guess though. Steps to Reproduce: 1.Create a blank Spreadsheet 2.Add an image in the last row and anchor it to the cell 3. Save and reopen the file Actual Results: Observe that the image has moved somewhere else (near 13212 cell in default row height) Expected Results: The image should stay as it was placed. Reproducible: Always User Profile Reset: Yes Additional Info: Version: 24.8.0.3 (X86_64) / LibreOffice Community Build ID: 480(Build:3) CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb) Locale: en-IN (en_IN.UTF-8); UI: en-US Ubuntu package version: 4:24.8.0~rc3-0ubuntu0.24.04.1~lo2 Calc: threaded
A sample XLSX with such a problem (generated by XlsxWriter?) would be nice.
Created attachment 196235 [details] Sample generated by xlsxwriter
@mike(In reply to Mike Kaganski from comment #1) > A sample XLSX with such a problem (generated by XlsxWriter?) would be nice. I added the attachment - the file generated from xlsxwriter. However, the steps in description might be more convenient to recreate the bug and show that xlsxwriter is not the culprit.
Of course xlsxwriter is not the culprit - it's known; drawingml import uses UNO API to set the coordinates and sizes; and that is 32-bit. The file is needed for convenience of testing, to avoid the steps. I set to NEW, but I bet there's already a duplicate.