[Libreoffice-bugs] [Bug 49662] EDITING: wrong calculation result for named ranges

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=49662

Rainer Bielefeld  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 Resolution||INVALID

--- Comment #9 from Rainer Bielefeld  
2012-06-17 06:41:36 PDT ---
Closing Bug due to reporter's inactivity.

@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
 (especially BugReport Details)!

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 49662] EDITING: wrong calculation result for named ranges

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=49662

--- Comment #8 from Rainer Bielefeld  
2012-05-11 01:49:03 PDT ---
> How to close tis one?

@manugm...@gmail.com 
Don't worry about the Bugzilla dashboard, we will do that. Only think about the
bug description.

>... to which cell(reference) is assigned testvalue3 when you go to sheet 
>data1? 

"testvalue1" is always related to sheet $data1
"testvalue3" is related to a range on the sheet from where I open 'Insert Name'
   dialog

May be hints on  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
- 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)
– if possible contribute an instruction how to create a sample document 
  from the scratch (IMHO most interesting)
- add information 
  -- what EXACTLY is unexpected
  -- and WHY do you believe it's unexpected (cite Help or Documentation!)
  -- concerning your OS (Version, Distribution, Language)
  -- concerning your LibO 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

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 49662] EDITING: wrong calculation result for named ranges

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=49662

--- Comment #7 from manugm...@gmail.com 2012-05-11 01:22:33 PDT ---
Hello Rainer,

Ok Thank you for your help. My english is not so good and then not so precise
to explain my problem. Il will submit a new bug as you advive me. How to close
this one?

Just to go one step forward, could you tell me when you open my file, to which
cell(reference) is assigned testvalue3 when you go to sheet data1? same
question when you go to sheet calctarget? Thank you.

Manu

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 49662] EDITING: wrong calculation result for named ranges

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=49662

--- Comment #6 from Rainer Bielefeld  
2012-05-10 22:14:36 PDT ---
@manugm...@gmail.com
Currently I cant understand the problem, I do not see any bug. Please 
contribute a complete coherent description "WHAT is unexpected + WHY do you
think it's unexpected")?
It might be better to close this report and to submit a new Bug if you think
that there is a problem.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 49662] EDITING: wrong calculation result for named ranges

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=49662

--- Comment #5 from manugm...@gmail.com 2012-05-10 09:22:38 PDT ---
Le 09/05/2012 06:25, bugzilla-dae...@freedesktop.org a écrit :
> https://bugs.freedesktop.org/show_bug.cgi?id=49662
>
> Rainer Bielefeld  changed:
>
> What|Removed |Added
> 
>   Status|UNCONFIRMED |NEEDINFO
> Severity|major   |normal
> Priority|high|medium
>   CC||LibreOffice@bielefeldundbus
> ||s.de
>   Ever Confirmed|0   |1
>  Summary|EDITING: calculation error  |EDITING: wrong calculation
> ||result for named ranges
>
> --- Comment #2 from Rainer Bielefeld  
> 2012-05-08 21:25:38 PDT ---
>> the result is 1 but testvalue1=1 and testvalue3=3
> "testvalue3=3" NOT reproducible with "LibreOffice 3.5.3.2 (RC2) German
> UI/Locale [Build-ID: 235ab8a-3802056-4a8fed3-2d66ea8-e241b80] on German WIN7
> Home Premium (64bit)
>
> @manugm...@gmail.com:
> I can not reproduce you result for "testvalue3", please explain! As definition
> for "testvalue3=3" I see "calctarget.$A$3", what is an empty cell
> Do you get different results with other LibO Versions?
>

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 49662] EDITING: wrong calculation result for named ranges

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=49662

--- Comment #4 from manugm...@gmail.com 2012-05-09 23:59:11 PDT ---
More precision: here is the version of my LibreOffice
LibreOffice 3.5.3.2 French translation
Version ID : 235ab8a-3802056-4a8fed3-2d66ea8-e241b80
Linux Ubuntu 10.04

Perhaps, should the title of the bug be modified? for exemple: "reference of a
named cell is erroneously modified depending of the actual sheet"

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 49662] EDITING: wrong calculation result for named ranges

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=49662

--- Comment #3 from manugm...@gmail.com 2012-05-09 02:28:56 PDT ---
Indeed, go to sheet data1 or data1 and type ctrl+F3, you will see that the
definition of testvalue3 change alone ! (not expected as the scope is global,
right?)  I didn't notice that at the begining as I had defined
testvalue3=data1.$A$1 (which contains the value "3"). This explain my first
nalysis of the bug. Thanks!

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 49662] EDITING: wrong calculation result for named ranges

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=49662

Rainer Bielefeld  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
   Severity|major   |normal
   Priority|high|medium
 CC||LibreOffice@bielefeldundbus
   ||s.de
 Ever Confirmed|0   |1
Summary|EDITING: calculation error  |EDITING: wrong calculation
   ||result for named ranges

--- Comment #2 from Rainer Bielefeld  
2012-05-08 21:25:38 PDT ---
> the result is 1 but testvalue1=1 and testvalue3=3

"testvalue3=3" NOT reproducible with "LibreOffice 3.5.3.2 (RC2) German
UI/Locale [Build-ID: 235ab8a-3802056-4a8fed3-2d66ea8-e241b80] on German WIN7
Home Premium (64bit)

@manugm...@gmail.com:
I can not reproduce you result for "testvalue3", please explain! As definition
for "testvalue3=3" I see "calctarget.$A$3", what is an empty cell
Do you get different results with other LibO Versions?

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs