Bug 50367

Summary:	EDITING: moving cell array with absolute cell reference looses the cell reference
Product:	LibreOffice	Reporter:	mare_tyo
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED INVALID
Severity:	critical	CC:	LibreOffice, mare_tyo
Priority:	high
Version:	3.5.2 release
Hardware:	Other
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description mare_tyo 2012-05-25 21:20:09 UTC

f2: 30
g2: 0.24
f3: 60
g3: =G$2/F$2*F3
f4: 90
g4: =G$2/F$2*F4

when moving array f2:g4 in any direction but not strict horizontally or strict vertical, the reference gets lost
other explanation
when moving array f2:g4 in a direction where horizontal and vertical directions are mixed the reference gets lost


note: 
1 -copy & paste works; see example in attached file
2 - MS Excel does not create error with the same operation

I can be contacted if needed.

Comment 1 Rainer Bielefeld Retired 2012-05-29 11:36:28 UTC

@reporter:
Thank you for your report – unfortunately important information is missing.
May be hints on <http://wiki.documentfoundation.org/BugReport> will help you to find out what information will be useful to reproduce your problem? If you believe that that  is really sophisticated please as for Help on a user mailing list
Please:
- Write a meaningful Summary describing exactly what the problem is
- Attach a sample document (not only screenshot) or refer to an existing 
  sample document in an other Bug with a link.
- Contribute a step by step instruction containing every key press and every 
  mouse click how to reproduce your problem (due to example in Bug 43431)
- add information 
  -- what EXACTLY is unexpected ("Call xxx ....")
  -- and WHY do you believe it's unexpected (cite Help or Documentation!)
  -- concerning your OS (Version, Distribution, Language)
  -- concerning your localization (UI language, Locale setting)
  –- Libo settings that might be related to your problems 
  -- how you launch LibO and how you opened the sample document
  -- everything else crossing your mind after you read linked texts

Even if you can not provide all demanded information, every little new information might bring the breakthrough.

May be you can test <https://www.libreoffice.org/get-help/bug/> for submitting bug reports?

Comment 2 Rainer Bielefeld Retired 2012-06-16 08:51:02 UTC

NOT reproducible in a quick test with Master " 3.7.0alpha0+  – WIN7 Home Premium (64bit) ENGLISH UI [Build ID: 5af60dc]" (tinderbox: Win-x86@6-fast, pull time 2012-06-14 22:09:53) and sample document created due to reporter's instructions.

Closing Bug due to reporter's inactivity as INVALID.

@reporter:
Please feel free to reopen this bug if you find out that the problem still exists with the current stable LibreOffice version and if you can contribute requested additional information due to <http://wiki.documentfoundation.org/BugReport> (especially BugReport Details)!