copying down references to other cells turns text to UPPERCASE

users
#1

Hi list,

I found an annoying bug (or is it a feature?) in Calc. When I create a
new document in calc and fill column A in Sheet1 with text. Now I add
Sheet2 and put "=Sheet1.A1" in cell A1 of Sheet2. Everything behaves as
expected so far.

If I copy down A1 in Sheet2 up to A99 everything is fine too, but if I
copy it down until A100 or more everything turns UPPERCASE and I cannot
change it.

I'm using LO 5.1.3.2 at the moment, but I observed this behavior in
earlier versions too.

Am I doing something wrong or is this really a bug?

Thanks
Thomas

#2

Hi Thomas

Thomas Boehm wrote

I found an annoying bug (or is it a feature?) in Calc. When I create a
new document in calc and fill column A in Sheet1 with text. Now I add
Sheet2 and put "=Sheet1.A1" in cell A1 of Sheet2. Everything behaves as
expected so far.

If I copy down A1 in Sheet2 up to A99 everything is fine too, but if I
copy it down until A100 or more everything turns UPPERCASE and I cannot
change it.

I'm using LO 5.1.3.2 at the moment, but I observed this behavior in
earlier versions too.

Am I doing something wrong or is this really a bug?

It is indeed a bug!

A very similar problem has been reported
https://bugs.documentfoundation.org/show_bug.cgi?id=99753

Maybe you can open a new bug report with your description? (it doesn't seem
to be exactly the same and developers are very picky)

I can confirm it also occurs in version 5.1.3.2 x64 under Windows 7 Pro x64
(so it's not a Windows

Hope this helps
Pedro

#3

Can’t reproduce this in OSX El Capitan (10.11.4) with LO 5.0.4.2

Rob.

#4

I can't reproduce this in 5.1.3.2-6.6 on openSUSE.

I have interpreted the instructions as;
enter text "cat" into sheet1.A1
enter "=Sheet1.A1" into sheet2.A1
copy sheet2.A1 (Ctl c)
select sheet2.A1:sheet2.A120
paste (Ctl v)

I have also tried entering "cat" into Sheet1.A1:Sheet1.A120 and dragging sheet2.A1 down so that the references increment (=Sheet1.A1 =Sheet1.A2 =Sheet1.A3 etc.)

Steve

#5

Pedro wrote

I can confirm it also occurs in version 5.1.3.2 x64 under Windows 7 Pro
x64
<strike>
(so it's not a Windows
</strike>

I meant it's not a Linux only problem.

Interestingly the problem also does NOT occur with version 5.1.3.2 under
Windows 10 Home x64

#6

I can confirm it also occurs in version 5.2.2, Windows 7, 32 bits, starter edition.

#7

That's what I meant with "copying down", clicking the lower right corner
of cell Sheet2.A1 and dragging it down to A100 or further.

#8

I can't reproduce with Version: 5.2.0.0.alpha1+

But as it happens from row 100 looks as an OpenCL issue, please test
disabling it:

Menu/Tools/Options/LibreOffice/OpenCL

The number 100 is set up in:
Menu/Tools/Options/LibreOffice calc/Formula - Custom

Miguel Ángel.

#9

Hi Miguel,

you're spot on. If I increase the number to 200, it happens from A200
onwards. But I haven't found a way to disable OpenCL. If I un-tick the
checkbox, it uses the last set value.

So the workaround would be to set it to a very high number.

#10

Hi Thomas,

Menu/Tools/Options/LibreOffice/OpenCL

Miguel Ángel.

#11

I have disabled OpenCL and reproduced the reported problem.