[Bug 169332] FILEOPEN XLSX Scaled images width is imported incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=169332 --- Comment #12 from Bayram Çiçek --- Created attachment 205901 --> https://bugs.documentfoundation.org/attachment.cgi?id=205901&action=edit image aligned to col H A) image overlap Calc vs Excel. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 169332] FILEOPEN XLSX Scaled images width is imported incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=169332 --- Comment #11 from Bayram Çiçek --- (In reply to Caolán McNamara from comment #8) > Can we get some images with the excel and calc grids, at the same zoom level > with the sample image in them overlaid (50% transparency or so) on top of > eachother to easily compare: > > a) blank freshly created excel spreadsheet, default column width with the > image in it, and the image width set so the right side of the image aligns > with the right side of some column, e.g end of 'F'. And then the same loaded > in calc, at 100% zoom. A) Set width to a column. images does not match. -> Excel one is a bit wider. Excel's col width is wider. > b) blank freshly created excel spreadsheet, with the image in it, but column > A stretched to the width of the image, so the image width fits in just one > column where the image width reported is the same as the width the original > testcase reports. A) fit image to column A. images does not match. -> Excel one is a bit wider. -> But widths are the same in this case. Calc's col A width is wider. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 169332] FILEOPEN XLSX Scaled images width is imported incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=169332 Aron Budea changed: What|Removed |Added CC||[email protected], ||[email protected] --- Comment #10 from Aron Budea --- I did find two interesting commits when looking for the change of 2.10 -> 2.07 in 5.3 when opening the first attachment (no roundtrip): https://git.libreoffice.org/core/commit/f2a75fecdfb5d92d27074312f29dc7dc4afb16ec author Bartosz Kosiorek Mon Aug 08 01:13:05 2016 +0200 committer Eike Rathke Mon Dec 05 10:27:40 2016 + "tdf#91475 Fix column width during .xlsx export" (yes, this commit matters for import as well) https://git.libreoffice.org/core/commit/16726a1b37df8bdcae02b3c7699df814977222bd author Markus Mohrhard Wed May 20 03:59:49 2015 +0200 committer Markus Mohrhard Wed May 20 04:04:13 2015 +0200 "better algorithm for OOXML column width import, tdf#91267" While they won't help much, maybe there's something to take away in there. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 169332] FILEOPEN XLSX Scaled images width is imported incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=169332 --- Comment #9 from Caolán McNamara --- (In reply to Caolán McNamara from comment #8) > Can we get some images with the excel and calc grids, at the same zoom level At 100% zoom is best I think. On-screen comparison at 100% zoom and compare what are the actual rendered boundaries of the image. Lets assume, if they actually align then, regardless of what (fantasy) numbers the applications report, then it's in the right place and size. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 169332] FILEOPEN XLSX Scaled images width is imported incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=169332 --- Comment #8 from Caolán McNamara --- Can we get some images with the excel and calc grids, at the same zoom level with the sample image in them overlaid (50% transparency or so) on top of eachother to easily compare: a) blank freshly created excel spreadsheet, default column width with the image in it, and the image width set so the right side of the image aligns with the right side of some column, e.g end of 'F'. And then the same loaded in calc, at 100% zoom. b) blank freshly created excel spreadsheet, with the image in it, but column A stretched to the width of the image, so the image width fits in just one column where the image width reported is the same as the width the original testcase reports. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 169332] FILEOPEN XLSX Scaled images width is imported incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=169332 --- Comment #7 from Bayram Çiçek --- Created attachment 205371 --> https://bugs.documentfoundation.org/attachment.cgi?id=205371&action=edit xlsx document with text under the image Hi. I've been working on this ticket for a few weeks. I didn't find any issues on the width calculation on the LO side. But column width of Excel and Calc seems different. (Caolan) This seems the main reason why width of an image is different in both application. Image width sticks to the column location rather than its width. I see excel itself has different calculations on the image widths. Some info about column widths: ``` Column width is not a pure point measurement. Instead, it’s based on the number of characters of the default font that can fit in the cell. For example, a column width of 8.43 means about 8 characters of the default font (Calibri, size 11) fit across the cell. Excel internally converts this into points for display, but it’s not a straight “height vs. width” comparison [...] ``` The attached document has some text underneath the image. I uploaded some screenshots to compare the documents in the previous comments. - If I take the exact image width during import (avoiding changes in the codebase), and apply it to Calc -> the image position relative to columns will be wrong. - So, at the moment, we can't say "get the exact image width from Excel and make it the same width in Calc". -> position -related to columns- will be wrong. Maybe this is just how it works? Is this really a bug? I'm not sure, and I'm confused here. @Gabor: What is the expected outcome here? What behavior do you think is correct? Thank you. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 169332] FILEOPEN XLSX Scaled images width is imported incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=169332 --- Comment #6 from Bayram Çiçek --- Created attachment 205370 --> https://bugs.documentfoundation.org/attachment.cgi?id=205370&action=edit Calc has wider image width -- You are receiving this mail because: You are the assignee for the bug.
[Bug 169332] FILEOPEN XLSX Scaled images width is imported incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=169332 --- Comment #5 from Bayram Çiçek --- Created attachment 205369 --> https://bugs.documentfoundation.org/attachment.cgi?id=205369&action=edit texts does not match the columns (Excel vs Calc) Excel vs Calc: Text under the image is not in the same place when opening in Calc. Can we say, Not only the image widths, but also the text widths are not the same in both applications? -- You are receiving this mail because: You are the assignee for the bug.
[Bug 169332] FILEOPEN XLSX Scaled images width is imported incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=169332 --- Comment #4 from Bayram Çiçek --- Created attachment 205368 --> https://bugs.documentfoundation.org/attachment.cgi?id=205368&action=edit Excel, print preview in different zoom Excel: on the workbook view, different zoom levels change the width of the image. 12.93cm (110%) vs 12.86cm (120%) -- You are receiving this mail because: You are the assignee for the bug.
[Bug 169332] FILEOPEN XLSX Scaled images width is imported incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=169332 Bayram Çiçek changed: What|Removed |Added CC||[email protected] --- Comment #3 from Bayram Çiçek --- Created attachment 205367 --> https://bugs.documentfoundation.org/attachment.cgi?id=205367&action=edit different zoom levels on Excel Excel: Different zoom levels (190% vs 110%) has different text alignment under the image. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 169332] FILEOPEN XLSX Scaled images width is imported incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=169332 Buovjaga changed: What|Removed |Added Keywords||filter:xlsx -- You are receiving this mail because: You are the assignee for the bug.
[Bug 169332] FILEOPEN XLSX Scaled images width is imported incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=169332 jcline changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 -- You are receiving this mail because: You are the assignee for the bug.
[Bug 169332] FILEOPEN XLSX Scaled images width is imported incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=169332 --- Comment #2 from jcline --- I can reproduce in Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 620(Build:0) CPU threads: 32; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded -- You are receiving this mail because: You are the assignee for the bug.
[Bug 169332] FILEOPEN XLSX Scaled images width is imported incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=169332 Gabor Kelemen (Collabora) changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=16 ||9333 -- You are receiving this mail because: You are the assignee for the bug.
[Bug 169332] FILEOPEN XLSX Scaled images width is imported incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=169332 Gabor Kelemen (Collabora) changed: What|Removed |Added Version|26.2.0.0 alpha0+ master |4.0 all versions -- You are receiving this mail because: You are the assignee for the bug.
[Bug 169332] FILEOPEN XLSX Scaled images width is imported incorrectly
https://bugs.documentfoundation.org/show_bug.cgi?id=169332 --- Comment #1 from Gabor Kelemen (Collabora) --- Created attachment 203810 --> https://bugs.documentfoundation.org/attachment.cgi?id=203810&action=edit The example file in Excel and Calc side by side -- You are receiving this mail because: You are the assignee for the bug.
