User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.116 Safari/537.36 Build Identifier: 31dd62db80d4e60af04904455ec9c9219178d620 Cells that link to other cells display the linked text in upper case, sometimes..."at some point". But once they start to do it, they always do it. Reproducible: Always Steps to Reproduce: Consider five cells A,B,C,D,E A contains text. The following cells are linked to that text, and exist to allow manual modification of that cell if required. B=A C=B D=B E=C D and E show the A content in upper case. This does not occur with just five cells. It occurs "at some point" after adding more stuff into the sheet and then drag-copying the cells downwards to replicate on many rows. This suddenly happened in an existing sheet. I couldn't fix it so rebuilt the sheet from scratch, and "at some point" it happened again. The sheet is here https://dl.dropboxusercontent.com/u/57111073/torvista_uppercase_bug.ods look at the rows titled in yellow how some are upper case. Reset User Profile?No
Created attachment 127552 [details] spreadsheet that displays the problem
I typed into the yellow cells. No problem even after save & reload. Are you using 5.2.x? Arch Linux 64-bit, KDE Plasma 5 Version: 5.2.2.2.0+ Build ID: 5.2.2-1 CPU Threads: 8; OS Version: Linux 4.7; UI Render: default; Locale: fi-FI (fi_FI.UTF-8); Calc: group Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the information.
Ok, a simpler scenario. F3 is the source field, in sentence case. G3=F3. It shows in sentence case as expected. H3=G3. It is upper case. Why? I3=G3. It is upper case J3=H3. It is upper case. I have now found how to replicate this, easier to show it in this video: https://dl.dropboxusercontent.com/u/57111073/torvista_bug_102363.mp4 thanks Steve Version: 5.2.1.2 (x64) Build ID: 31dd62db80d4e60af04904455ec9c9219178d620 CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; Locale: en-GB (en_GB); Calc: group
(In reply to Steve from comment #3) > I have now found how to replicate this, easier to show it in this video: > https://dl.dropboxusercontent.com/u/57111073/torvista_bug_102363.mp4 So you are doing an undo after the first fill and then doing a second, which makes the last column turn into all caps? I don't reproduce the problem. Arch Linux 64-bit, KDE Plasma 5 Version: 5.2.2.2.0+ Build ID: 5.2.2-1 CPU Threads: 8; OS Version: Linux 4.7; UI Render: default; Locale: fi-FI (fi_FI.UTF-8); Calc: group
Yes, but the difference is the first drag-fill is to row 99: ok undo the second drag-fill is to row 100: NOT ok. The third column changes itself to upper case.
(In reply to Steve from comment #5) > Yes, but the difference is > the first drag-fill is to row 99: ok > undo > the second drag-fill is to row 100: NOT ok. The third column changes itself > to upper case. Tried again to be sure. Not happening. You could try this: https://wiki.documentfoundation.org/UserProfile#Resolving_corruption_in_the_user_profile
Created attachment 127925 [details] screenshot - no fault
Created attachment 127926 [details] screenshot - with fault Calc Version: 5.2.1.2 (x64) Build ID: 31dd62db80d4e60af04904455ec9c9219178d620 CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; Locale: en-GB (en_GB); Calc: group
Comment on attachment 127925 [details] screenshot - no fault Calc Version: 5.2.2.2 (x64) Build ID: 8f96e87c890bf8fa77463cd4b640a2312823f3ad CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; Locale: en-GB (en_GB); Calc: group
(In reply to Steve from comment #9) > Comment on attachment 127925 [details] > screenshot - no fault > > Calc > Version: 5.2.2.2 (x64) > Build ID: 8f96e87c890bf8fa77463cd4b640a2312823f3ad > CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; > Locale: en-GB (en_GB); Calc: group So you mean the problem went away in 5.2.2?
I deleted the user profile, no change. I uninstalled Libreoffice, deleted the whole user libreoffice folder, ran ccleaner and reinstalled with the latest version 5.2.2. This was not available when I first reported the problem and I had already re-installed so I assume the problem was not install-related. Problem is gone. Opening the attached spreadsheet does not display the error. So to conclude, if viewing the example spreadsheet on PC 1 Dell Laptop: Version: 5.2.2.2 (x64) Build ID: 8f96e87c890bf8fa77463cd4b640a2312823f3ad CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; Locale: en-GB (en_GB); Calc: group the fault is not present as seen in image screenshot - no fault attached. If viewing the same spreadsheet on another PC 2 Desktop: Version: 5.2.1.2 (x64) Build ID: 31dd62db80d4e60af04904455ec9c9219178d620 CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; Locale: en-GB (en_GB); Calc: group The fault IS present as shown in the image screenshot - with fault. If viewing the same spreadsheet on another PC 3 Asus Laptop: Version: 5.2.1.2 (x64) Build ID: 31dd62db80d4e60af04904455ec9c9219178d620 CPU Threads: 2; OS Version: Windows 6.19; UI Render: default; Locale: en-GB (en_GB); Calc: group The fault IS present as shown in the image screenshot - with fault. Thanks for your time.
Great! Let's close as WFM. If you feel like helping out with bugs, check this out: https://wiki.documentfoundation.org/QA/GetInvolved