Bug 157334 - The adition dont work after an existing work sheet with Numbers and addition.
Summary: The adition dont work after an existing work sheet with Numbers and addition.
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.1.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-09-19 15:53 UTC by Wolfgang Paelchen
Modified: 2024-02-25 01:12 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Wolfgang Paelchen 2023-09-19 15:53:33 UTC 
Description:
If you will correkt the sheet the addition with a new Line shows #WERT! if you dublikate the addition Line before.

Actual Results:
16.08.23	1	5	Umb	von Onvista	Umbuchung		400,00		461	400,00
16.08.23	1		Abb	Stadtreinigung	haus	Müllabfuhr	 	95,37	459	#WERT!
17.08.23	1	6	div	Fondak	847101		60,53	 	462	#WERT!
17.08.23	1	6	div	Fondak	847101			11,17	462	#WERT!
17.08.23	1		Da	HWW	Haus	Wasser		33,00	460	#WERT!
17.08.23	5		kre	Sb Tank	Fahrzeug	57,79				#WERT!


Expected Results:
16.08.23	1	5	Umb	von Onvista	Umbuchung		400,00		461	400,00
16.08.23	1		Abb	Stadtreinigung	haus	Müllabfuhr	 	95,37	459	77,91
17.08.23	1	6	div	Fondak	847101		60,53	 	462	127,27
17.08.23	1	6	div	Fondak	847101			11,17	462	127,27
17.08.23	1		Da	HWW	Haus	Wasser		33,00	460	94,27
17.08.23	5		kre	Sb Tank	Fahrzeug	57,79				94,27



Reproducible: Always


User Profile Reset: No

Additional Info:
It needs to be done.
Comment 1 LeroyG 2023-09-19 20:15:31 UTC 
#WERT! is for #VALUE! in English locale.

Please share a step by step description, with formula included.
Better with a shared .ods file.
Thanks.
Comment 2 Alex Thurgood 2023-09-20 08:39:58 UTC 
@Wolfgang: please explain step-by-step how this occurs.

The title of your report mentions "Numbers". 

Do you mean that you started from a macOS Numbers sheet, and opened that Numbers file in LO Calc, and then added the extra lines ?

Please explain, and provide a test file with sample data and reproducible steps.
Comment 3 Nik Boston 2024-02-25 01:12:27 UTC Comment hidden (spam)