Bug 154516 - Multiple annoying "Nonexistent file" error windows pop up in LibreOffice when editing a XLS document with a wrong link to another document.
Summary: Multiple annoying "Nonexistent file" error windows pop up in LibreOffice when...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.2.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-03-31 13:58 UTC by Anton K.
Modified: 2024-03-05 18:48 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
example file (5.50 KB, application/vnd.ms-excel)
2023-03-31 23:47 UTC, Anton K.
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Anton K. 2023-03-31 13:58:18 UTC
Description:
I have an *.xls document with a cell where there is a link to another document on the samba server. For example:
=INDIRECT("'smb://192.168.0.5/fserver/docs/test.xls'#$sheet.$E$3")
Where Samba server is available but file test.xls does not exist.

Whenever I make any changes to the document, a "Nonexistent file" window pops up every time. Although the cell already displays an error: #REF!.
The appearance of these numerous windows with an error is a bug that makes it very difficult to work with the document.
This behavior definitely didn't exist before version 6.0.7.3, but it's already present in version 6.4.7.2.
Also it is in the current version 7.3.7.2.
Operating system Ubuntu 20.04 or Ubuntu 22.04


Steps to Reproduce:
1.Create a new spreadsheet in LibreOffice Calc.
2. Insert into any cell a formula with a link to a non-existent file on the samba server, for example:
=INDIRECT("'smb://192.168.0.5/fserver/docs/test.xls'#$sheet.$E$3")
Where the Samba server (192.168.0.5 in the example) should be available.
3. For any changes in the file (for example, editing other cells), multiple windows will appear with the error "Nonexistent file".

Actual Results:
For any changes in the file (for example, editing other cells), multiple windows will appear with the error "Nonexistent file".

Expected Results:
Show only #REF! error in the cell where the link is invalid.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Operating system Ubuntu 20.04 or Ubuntu 22.04
Comment 1 m_a_riosv 2023-03-31 21:32:45 UTC
Please attach a sample file.
Comment 2 Anton K. 2023-03-31 23:47:24 UTC
Created attachment 186383 [details]
example file

file for example
Comment 3 Anton K. 2023-03-31 23:51:23 UTC
(In reply to m.a.riosv from comment #1)
> Please attach a sample file.

Sample file is attached
Comment 4 QA Administrators 2023-04-01 03:23:40 UTC Comment hidden (obsolete)