Bug 159749 - Intermittently, MacBook Pro trackpad "tap to click" becomes unresponsive (left click) when editing Excel files in LO Calc.
Summary: Intermittently, MacBook Pro trackpad "tap to click" becomes unresponsive (lef...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.0.3 release
Hardware: Other macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-02-16 22:38 UTC by daniels.lewis652
Modified: 2024-11-26 09:59 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description daniels.lewis652 2024-02-16 22:38:36 UTC
Description:
Intermittently, MacBook Pro trackpad "tap to click" becomes unresponsive (left click) in LO Calc.
Have updated LO and run MBP in Safe Mode.

Steps to Reproduce:
1.Work in a Calc spreadsheet for more than 15 min.
2.
3.

Actual Results:
Intermittently, "tap to click" on trackpad becomes unresponsive in cells and worksheet.

Expected Results:
"Tap to click" should always be responsive.


Reproducible: Sometimes


User Profile Reset: No

Additional Info:
Work-arounds:
Close Calc and reopen.
In system settings, turn "Tap to click" off and on again.

https://git.libreoffice.org/core/+/e19e193f88cd6c0525a17fb7a176ed8e6a3e2aa1﷒0
Comment 1 Stéphane Guillou (stragu) 2024-03-23 12:01:35 UTC
(In reply to daniels.lewis652 from comment #0)
> Have updated LO and run MBP in Safe Mode.
Which version have you updated to? Can you please test the latest 24.2?

Once updated, please test again and paste here the version information copied from LibreOffice > About.

Please also check that your macOS is up to date.
Comment 2 Stéphane Guillou (stragu) 2024-03-25 13:47:13 UTC
(In reply to Stéphane Guillou (stragu) from comment #1)
> Which version have you updated to?
As you linked to e19e193f88cd6c0525a17fb7a176ed8e6a3e2aa1, I assume that was 7.6.4.
Comment 3 QA Administrators 2024-09-27 03:16:53 UTC Comment hidden (obsolete)
Comment 4 daniels.lewis652 2024-09-30 23:47:58 UTC
(In reply to Stéphane Guillou (stragu) from comment #1)
> (In reply to daniels.lewis652 from comment #0)
> > Have updated LO and run MBP in Safe Mode.
> Which version have you updated to? Can you please test the latest 24.2?
> 
> Once updated, please test again and paste here the version information
> copied from LibreOffice > About.
> 
> Please also check that your macOS is up to date.

Current LO version 7.6.4.1

What do you mean by testing 24.2?
Comment 5 daniels.lewis652 2024-09-30 23:53:31 UTC
(In reply to Stéphane Guillou (stragu) from comment #1)
> (In reply to daniels.lewis652 from comment #0)
> > Have updated LO and run MBP in Safe Mode.
> Which version have you updated to? Can you please test the latest 24.2?
> 
> Once updated, please test again and paste here the version information
> copied from LibreOffice > About.
> 
> Please also check that your macOS is up to date.

LO Version 7.6.4.1
Build e19e193f88cd6c0525a17fb7a176ed8e6a3e2aa1

MacBook Pro M1 chip is up-to-date with Sonoma 14.7.
Comment 6 Dennis Roczek 2024-10-01 11:32:42 UTC
(In reply to daniels.lewis652 from comment #4)
> (In reply to Stéphane Guillou (stragu) from comment #1)
> > (In reply to daniels.lewis652 from comment #0)
> > > Have updated LO and run MBP in Safe Mode.
> > Which version have you updated to? Can you please test the latest 24.2?
> > 
> > Once updated, please test again and paste here the version information
> > copied from LibreOffice > About.
> > 
> > Please also check that your macOS is up to date.
> 
> Current LO version 7.6.4.1
> 
> What do you mean by testing 24.2?

Please go to
https://www.libreoffice.org/download/download-libreoffice/
and download the newest version.

the newest version is 24.8.
(the released versions were 7.4, 7.5, 7.6, 24.2, 24.8)
Comment 7 daniels.lewis652 2024-10-06 16:11:52 UTC
(In reply to Dennis Roczek from comment #6)
> (In reply to daniels.lewis652 from comment #4)
> > (In reply to Stéphane Guillou (stragu) from comment #1)
> > > (In reply to daniels.lewis652 from comment #0)
> > > > Have updated LO and run MBP in Safe Mode.
> > > Which version have you updated to? Can you please test the latest 24.2?
> > > 
> > > Once updated, please test again and paste here the version information
> > > copied from LibreOffice > About.
> > > 
> > > Please also check that your macOS is up to date.
> > 
> > Current LO version 7.6.4.1
> > 
> > What do you mean by testing 24.2?
> 
> Please go to
> https://www.libreoffice.org/download/download-libreoffice/
> and download the newest version.
> 
> the newest version is 24.8.
> (the released versions were 7.4, 7.5, 7.6, 24.2, 24.8)

I have now installed LO 24.8.2.1 and am testing it. It will take me about a month to determine if the problem still exists.
Comment 8 Dennis Roczek 2024-10-06 16:17:32 UTC
Bring back the earliest affected version. If it is a regression, we might need this information for easier in-depth-analysis ("bibisecting"). Please do not change this field except knowing the earliest affected version (or at least recognized version). ;-)
Comment 9 daniels.lewis652 2024-10-15 21:59:19 UTC
2024-10-15

I do not know the earliest version affected but it seemed to be after updating my MacBook Pro to OS Sonoma.

The problem continues in LO Version 24.8.2.1.

Important comment:
The problem only occurs in one large workbook with many linked worksheets. Is there a way I can check for any file corruption in this workbook. Other than the problem cited, the workbook functions perfectly.
Comment 10 Dennis Roczek 2024-10-16 09:48:32 UTC
(In reply to daniels.lewis652 from comment #9)
> The problem only occurs in one large workbook with many linked worksheets.

Two questions: 

1.) Is it possible for you to share these files?
2.) Which file format / file extension does the files have? ods? xslx?
Comment 11 daniels.lewis652 2024-10-16 21:23:02 UTC
Responses:
1. The file contains confidential information and cannot be shared.
2. The file extension is xlsx. This is the extension I use for all my calc files, but only this large file has the issue.
Comment 12 Dennis Roczek 2024-10-17 07:35:51 UTC
(In reply to daniels.lewis652 from comment #11)
> 2. The file extension is xlsx. This is the extension I use for all my calc
> files, but only this large file has the issue.

Any specific reason to use the Microsoft format? Is it possible for you, to save the files to ods and trying to reproduce the problem?

As nobody can reproduce the problem until now, this is a bit of searching of the needle in the haystack...
Comment 13 Alex Thurgood 2024-10-17 08:27:48 UTC
@Lewis : You mention in comment 9 that you noticed the problem after updating to Sonoma.

I have encountered this problem too, but for me, it wasn't just in LibreOffice. 

The misbehaviour extended to more than just LibreOffice, for example, Firefox, and Chrome, MySQLWorkbench, Thunderbird, etc. As I rarely use any of the Apple standard GUI applications provided with the OS (other than Finder and Desktop), I can't say whether my problem extends also to those applications.

From the numerous reports out there on the internet, it would seem that people frequently have issues with the functionality of their mouse in macOS. Could this be such a case with your setup, or are all other apps behaving normally with regard to their mouse interaction ?
Comment 14 Alex Thurgood 2024-10-17 08:30:40 UTC
@Lewis: as an example of existing reports against macOS, see for example:

https://discussions.apple.com/thread/255121255?sortBy=rank
Comment 15 daniels.lewis652 2024-10-17 12:25:54 UTC
Alex,
I had checked that thread some time ago but my issue was only with LibreOffice Calc.
Thanks,
Lewis
Comment 16 daniels.lewis652 2024-10-17 12:28:54 UTC
(In reply to Dennis Roczek from comment #12)
> (In reply to daniels.lewis652 from comment #11)
> > 2. The file extension is xlsx. This is the extension I use for all my calc
> > files, but only this large file has the issue.
> 
> Any specific reason to use the Microsoft format? Is it possible for you, to
> save the files to ods and trying to reproduce the problem?
> 
> As nobody can reproduce the problem until now, this is a bit of searching of
> the needle in the haystack...

Dennis,

I will try the ods file version and see if that solves it.

Thank you,
Lewis Daniels
Comment 17 daniels.lewis652 2024-11-11 14:33:26 UTC
(In reply to Alex Thurgood from comment #13)
> @Lewis : You mention in comment 9 that you noticed the problem after
> updating to Sonoma.
> 
> I have encountered this problem too, but for me, it wasn't just in
> LibreOffice. 
> 
> The misbehaviour extended to more than just LibreOffice, for example,
> Firefox, and Chrome, MySQLWorkbench, Thunderbird, etc. As I rarely use any
> of the Apple standard GUI applications provided with the OS (other than
> Finder and Desktop), I can't say whether my problem extends also to those
> applications.
> 
> From the numerous reports out there on the internet, it would seem that
> people frequently have issues with the functionality of their mouse in
> macOS. Could this be such a case with your setup, or are all other apps
> behaving normally with regard to their mouse interaction ?

Alex,
Sorry for my delay in responding. No, other apps are working fine; problem only in LibreOffice Calc. Please see my reply to Dennis today.
Lewis
Comment 18 daniels.lewis652 2024-11-11 14:42:01 UTC
(In reply to daniels.lewis652 from comment #16)
> (In reply to Dennis Roczek from comment #12)
> > (In reply to daniels.lewis652 from comment #11)
> > > 2. The file extension is xlsx. This is the extension I use for all my calc
> > > files, but only this large file has the issue.
> > 
> > Any specific reason to use the Microsoft format? Is it possible for you, to
> > save the files to ods and trying to reproduce the problem?
> > 
> > As nobody can reproduce the problem until now, this is a bit of searching of
> > the needle in the haystack...
> 
> Dennis,
> 
> I will try the ods file version and see if that solves it.
> 
> Thank you,
> Lewis Daniels

Dennis,
I have now tried the Calc workbook saving it as an .ods file (instead of xlsx) and that seems to have solved the problem! Thank you very much for this suggestion. 

FYI, I found an app that can open and edit .ods files on Apple iOS devices - it is "Collabora Office."
Lewis
Comment 19 daniels.lewis652 2024-11-11 14:43:31 UTC Comment hidden (obsolete)
Comment 20 Alex Thurgood 2024-11-26 09:59:42 UTC
Trying to summarize the bug report so far from the latest information provided by the OP:

When editing an Excel file in Calc, tap to click via MacBook trackpad intermittently becomes unresponsive.

I'll change the title to reflect that.