Bug 155213 - with Windows startup booster "quickstart.exe" an *.odb file incl. password protected spreadsheet *.odt fails to open
Summary: with Windows startup booster "quickstart.exe" an *.odb file incl. password pr...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.5.3.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-05-09 11:38 UTC by HTK300
Modified: 2023-07-10 07:24 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
screenshot for quickstart at time of installing LO (30.07 KB, image/jpeg)
2023-05-09 11:39 UTC, HTK300
Details
screenshot when creating a new base.odb (42.92 KB, image/jpeg)
2023-05-09 11:40 UTC, HTK300
Details
screenshot to LO load error (19.05 KB, image/jpeg)
2023-07-10 07:21 UTC, HTK300
Details
screenshot (14.12 KB, image/jpeg)
2023-07-10 07:21 UTC, HTK300
Details
screenshot to error 2 (18.97 KB, image/jpeg)
2023-07-10 07:22 UTC, HTK300
Details
screenshot for entering a password (12.05 KB, image/jpeg)
2023-07-10 07:23 UTC, HTK300
Details

Note You need to log in before you can comment on or make changes to this bug.
Description HTK300 2023-05-09 11:38:01 UTC
Description:
when LibreOffice installs, it offers to install a startup enhancement that is being set in the StartUp folder. As in my bug Bug 152542 this sometimes causes in 90 percent to fail to open files that are password protected. So is here the case with a BASE file that has a spreadsheet embedded which had been password protectet. 

Steps to Reproduce:

1. install LibreOffice but opt-in and tick the option when asked "Load LibreOffice 7.x during system startup"
2. this will drop a shortcut named: quickstart.exe to your Windows startUp folder to boost LibreOffice loading times for large office files
2. create a generic spreadsheet with a table of 3 columns and 3 rows (being the records for the base file later on see step 7.) 
3. save the table (spreadsheet) but use a password protection via “Save as…"  save with password"
4. the following dialog will ask you to enter your new password twice
5. create a new database, but connect to an existing database (point with the browser to your earlier created spreadsheet)
6. now you may have to enter your password to be able to open that file and it will be put to the “Tables” tab
7. Save the new base-file.odb in the same folder next to your spreadsheet
8. have your computer restarted! to make sure quickstart.exe gets initialized via the shortcut from the Windows startup folder (from within the current user or all default users)
9. this is now the moment for what this bug is about: 
10. when Windows has completed its startup routine, a tiny white icon should be shown in the taskbar next to the clock. This indicates that quickstart has been loaded. If quickstart hasn’t been loaded and you open any LibreOffice file you may be shown a splash screen of “LibreOffice” 
11. jump to your folder with the new BASE.odb and spreadsheet that you created
12. open the BASE file then click on TABLES which should now ask you for the password that refers to your spreadsheet
13. make sure you enter the correct password
14. In my case the password wasn’t accepted even I had absolutely no mistake
15. By kicking out (ending by right click) the tiny little app quickstart from the task bar, and heading back to step 12 voilà it opens your BASE file
16. this proves that quickstart has an issue
17. If you try to find quickstart.exe from the Windows folder or the LibreOffice folder and have it run on your own then the password procedure above will work surprisingly at no error


Actual Results:
file error when opening files right after Windows startup has completed caused by the shortcut "quicksart.exe"

Expected Results:
quickstart.exe from the startup folder should open of office files especially initially afer windows has started.


Reproducible: Always


User Profile Reset: No

Additional Info:
If you close the tiny app called quickstart.exe and try to open any files again that had been failed to open, it will work fine then until next Windows boot. It is irrelevant whether the Office file you wish to open is password protected or not.
Comment 1 HTK300 2023-05-09 11:39:30 UTC
Created attachment 187166 [details]
screenshot for quickstart at time of installing LO
Comment 2 HTK300 2023-05-09 11:40:12 UTC
Created attachment 187167 [details]
screenshot when creating a new base.odb
Comment 3 HTK300 2023-05-09 18:00:53 UTC
the point I would like to emphasis is, that even the entered password for the spreadsheet being entered at the time of the database trying to open the spreadsheet, the connection to the spreadsheet fails, saying the password was incorrect. But, when closing the quickstart.exe then everything works fine with entering the correct password and then BASE can open the spreadsheet as a database. I also have an old Windows 8.1 32-Bit laptop, there is no such behavior, all works as supposed to.
Comment 4 HTK300 2023-05-28 15:39:55 UTC
HI,
I don't know what kind of additional Info your are requesting here. Perhaps it is relatdt to the Quickstart.exe. Well, I was told it was one published in order to have most of the office package being loaded right at the beginning of Windows starting it self up. I delivered then an enhanced time elapsed from the moment you double click an office document until it gets open to full. Nowadays I see that with the high performance CPU and perhaps 16GB of RAM there seems only a fraction of seconds difference between, starting an office file with or without the quckstart.exe being active or not.

But, for Laptops of older generations at 4 GB RAM and below 2 GHz it becomes a valuable factor having quickstart working in the background.
Only problem is, nowadays the first file to be opened fails to open. The only workaround is to have the quickstart.exe from the taskmenu be closed, go to startup folder and have it restarted.
Comment 5 Joseph Walton 2023-06-02 15:34:40 UTC
Hi, thank you for reporting the bug. 

Before I try to reproduce it, please could you confirm which version of Windows you are using?
Comment 6 HTK300 2023-07-07 11:07:43 UTC
Hi Joseph,
sorry for being late. Nowadays I am using 7.5.5.1 and it is still a problem. But this issue has been much disturbing me for a year or so, meaning many versions earlier may be affected.

feel free to ask further questions or explanations to my bug report, if it was difficult to comprehend.

regards,
Harry
Comment 7 QA Administrators 2023-07-08 03:15:49 UTC Comment hidden (obsolete)
Comment 8 HTK300 2023-07-10 07:21:27 UTC
Created attachment 188285 [details]
screenshot to LO load error
Comment 9 HTK300 2023-07-10 07:21:47 UTC
Created attachment 188286 [details]
screenshot
Comment 10 HTK300 2023-07-10 07:22:12 UTC
Created attachment 188287 [details]
screenshot to error 2
Comment 11 HTK300 2023-07-10 07:23:35 UTC
Created attachment 188288 [details]
screenshot for entering a password

BASE connecting to a CAC spreasdheet with a password
Comment 12 HTK300 2023-07-10 07:24:04 UTC
today, I received the error again, meaning it sometimes does not show up, only sometimes. Not sure this was related to the fact, that I had my computer on hybernation mode turned of last night.

So, what happened:
I have a LO BASE file, that connects to a SPREADSHEET which is password protected. With the quickstart.exe app that was active yesterday prior to the hybernation mode, it could not understand my correct password. As a work-around I closed/killed that tiny app called within the task manager, then had my BASE file start again, entered the correct password - it opened fine.

Then, I started the tiny app called quickstart.exe from the Startup folder, and it also opened my BASE file and accepted my correct password to the Spreadsheet


attached see the screen shots to the errors from the pop-up.