Bug 104943 - Calc says that an empty file... has links to other files.
Summary: Calc says that an empty file... has links to other files.
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.2.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-12-27 17:42 UTC by Ganton
Modified: 2016-12-30 17:06 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
When opening this file: Calc asks you about updating links that really shouldn't exist. (63.09 KB, application/vnd.oasis.opendocument.spreadsheet-flat-xml)
2016-12-27 17:42 UTC, Ganton
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Ganton 2016-12-27 17:42:45 UTC
Created attachment 129966 [details]
When opening this file: Calc asks you about updating links that really shouldn't exist.

Hi!

DESCRIPTION:
Calc says that an empty file... has links to other files.

STEPS TO REPRODUCE:
Open the attached file, it asks you about updating links that really shouldn't exist. 

ADDITIONAL INFORMATION:
You can try opening the attached file, adding another sheet, deleting the old sheet (so the file should be clean), closing the file, opening the file again... and it keeps you asking about updating links that really shouldn't exist. 

You can try saving the file in odt format. Then it doesn't ask about updating links (!).

Thanks for Calc!
Comment 1 Julien Nabet 2016-12-27 18:33:14 UTC
On pc Debian x86-64 with master sources updated today, I could reproduce this.

It seems LO can't see an hidden sheet named:
'file:///home/julien/to/tmp/1/DDI.fods/DDI.fods/DDI.fods/DDI.fods/DDI.fods/DDI.fods/DDI.fods/DDI.fods/DDI.fods/DDI.fods/m/amf/X%C3%A0bia/DDI/quadern%20del%20professor%20de%20DDI%202016-2017.fods/SSII/quadern%20del%20professor%20d'SSII%202016-2017.fods'#Actituds

But how did you create this file?
Comment 2 Ganton 2016-12-27 19:24:32 UTC
> But how did you create this file?

It was a prior Calc file where some sheets (with links) were removed, but Calc it still asked about updating links; all the sheets were removed, and still it asked about updating links.

Thanks for Calc!
Comment 3 Julien Nabet 2016-12-27 20:20:47 UTC
It seems the file is corrupted some way. The problem is the sheet name. The  config-item-map-entry part doesn't contain this sheet name.

Except if you know exactly how to reproduce this (original file + step by step process to get this corrupted file), I don't think it's possible to do anything here.

BTW, last stable LO version is 5.2.4
Comment 4 Ganton 2016-12-28 10:08:15 UTC
I can't provide the list of steps that were made to re-create the corrupt file :-(, I have only the corrupt file where the problem is shown when opening the file.
Comment 5 Julien Nabet 2016-12-28 11:12:54 UTC
(In reply to Ganton from comment #4)
> I can't provide the list of steps that were made to re-create the corrupt
> file :-(, I have only the corrupt file where the problem is shown when
> opening the file.

Thank your feedback. In this case, let's close this one.
Don't hesitate to reopen this tracker if you encounter again this problem and have step by step process to reproduce this kind of file.
Comment 6 Ganton 2016-12-30 17:06:09 UTC
Hi!

Anyway Calc should tell users that the external links couldn't be opened :-? (in this case because the external file does not exist). That way, the user would notice sooner that his spreadsheet got corrupted because in the screen they would see the (very strange) name of an inexistent file that (of course) could not be opened.

The sooner the user notices the problem, the sooner he can give more clues.

To investigate that I've created a new bug report: https://bugs.documentfoundation.org/show_bug.cgi?id=105006
Feel free to change anything.

Thanks for Calc!