[Libreoffice-bugs] [Bug 87479] Formula not getting calculated in libre office 4.3.4.1

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 Resolution|--- |INVALID

-- 
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 87479] Formula not getting calculated in libre office 4.3.4.1

[bugzilla-daemon]

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

--- Comment #5 from m.a.riosv miguelange...@libreoffice.org ---
Please @SriJanani, is the issue solved?

-- 
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 87479] Formula not getting calculated in libre office 4.3.4.1

[bugzilla-daemon]

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

--- Comment #4 from QA Administrators qa-ad...@libreoffice.org ---
Dear Bug Submitter,

This bug has been in NEEDINFO status with no change for at least 6 months.
Please provide the requested information as soon as possible and mark the bug
as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in
NEEDINFO status with no change in 30 days the QA team will close the bug as
INVALID due to lack of needed information.

For more information about our NEEDINFO policy please read the wiki located
here: 
https://wiki.documentfoundation.org/QA/FDO/NEEDINFO

If you have already provided the requested information, please mark the bug as
UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed.


Thank you for helping us make LibreOffice even better for everyone!


Warm Regards,
QA Team

This NEEDINFO message was generated on: 2015-07-18

-- 
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 87479] Formula not getting calculated in libre office 4.3.4.1

[bugzilla-daemon]

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

--- Comment #3 from aaker markus.weyerm...@gmx.net ---
(In reply to aaker from comment #2)
 SriJanani
 
 I assume your formula in AD is working as expected. Substituting al the
 refs by the appropriate values, you will get
 =O4/C4*20*(((C4*(1+E4))*(1+H4))*(1+K4))/20.
 Multiplying and subsequent dividing by 20 cancels out:
 =O4/C4*(((C4*(1+E4))*(1+H4))*(1+K4))
 Normalizing with the brackets you will get
 =O4/C4*C4*(1+E4)*(1+H4)*(1+K4)
 Once more dividing and subsequent multiplying by C4 cancels out.
 So changing the value in C4 will change nothing to the result of your
 formula in AD4.
 
 cheers
 Markus

Verify proper calculation of formula by changing value in O4

-- 
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 87479] Formula not getting calculated in libre office 4.3.4.1

[bugzilla-daemon]

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

aaker markus.weyerm...@gmx.net changed:

   What|Removed |Added

 CC||markus.weyerm...@gmx.net

--- Comment #2 from aaker markus.weyerm...@gmx.net ---
SriJanani

I assume your formula in AD is working as expected. Substituting al the refs
by the appropriate values, you will get
=O4/C4*20*(((C4*(1+E4))*(1+H4))*(1+K4))/20.
Multiplying and subsequent dividing by 20 cancels out:
=O4/C4*(((C4*(1+E4))*(1+H4))*(1+K4))
Normalizing with the brackets you will get
=O4/C4*C4*(1+E4)*(1+H4)*(1+K4)
Once more dividing and subsequent multiplying by C4 cancels out.
So changing the value in C4 will change nothing to the result of your formula
in AD4.

cheers
Markus

-- 
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 87479] Formula not getting calculated in libre office 4.3.4.1

[bugzilla-daemon]

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

m.a.riosv mari...@miguelangel.mobi changed:

   What|Removed |Added

 Attachment #111029|text/plain  |application/vnd.oasis.opend
  mime type||ocument.spreadsheet

-- 
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 87479] Formula not getting calculated in libre office 4.3.4.1

[bugzilla-daemon]

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

m.a.riosv mari...@miguelangel.mobi changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 CC||mari...@miguelangel.mobi
 Ever confirmed|0   |1

--- Comment #1 from m.a.riosv mari...@miguelangel.mobi ---
Hello SriJanani,

Thank you for reporting the bug. To be certain the reported issue is not
related to corruption in the user profile, could you rename this LibreOffice
user directory ( see
https://wiki.documentfoundation.org/UserProfile#Default_location or
http://ask.libreoffice.org/en/question/903/where-are-the-libreoffice-data-profile-files/
) and re-test?

I think works fine for me. if I put 250 in C4, AC4 change to 9.
Cells have rounded format so is necessary change in the input cell value enough
to change the result.

-- 
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