https://bugs.documentfoundation.org/show_bug.cgi?id=151878
Bug ID: 151878
Summary: LibreCalc buttons change color, horizontal lines from
the top and bottoms of buttons radiate across a
background image and buttons briefly appear and
disappear in the wrong place.
Product: LibreOffice
Version: 7.3.6.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
We use Calc for transcribing weather data from hand-written Navy logs for a
citizen science project. We load a scanned page of the log as a background
image and enter the data into Calc. We then generate the data in an XML format
and move to the the next log page image.
1. On the Log Page sheet, We have several "buttons" near the top of Column A to
run several macros, like getting an image, verifying data, etc. I have several
white lines that radiate horizontally across the image. These lines correspond
with the tops and bottoms of some or all of the buttons.
2. Normally, cell C4 is at the top of the Calc window, so the buttons are not
visible. When I first use the spreadsheet, or when I go to the Log Page sheet
from another sheet, and when I first use a macro such as CopyDown or UpAndOver,
there is a brief flash when the buttons appear and disappear. They don't do
this until the spreadsheet is re-opened or I move to another sheet in the
spreadsheet and back again.
e> There are two buttons on the Setup sheet. These are used to verify the
transcriber's directories. Sometimes these buttons go black, and they stay
black until I replace them with buttons from another spreadsheet. The size of
the spreadsheet increases by the size of the background image.
$ ls -l Om*ods
-rw-r--rw-+ 1 Michael None 13326285 Nov 3 00:28 Omaha_1872-1888.ods
$ ls -l Om*ods
-rw-r--rw-+ 1 Michael None 26204915 Nov 3 15:30 Omaha_1872-1888.ods
4. On a couple of spreadsheets, the buttons turn a mottled grey color. I am
unable to replace these buttons with ones from other spreadsheets. I replace
the buttons, save and re-open the spreadsheet, and the buttons are mottled
grey. I can delete the Setup Page and replace with with one from another
spreadsheet, and the buttons are still mottled grey after the spreadsheet is
saved and re-opened.
One of our moderators can get this spreadsheet and replace the buttons, and
they will remain OK for other users. However, if I open her fixed copy, the
buttons go mottled grey for me when I save and re-open it.
I had an old version of Calc on a PC downstairs: 5.3.3. This behavior did not
occur with this version of Calc. I cannot remember which version I was using
when I first noticed these problems.
I look at the Setup sheet only every few days or so, so I am not sure when the
buttons on that sheet go black. They go for weeks with the orange color and
then one day, when I check, they will be black.
These behaviors are not seen by some or all of our other transcribers.
The lines and the occasional flash of the buttons on the Log Page sheet, as
well as the black buttons on the Setup Sheet are irritating. I can easily
replace the black buttons. The mottled grey buttons on the Setup sheet on one
of our 28 spreadsheets is annoying, but I can get one of our moderators to fix
them for other users.
I have included three spreadsheets, a four second video file, Shortcut keys, an
image file and a Readme file to illustrate the behaviors I see. They are in a
compressed file. In case this compressed file is too large (44 Mb) to attach,
here is a link to it.
https://drive.google.com/file/d/1u6N8X9Jav_NQJUiMUClk-gFXVWyDYToM/view?usp=share_link
Steps to Reproduce:
1. For the white lines: load an image.
2. For the flash of buttons, go to another sheet, Run Alt-J (GoToAMStart),
enter something, and then run Alt-[ (CopyDOwn)
3. I don't know what I've done to cause the buttons to go black, or mottled
grey.
Actual Results:
I get white lines and a flash of buttons on the Log Page sheet and discolored
buttons on the Setup sheet.
Expected Results:
The buttons on the Setup page should not go mottled grey or black. There should
be no white lines or a flash of buttons on the Log Page.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.3.6.2 (x64) / LibreOffice Community
Build ID: c28ca90fd6e1a19e189fc16c05f8f8924961e12e
CPU threads: 2; OS: Windows 10.0 Build 19044; UI render: default; VCL: win
Locale: en-CA (en_CA); UI: en-US
Calc: threaded
Device name AZC
Processor Intel(R) Pentium(R) CPU 2127U @ 1.90GHz 1.90 GHz
Installed RAM 8.00 GB (7.89 GB usable)
Device ID 43C005FD-F30B-4F98-A0E5-17357AF05DBA
Product ID 00326-10000-00000-AA422
System type 64-bit operating system, x64-based processor
Pen and touch No pen or touch input is available for this display
Edition Windows 10 Home
Version 21H2
Installed on 2020-11-26
OS build 19044.2130
Experience Windows Feature Experience Pack 120.2212.4180.0
--
You are receiving this mail because:
You are the assignee for the bug.
