Download it now!
Bug 91979 - FILEOPEN: on xls all image on one cell
Summary: FILEOPEN: on xls all image on one cell
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) beta1
Hardware: All All
: high major
Assignee: Mike Kaganski
Whiteboard: target:5.1.0
Keywords: bisected, regression
Depends on:
Reported: 2015-06-10 09:16 UTC by Mikhail
Modified: 2016-10-25 19:17 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

for example (8.77 MB, application/x-7z-compressed)
2015-06-10 09:16 UTC, Mikhail
screenshot (69.20 KB, image/jpeg)
2015-06-10 13:33 UTC, Mikhail
Minimal testcase (15.96 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-11-05 10:46 UTC, Mike Kaganski

Note You need to log in before you can comment on or make changes to this bug.
Description Mikhail 2015-06-10 09:16:28 UTC
Created attachment 116437 [details]
for example

In attachment on ~272 row all image in one cell
on ms excell and open office 4.1.1 file open is norm 
file save from other software in compatibility ms office 5.0/95

На русском
Во вложении, на 272 строке все изображения находятся один под другим. В ms офисе и open office 4.1.1 открывается нормально. Файл сохранен из 1С 7.7, т.е. файл открывается в режиме совместимости с office 5.0/95...
Comment 1 Cor Nouws 2015-06-10 12:39:05 UTC
Hi Mikhail,

This looks as bug 67712. When I open in 5.0.0beta1, it works fine.
So I close as duplicate. If I'm wrong, please explain and reopen.

Thanks for filing the issue!

*** This bug has been marked as a duplicate of bug 67712 ***
Comment 2 Mikhail 2015-06-10 13:32:45 UTC
Hi Cor Nouws,

I'm install dev version, and this bug it is possible to repeat
I'm load screenshot in attach
Comment 3 Mikhail 2015-06-10 13:33:19 UTC
Created attachment 116439 [details]
Comment 4 Mike Kaganski 2015-06-10 14:24:00 UTC
Reproducible with Version:
Build ID: 1499425d09a85fea22a1d7087d605b401c93a6dd
Locale: ru-RU (ru_RU)
under Win7x64.

All the images from rows below 272 are stacked in row 272.
Comment 5 Mike Kaganski 2015-06-11 00:50:00 UTC
Not reproducible with versions under Win7x64
Reproducible starting with version -> regression
Also reproducible with under Ubuntu 14.04
Adjusting priority accordingly
Comment 6 Cor Nouws 2015-06-22 10:48:43 UTC
Yes I didn't check the issue properly. Apologies,
Comment 7 Mike Kaganski 2015-11-05 10:46:47 UTC
Created attachment 120282 [details]
Minimal testcase

1. This bug is not with import; it happens as well with XLSX, with ODS, and with new sheet.

2. It isn't limited to raster images; it may be easily reproduced:
a. Create a new spreadsheet;
b. Draw a rectangle (Show Draw Functions -> Rectangle), edit its Position and Size to set Y position to, say, 3000 cm, note that it is located near row 6650;
c. Navigate to cell A1 and save and close file;
d. Reopen it and use Navigator (F5) to navigate to row 6650; see that it's not there; navigate to row 1930 and see it's there. (It is displayed at Position Y = 870.48)

3. You may use attached testcase to see the bug behaviour.
Double-clicking the Picture 836 entry in Navigator in attached file navigates to correct row 5925 (but the picture isn't shown there, and the selection information in the status bar shows coordinates of its current position 2.28 / 870.48). Navigating to row 1930 and clicking on the object makes status bar to show "correct" coordinates (where it _should_ be: 2.28 / 2674.70).

4. It is "worked around" by using zoom; any zoom on rows >=1930 brings all misplaced objects to place.

5. Bisection tells that it's caused by
commit c4e649f0cd013e86adbd794859bcc3cb9ee3aa61
Author: Noel Power <>
Date:   Tue Nov 27 17:56:33 2012 +0000

    Sync draw object to calc grid for better alignment when zooming

Taking and working on a fix.
Comment 8 Mike Kaganski 2015-11-06 00:03:37 UTC
void ScDrawView::SyncForGrid( SdrObject* pObj )

pViewData->GetScrPos() seems to give max value of 32767, which translate to 866960 returned by PixelToLogic.
Comment 9 Mike Kaganski 2015-11-06 08:05:12 UTC
A patch has been posted to gerrit for review:
Comment 10 Commit Notification 2015-11-10 11:59:48 UTC
Mike Kaganski committed a patch related to this issue.
It has been pushed to "master":

tdf#91979: ScViewData::GetScrPos(): remove coordinates limit of 32767

It will be available in 5.1.0.

The patch should be included in the daily builds available at in the next 24-48 hours. More
information about daily builds can be found at:

Affected users are encouraged to test the fix and report feedback.
Comment 11 Xisco Faulí 2016-01-13 14:51:13 UTC
This isssue is no longer reproducible in

Build ID: 451f359023c681a91dbb232a5ea3fffb12c964bc
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; 
TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2015-12-27_07:49:03
Locale: es-ES (es_ES)

Thus, close this issue a RESOLVED FIXED