[Libreoffice-bugs] [Bug 111552] wrong result just in one of all fields

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=111552

Julien Nabet  changed:

   What|Removed |Added

 Resolution|FIXED   |NOTABUG

--- Comment #10 from Julien Nabet  ---
Thank you Michel for your feedback.
Since there's no specific fix and there was no bug indeed, let's put this one
to NOTABUG.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 111552] wrong result just in one of all fields

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=111552

Michel  changed:

   What|Removed |Added

 Status|REOPENED|RESOLVED
 Resolution|--- |FIXED

--- Comment #9 from Michel  ---
Thank you !
I'm sorry about such a mistake, and probably need better glasses,

Best regards.

Michel

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 111552] wrong result just in one of all fields

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=111552

--- Comment #8 from m.a.riosv  ---
Created attachment 135395
  --> https://bugs.documentfoundation.org/attachment.cgi?id=135395=edit
Sample file corrected and tested.

What it's wrong?

E2=1000(e3)-6531,3(d2)=-5531,3
E1=-5531,3(e2)+5331,3(c1)=-200

Your file corrected with a couple of test to verify the result.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 111552] wrong result just in one of all fields

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=111552

Michel  changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|NOTABUG |---

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 111552] wrong result just in one of all fields

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=111552

--- Comment #7 from Michel  ---
For "Steps to reproduce",
i just tried to create an example without all other datas.

The error seems linked to the columns names, not to the lines numbers.

Correctly formulated:
1. tip in C1: 5331.30
2. tip in E2: -5331.30
3. function in E1: =E2+C1-D1, result zero (because D1 is empty)
4. tip in D2: 6531.30
5. tip in E3: 1000.00
6. copy E1 to paste in E2, result -200, wrong
   wile E2 has the same value as before (-5331.30) but the result of the
function and no more a direct value

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 111552] wrong result just in one of all fields

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=111552

--- Comment #6 from Michel  ---
Yes Julien, you're right.

The problem is when you copy the funcion, for example from E9
and paste it to E8, than the result of E7 will be -200 instead of 0.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 111552] wrong result just in one of all fields

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=111552

m.a.riosv  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 CC||miguelangelrv@libreoffice.o
   ||rg
 Resolution|--- |NOTABUG

--- Comment #5 from m.a.riosv  ---
I think the apparent issue, appears because in E5 there is a value not a
formula. Copying the formula there the result for 'Solde' it's fine.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 111552] wrong result just in one of all fields

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=111552

Julien Nabet  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 CC||serval2...@yahoo.fr
 Ever confirmed|0   |1

--- Comment #4 from Julien Nabet  ---
On Win7, with LO 5.3.4, I just opened the file.
E6=E7+C6-D6 (here 6400)

E7=E8+C7-D7 (here 0)
C6=6400 (direct value)
D6=empty

=> so E6 is ok

E8=-5331,3 (direct value)
C7=5331,3 (direct value)
D7=empty

=> so E7 OK

E1 contains just the label "Solde".

In brief, I don't understand what's your problem.

Also, what does "tip in C1" mean? C1 contains label "Crédit".

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 111552] wrong result just in one of all fields

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=111552

--- Comment #3 from Michel  ---
oh my!
it's enough
i tried easyer and it's wrong

definitively for E1:  =E2+C1-D1

just look at my attachment for E7
best regards.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 111552] wrong result just in one of all fields

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=111552

--- Comment #2 from Michel  ---
sorry, the right function in E1 is:   =E2+C1-C2

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 111552] wrong result just in one of all fields

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=111552

--- Comment #1 from Michel  ---
Created attachment 135338
  --> https://bugs.documentfoundation.org/attachment.cgi?id=135338=edit
Accounting my mother by social health-care institution

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs