Issue 123809 - Spreadsheet with hyperlink "file:///../" crashes when saving in *.xls format
Summary: Spreadsheet with hyperlink "file:///../" crashes when saving in *.xls format
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: 4.0.0
Hardware: PC Windows 7
: P3 Major (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: regression
Depends on:
Reported: 2013-12-05 12:10 UTC by Goran M.
Modified: 2018-03-20 13:55 UTC (History)
5 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.5
Developer Difficulty: ---

Spreadsheet with hyperlink that crashes when saving in *.xls format (7.70 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-12-05 12:10 UTC, Goran M.
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Goran M. 2013-12-05 12:10:48 UTC
Created attachment 82046 [details]
Spreadsheet with hyperlink that crashes when saving in *.xls format

Members of our development team (4-5 people) used to update one specific spreadsheet in xls format on a daily to weekly basis for several years using current versions of OpenOffice Calc.
Several months ago we started to experience Calc crashes whenever someone tried to save new modifications to the file.
It turned out that the cause was one cell with oddly formed hyperlink. When this cell was deleted, saving became possible again.

Here are steps for reproducing the issue:
1) Start OpenOffice Calc
2) Create new blank spreadsheet (menu: File -> New -> Spreadsheet)
3) Open Hyperlink dialog (menu: Insert -> Hyperlink)
4) Fill "Path" field with (omit quotes): "file:///../", then click "Apply" and "Close"
5) Open "Save As" dialog (menu: File -> Save As)
6) Save spreadsheet in "Microsoft Excel 97/2000/XP (*.xls)" format by selecting the format in "Save as type" and click "Save" button
7) If prompted with question "This document may contain formatting or content that cannot be saved in the ... file format. Do you want to save ... anyway?" click "Keep Current Format" button.
8) OpenOffice crashes.

There is an *.ods spreadsheet with steps 1-4 applied attached to this bug report.

Our OpenOffice version is 4.0.1 on Windows 7 platform.

We didn't investigate this any further - for instance how this hyperlink ended up there, what other variations in link format also crash the Calc or what other versions or platforms are affected with the issue.
Comment 1 Edwin Sharp 2013-12-05 16:34:55 UTC
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1543812
Win 7
Comment 2 Rainer Bielefeld 2014-04-16 11:32:17 UTC
Version has been modified erroneous

Was still ok with AOO 3.4.1.

Already Reproducible with server installation of "AOO 4.0.0 Final – German UI / German locale [AOO400m3(Build:9702) - Rev. 1503704 2013-07-16 14:54:56 (Di, 16 Jul 2013)]" on German German WIN7 Home Premium (64bit)", Common 4.0-dev User Profiler, so REGRESSION
Comment 3 Oleksandr 2018-03-20 13:32:38 UTC
Still affecting AOO415m1(Build:9789)  -  Rev. 1817496
2017-12-11 17:25
Comment 4 Matthias Seidel 2018-03-20 13:55:59 UTC
Confirmed on Windows 10 (64-bit) with AOO415m1(Build:9789) - Rev. 1817496