Bug 130692 - Strange issue on clean spreadsheet with open xls
Summary: Strange issue on clean spreadsheet with open xls
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-02-15 19:23 UTC by Christian Schmitz
Modified: 2020-05-13 14:29 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Currency Reserves of central bank of Argentine (1.55 MB, application/vnd.ms-excel)
2020-02-15 19:26 UTC, Christian Schmitz
Details
Currency reserves at start and end of determined years (17.79 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-02-15 19:28 UTC, Christian Schmitz
Details
Screenshot with the bug (124.38 KB, image/png)
2020-02-15 19:29 UTC, Christian Schmitz
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Christian Schmitz 2020-02-15 19:23:51 UTC
Description:
The problem ocurr when i open 2 documents ( for separated ) of course.
When i open bcra_reservas_panhis.xls affect the vision of calc on OTHER FILE

In the other file the problem is that the rectangular box dont follow to the cursor and blue marks of the sides.
As you can see in the attached photo, the blue marks point to E6 cell, on the top is showed the E6 content (and if i edit i will edit E6) but the rectangle box remain on C15 cell

Also the combination CTRL+wheel stop to work the zoom

Steps to Reproduce:
1.Open file BCRA reservas.ods
Wi see that All work fine the box follow the cursor

2.Open bcra_reservas_panhis.xls
3.Back to BCRA reservas.ods ( the first file)
4.The box dont follow the cursor and the ctrl+wheel not zoom
5.If you change zoom or other thing the box is updated.
6.Close bcra_reservas_panhis.xls
7.The zoom become to work, the box follow the cursor again.
8.if repeat step 2 the problem appear again

Actual Results:
explained on 4.

Expected Results:
The problem was explained on 7.
But i can add that expected is that one bad file (or bad import) must do not affect the others working files.


Reproducible: Always


User Profile Reset: No



Additional Info:
The bcra_reservas_panhis.xls have macros ( i have disabled) whatever the source is thrust, because is the Central Bank of Argentine (some like the Federal Reserve of Argentine)
Comment 1 Christian Schmitz 2020-02-15 19:26:34 UTC
Created attachment 157899 [details]
Currency Reserves of central bank of Argentine

Have a macros, but the source is the oficial bank.
Comment 2 Christian Schmitz 2020-02-15 19:28:27 UTC
Created attachment 157900 [details]
Currency reserves at start and end of determined years
Comment 3 Christian Schmitz 2020-02-15 19:29:13 UTC
Created attachment 157901 [details]
Screenshot with the bug
Comment 4 raal 2020-02-17 22:07:06 UTC
I cannot reproduce with Verze: 6.4.0.3
ID sestavení: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8
Vlákna CPU: 4; OS: Linux 4.15; Vykreslování UI: výchozí; VCL: gtk3;
Comment 5 Christian Schmitz 2020-02-18 11:16:40 UTC
I am using trinity under opensuse tumbleweed. What you need? A video, a special test? One debug or log?
Comment 6 Buovjaga 2020-05-10 11:50:51 UTC
No problem for me. Unrelated issue is that opening the .xls starts leaking memory due to a very recent regression, but it affects many other files.

Arch Linux 64-bit
Version: 7.0.0.0.alpha1+
Build ID: e622420c0aa8116294e85c076ff2d8fc6131595f
CPU threads: 8; OS: Linux 5.6; UI render: default; VCL: gtk3; 
Locale: en-US (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 10 May 2020
Comment 7 Xisco Faulí 2020-05-11 14:31:13 UTC
Thanks for reporting this issue.
Could you please paste the info from Help - about LibreOffice ?

I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' once the information has been provided
Comment 8 Xisco Faulí 2020-05-11 14:48:40 UTC
OTOH, Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ?
Comment 9 Christian Schmitz 2020-05-12 15:21:49 UTC
Dear I was out because covid19.
Today i will update the tumbleweed and in few days give an answer.
Thanks you.
Comment 10 QA Administrators 2020-05-13 03:52:03 UTC Comment hidden (obsolete)
Comment 11 Xisco Faulí 2020-05-13 12:21:21 UTC
(In reply to Christian Schmitz from comment #9)
> Dear I was out because covid19.
> Today i will update the tumbleweed and in few days give an answer.
> Thanks you.

Ok, come back to us when you have an update.
Stay safe
Comment 12 Christian Schmitz 2020-05-13 14:26:16 UTC
Dear 
Seem like fixed now. Is working after update. I think that you can close the bug.
Best Regards, and thanks you.

Christian Schmitz
Comment 13 Xisco Faulí 2020-05-13 14:29:59 UTC
(In reply to Christian Schmitz from comment #12)
> Dear 
> Seem like fixed now. Is working after update. I think that you can close the
> bug.
> Best Regards, and thanks you.
> 
> Christian Schmitz

Glad to hear. closing as RESOLVED WORKSFORME