Bug 118632 - content of Name Box and Input Line interchanged for formula cells
Summary: content of Name Box and Input Line interchanged for formula cells
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.0.1 rc
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-07-09 11:04 UTC by Wolfgang Jäger
Modified: 2019-10-29 10:36 UTC (History)
2 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 Wolfgang Jäger 2018-07-09 11:04:34 UTC
First of all: I cannot tell how to reproduce the issue.
Second: I didn drink alcohol.

Working in LibO V6.1.0.1RC Calc on a large sheet linked by a questioner into his post in a forum after a while I suddenly had the situation that main parts of the formulas contained in some cells I selected one by one were displayed in the 'Name Box' and reversely the cell addresses were displayed in the 'Input Line'. 

Unfortunately I wasn't quick-witted enough to take the oportunity of a thoroughly planned research including cells with constant contents, entering into both the afflicted controls, selecting ranges and a different sheet and more. 

When I had confirmed the basic fact for about a dozen cells, I made a test I should have deferred: I forced a recalculation and the issue had vanished when that was done.
Comment 1 Xisco Faulí 2018-07-11 12:02:12 UTC
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)

I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Comment 2 Wolfgang Jäger 2018-07-11 14:25:18 UTC
(In reply to Xisco Faulí from comment #1)
> Thank you for reporting the bug. Please attach a sample document, as this
> makes it easier for us to verify the bug. 
> (Please note that the attachment will be public, remove any sensitive
> information before attaching it. 
> See
> https://wiki.documentfoundation.org/QA/
> FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help
> on how to do so.)
> 
> I have set the bug's status to 'NEEDINFO'. Please change it back to
> 'UNCONFIRMED' once the requested document is provided.

I have the document I once experienced the mentioned behaviour in. Its a 18MiByte thing provided by a questioner in forum.openoffice.org/en via an upload service to get help. It was edited by me experimnting with some ideas concerning his problem. It was -at least- recalcultaed since, most likely also changed otherwise.

However, the effect vanished after my mentioned action and did not come back since. I have no clue what parts of it may be in any way related to the miracle. I therefore also have no clue waht I might remove without also removing the possible cause. 

I can only tell that there were two "automatic cell styles" pointing to a probable episode of editing in Excel, and that it made use of FILTERXML() and WEBSERVICE() what rarely occurs with uploaded fles. 

Shorter conclusion: I didn't post this bug report in the hope there would soon be a confirmation or a fix. It was thought as a contact-point and an attractor for others experiencing similar behaviour. May be there is a reproducible situation reported then. 

Sorry.
Comment 3 Xisco Faulí 2018-07-12 15:24:53 UTC
ok, let's keep it in NEEDINFO for the time being. If you report it again, please change it back to UNCONFIRMED!
Thanks!
Comment 4 QA Administrators 2019-01-11 15:22:17 UTC Comment hidden (obsolete)
Comment 5 QA Administrators 2019-03-21 11:25:20 UTC Comment hidden (obsolete)
Comment 6 Wolfgang Jäger 2019-03-21 12:09:46 UTC
I was aware of the fact that the bug couldn't be fought based on the information I was able to provide. 

From my Comment #2 : 
"I didn't post this bug report in the hope there would soon be a confirmation or a fix. It was thought as a contact-point and an attractor for others experiencing similar behaviour. May be there is a reproducible situation reported then."  

Based on this comment Xsisco Fauli (Comment # 3) decided to keep the bug in. NEEDINFO.
Comment 7 Xisco Faulí 2019-09-26 11:22:29 UTC
Hello Wolfgang,
A new major release of LibreOffice is available since this bug was reported.
Could you please try to reproduce it with the latest version of LibreOffice
from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' if the bug is still present in the latest version.
Comment 8 Wolfgang Jäger 2019-10-29 10:36:48 UTC
The mentioned behaviour was observed exactly one and is clearly not reproducible.  
Nobody else left a confiming comment. Therefore I think the attampt to offer an "anchor" for users making similar observations is obsolete. 

Setting to RESOLVED WORKSFORME.