Bug 124585 - balans error bookkeeping
Summary: balans error bookkeeping
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.2.1 rc
Hardware: All Windows (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Formula
  Show dependency treegraph
 
Reported: 2019-04-07 11:25 UTC by Frans Stroetmann
Modified: 2019-04-07 22:21 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file (14.60 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-04-07 17:31 UTC, Buovjaga
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Frans Stroetmann 2019-04-07 11:25:57 UTC
Description:
office changes formula of the balans illegal

Steps to Reproduce:
1.make collums debit, credit and balans and put some figures in credit and debit. balans is old balans (cel above) minus debit plus credit
2.cut a cell in credit or debit and past it a cell below.
3.The balans formula is changed and add/subtract the money 2 times instead of one

Actual Results:
You cannot cut and paste cells in bookkeeping

Expected Results:
The money should not disappear, its really a big error.


Reproducible: Always


User Profile Reset: No



Additional Info:
create an error message or warning. A pitty I cannot add a screenshot.
Comment 1 Buovjaga 2019-04-07 12:05:32 UTC
Please attach an example document.
Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the document.
Comment 2 Buovjaga 2019-04-07 17:31:20 UTC
Created attachment 150583 [details]
Example file

The reporter emailed me this example file, because he misunderstood what he was supposed to do.

The file says:
"cut a cell in debit or credit and paste it in another cell
look what happened"

This is not enough information. Frans: please explain in a comment what you do in the example file and what is the expected result. And DO NOT EMAIL ME.
Comment 3 m_a_riosv 2019-04-07 22:21:38 UTC
IMO there is not a bug, it is how spreadsheets work, if you cut a cell and paste in other place, references to it change to the new address.

The only way it's not using cut, instead use copy - suppress - paste.

Cut must be done always very carefully, because if after is no pasted, references became broken, and if pasted are changed.