Bug 127478 - Opening second Calc file while particular file is open always fails
Summary: Opening second Calc file while particular file is open always fails
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.1.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-09-10 14:44 UTC by Nadie Nada Nunca
Modified: 2020-04-24 11:29 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Convocatorias.ods (44.62 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-09-24 22:11 UTC, Nadie Nada Nunca
Details
Simple .ods file showing the bug (8.99 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-10-25 19:29 UTC, Nadie Nada Nunca
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Nadie Nada Nunca 2019-09-10 14:44:49 UTC
Description:
Whenever I open a particular Calc file created by an earlier version of LibreOffice (the format is ODS but the icon is different), trying to open another Calc file externally (i.e. by double-clicking it in Windows Explorer) always fails until I close the original file. Only then the second file opens but warns me to restore the recovery data for the previous file. (There is nothing to recover; the previous file is fine.)


Steps to Reproduce:
1. Open an ODS file created with an earlier version of LibreOffice.
2. In Windows Explorer, double click on a different ODS file created with a newer version.

Actual Results:
The second file doesn't open until I close the first file. Then it opens but asks me to restore the recovery data for the previous file as if there had been a failure on saving.

Expected Results:
I expected the second file to open in a new window normally, as it worked in previous versions of the software.


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 m_a_riosv 2019-09-11 12:02:59 UTC
I can't repro.
Version: 6.3.1.2 (x64)
Build ID: b79626edf0065ac373bd1df5c28bd630b4424273
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US
Calc: CL

Please test with a clean profile Menu/Help/Restart in Safe Mode
Comment 2 Nadie Nada Nunca 2019-09-11 13:58:36 UTC
Is there a way to see / set the particular file format for these files? It would help. I don't want to share the files themselves but I could try to attach some dummy data. 

Both files are ODS but they have different icons in Windows. The older one has a colorless icon with a green dot, the newer one has a similar icon but it's all green.
Comment 3 QA Administrators 2019-09-12 02:52:04 UTC Comment hidden (obsolete)
Comment 4 Nadie Nada Nunca 2019-09-12 18:18:49 UTC
Restarting in Safe Mode doesn't fix it. I'll try resetting the profile completely.
Comment 5 m_a_riosv 2019-09-12 23:34:36 UTC
Test if there is a .~lock.filename.ods# file where the file with the issue is, before open the file. This file is create for LibreOffice when a file is opened, and remains when LibreOffice close or crash unexpectedly.
Comment 6 Nadie Nada Nunca 2019-09-13 14:27:49 UTC
There isn't.
Comment 7 Nadie Nada Nunca 2019-09-13 14:29:49 UTC
UPDATE: resetting the entire user profile doesn't work either.
Comment 8 Buovjaga 2019-09-15 12:21:01 UTC
If it's only with this particular file, you need to attach the file here, so we can test it.

Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the document.
Comment 9 Nadie Nada Nunca 2019-09-24 22:11:14 UTC
Created attachment 154462 [details]
Convocatorias.ods
Comment 10 Nadie Nada Nunca 2019-09-24 22:13:53 UTC
OK, I attached the file (I had written a comment previously but it didn't get saved so I'm writing it again, sorry about potential duplicates). 

I've just discovered that the same problem occurs with a different file which is also a regular .ods file, which I cannot attach because it contains confidential data. 

In trying to reproduce the bug, please remember that it only happens when opening the second file EXTERNALLY as opposed to opening it through the Calc File menu.
Comment 11 m_a_riosv 2019-09-25 00:30:08 UTC
I can't repro.
Version: 6.3.2.2 (x64)
Build ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US Calc: threaded
Comment 12 Nadie Nada Nunca 2019-10-25 19:27:55 UTC
It's happening again with a fresh file I just created with LO 6.3.2. I created a new .ods file, inserted a couple headers and a date, saved it, then went to XYplorer and double clicked on a different LibreOffice file (an .odt, not even a spreadsheet!) and got the same result: the file doesn't open until I manually close the Calc window, then complains about recovery data.
Comment 13 Nadie Nada Nunca 2019-10-25 19:29:02 UTC
Created attachment 155314 [details]
Simple .ods file showing the bug

This is the freshly created file.
Comment 14 Buovjaga 2019-10-26 08:33:13 UTC
(In reply to Nadie Nada Nunca from comment #12)
> It's happening again with a fresh file I just created with LO 6.3.2. I
> created a new .ods file, inserted a couple headers and a date, saved it,
> then went to XYplorer and double clicked on a different LibreOffice file (an
> .odt, not even a spreadsheet!) and got the same result: the file doesn't
> open until I manually close the Calc window, then complains about recovery
> data.

Now you revealed you are using a 3rd party file explorer: https://www.xyplorer.com/

Does the problem occur with the normal Windows file explorer?
Comment 15 Nadie Nada Nunca 2019-10-26 12:02:34 UTC
Yes, it does. 

Double clicking on a file in XYplorer is the same as doing it in any other file explorer. It makes no difference. But I had tried it in Windows Explorer before and I tried again this time just to make sure.
Comment 16 Buovjaga 2019-10-26 13:23:43 UTC
No problem for me anyway.

For completeness, please copy and paste here the contents of your Help - About. This allows us to know more about your system.

Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the information.

Version: 6.3.2.2 (x64)
Build ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: fi-FI (fi_FI); UI-Language: en-US
Calc: threaded
Comment 17 QA Administrators 2020-04-24 03:36:53 UTC Comment hidden (obsolete)
Comment 18 Nadie Nada Nunca 2020-04-24 11:25:56 UTC
Sorry! Life came up. 

Help | About can't be copied and pasted, only typed by hand, but in any case I think what the poster meant was the contents of Help | Various information, which offers the following data as of today: 

Various Information

XYplorer: 20.90.0000 (Pro Edition - Lifetime License Pro)
Loaded in: 36 880 ms at 24/04/2020 08:22:52
Uptime: 44 secs    Runtime: 6.00.9815
Memory Usage: 32 932 KB, Virtual Memory Size: 18 272 KB

OS: Windows 8.1 Professional, 64-bit, Build 9600
OS Uptime: 3 days, 23 hrs, 29 mins, 31 secs
Time Zone: Argentina Standard Time, Argentina Daylight Time
UTC Offset: --03:00
User Role: Admin
Themes: Yes (Aero)    RealSystem32: Yes

System Locale ID: 11274 (es-AR)
Thread Locale ID: 11274 (es-AR)
Default ANSI Code Page: 1252  (ANSI - Latin I)
Active ANSI Code Page: 1252  (ANSI - Latin I)
Default OEM code page: 850   (OEM - Multilingual Latin I)
Active OEM Code Page: 850   (OEM - Multilingual Latin I)
Is DBCS Code Page: No
Main Contents Font: Trebuchet MS 9,75

DblClick Time: 620 ms
Screen: 1920x1080, 1/1 (Primary), Virtual: (0, 0) - (1920, 1080), Work: (0, 28) - (1920, 1018)
Screen DPI: 96 (100%), twx: 15, stretch: 1
Screen Color Depth: 32
DPI awareness: Per monitor
UseDPIAwareIconSizes: No, Yes
Icon Size: Small=16, Large=32
Icon Size Controls: Small=16, Large=32
Icon Size Recommended: Small=16, Large=32

Command Line: 
Command Normalized: 

App:              	C:\bin\file\XYplorer\XYplorer.exe
Ini File:         	C:\Users\bit\AppData\Roaming\XYplorer\XYplorer.ini
App Data Path:    	C:\Users\bit\AppData\Roaming\XYplorer\
Pane 1 Data Path: 	C:\Users\bit\AppData\Roaming\XYplorer\Panes\§1§_WIPs\
Pane 2 Data Path: 	C:\Users\bit\AppData\Roaming\XYplorer\Panes\§2§_WIPs\
Catalogs Path:    	C:\Users\bit\AppData\Roaming\XYplorer\Catalogs\
Icons Path:       	C:\Users\bit\AppData\Roaming\XYplorer\Icons\
New Items Path:   	C:\Users\bit\AppData\Roaming\XYplorer\NewItems\
Scripts Path:     	C:\Users\bit\AppData\Roaming\XYplorer\Scripts\
Thumbs Cache:     	C:\Users\bit\AppData\Roaming\XYplorer\Thumbnails\
Catalog:          	C:\Users\bit\AppData\Roaming\XYplorer\Catalogs\catalog.dat
Tags Database:    	C:\Users\bit\AppData\Roaming\XYplorer\tag.dat

Language Support:	8.120
Language:     	No language loaded
Comment 19 Nadie Nada Nunca 2020-04-24 11:28:29 UTC
Ah, my bad! You meant LO's Help | About. The problem appears to be mostly solved in the new version of LibreOffice, although I get this error intermittently now. I can't reliably reproduce it anymore.
Comment 20 Buovjaga 2020-04-24 11:29:44 UTC
Ok, let's close.

For posterity, the reply I was writing:
(In reply to Nadie Nada Nunca from comment #18)
> Help | About can't be copied and pasted, only typed by hand

It can be copied. In version 6.4, left-click the text once and all will be selected. Press Ctrl-C to copy.

In master (what will become 7.0), the About dialog has just been redesigned and there is a button for copying.