https://bugs.documentfoundation.org/show_bug.cgi?id=99039
Bug ID: 99039
Summary: Cells not calculating correctly
Product: LibreOffice
Version: 5.0.5.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: zillabe...@xemaps.com
Created attachment 124021
--> https://bugs.documentfoundation.org/attachment.cgi?id=124021&action=edit
Worksheet with cells that aren't calculating correctly
Sorry, I am not used to reporting bugs, so I'm not sure I'm filling out this
form properly. This bug may be related to other reported bugs, but I don't know
enough about all the terminology I'm seeing on this site to be able to
determine that myself. My hope is that someone more knowledgeable than I will
direct this where it needs to go.
I'm attaching a spreadsheet of a loan amortization table that contains cells
which aren't calculating properly. (And using F9 does not solve the problem,
either.) This is a scary issue to me, because if it weren't so obvious (due to
the round figure of $2,000 each time) I might never have noticed. This has
shaken my trust in the integrity of all my LibreCalc spreadsheets, thus I've
labeled it 'critical'.
HISTORY:
The spreadsheet was originally created in EXCEL. The conversion to ODS was done
in an earlier version of CALC, but I have no recollection which one (it was
over three years ago).
There are two worksheets in this file. The original conversion is contained in
the worksheet named "10 Years at 2.5%". The "Actual Payments" worksheet is the
one that has been modified each month as payments were made. I have highlighted
in pink the cells that are a problem.
If you would like a copy of the original XLS file, I can provide that as well.
Just let me know.
Thank you.
--
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
