not reproducible with LO 4.0.2.2 (Win7 Home, 64bit)
Does this issue still persist for you with the latest release of LO?
Or is it maybe a Linux specific issue?

Note:
A, B, C, etc. means column 1, 2, 3, etc.
To insert the formulas: go to the cell and then to the menu TABLE and then to FORMULA (then you can the enter the formula as in Calc)

Marking as WFM - I can confirm that this works in 4.0.1.2 release as well as 4.1 master and 3.6.5.2.

@gggggggggg9 - if this is still an issue for a newer release than 4.0.0.3 release please reopen the bug and tell us more information. How are you deleting the row (highlight, right click - row - delete?)

Also please attach the document you are working with so we can work on the exact same document that is showing this behavior for you.

Thanks for reporting!

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free. We invite you to join our triaging by checking out this link:
https://wiki.documentfoundation.org/QA/BugTriage and join us on freenode at #libreoffice-qa

There are also other ways to get involved including with marketing, UX, documentation, and of course developing -  http://www.libreoffice.org/get-help/mailing-lists/. 

Lastly, good bug reports help tremendously in making the process go smoother, please always provide reproducible steps (even if it seems easy) and attach any and all relevant material

Hi, 

i still have the issue, however i seem to have missed a point in the procedure:

Instead of:
6. Delete line 3 in table 2
7. Klick outside the table 

it should be: 

6. Select all (or some) fields in line (or row) 3 in table 2
7. use Button 3 on those fields
8. select Zeile-Löschen (Row-Delete)(?) in the Popup-Menu
9. Klick outside the table 

P.S. Sorry for the confusion of the decimal separator, they should be the same in both tables. The attached file uses . as separator.

Created attachment 78194 [details]
example-odt

hm, still works perfect for me.

I downloaded sample file, highlighted 4 of the cells in row 3, right clicked, went to row -> delete row then clicked out of table, everything remained fine.



What version are you using now? 4.0.2.2 release?

Yes, I'm using 4.0.2.2. 
Today, I got my hands on a windows machine with the same version. I could not reproduce it on windows.

ah so it's machine specific. Try resetting your profile to see if that helps: 

https://wiki.documentfoundation.org/UserProfile


This now falls under WORKSFORME as it's clear it's specific to a single machine but I'll leave it open until we try a couple things to fix it on that machine

Hi, 

actually i issued 

/bin/rm -rf ~/.[!.]* 

for my test user, started a new kde-session for that user and still have the problem. If i open the file with a wrong regional scheme, it doesn't recognize the numbers. Should it do that?

hm, what do you mean doesn't recognize the #'s, and also wrong regional scheme where? It tools -> Options -> Languages?

What locale are you using? I want to track down the issue reported first

Created attachment 78335 [details]
environment-variables

I attached the output of export. However, in libreoffice i set 
Tools-Options-Language Settings-Locale-Setting to English(US)

The User Interface i set to German or English (UK). That makes no difference.

If i set Locale Setting to German, it does not recognize 12.33 as number and expects 12,33. Does LO really save the character (.) and not the logical function (decimal seperator) ?

Okay, this was a very old UNCONFIRMED bug ... which I confirm right now that the result in the 3 cells is now a **Foutieve Expressie** (** Expression is faulty **) when deleting the 3th COLUMN (not ROW). 

Tested using Linux Mint 15 x64 with LibreOffice 4.0.3.3 and DUTCH UI (we use also a comma as decimal separator).

(In reply to comment #3)

> 6. Select all (or some) fields in line (or row) 3 in table 2
> 7. use Button 3 on those fields
> 8. select Zeile-Löschen (Row-Delete)(?) in the Popup-Menu

@bug reporter: are you sure you can reproduce this by deleting a ROW, not a column? I can not reproduce this behavior when I delete the 3th row.

Deleting the 3th COLUMN (NOT ROW) of the second table will result in this error (** Expression is faulty **)... but I think that's quite obvious, due the fact D1, E1 and F1 are all related to C1.

Kind regards,
Joren

A dangit, I marked this bug as NEW, but I can not reproduce this bug when deleting the ROW (I can reproduce this when I delete the column). I'm going to do a workaround to mark this bug back to UNCONFIRMED. I'm sorry for the noise.

Hello qqqqqqqqq9, jorendc, *,
I can confirm this bug with LO Version: 4.1.0.1
Build ID: 1b3956717a60d6ac35b133d7b0a0f5eb55e9155 under Debian Testing AMD64 w/ Germanophone help- as well as langpack ... :(
I did the following:
1. Entered the values, qqqqqqqqq9 has entered (used commas in the second table)
2. Marked three cells in the third row of the second table
3. Clicked on "Delete Row" in the Table Toolbar below

LO immediatly shows "** Expression is faulty **"

LO: Version: 4.1.0.1
Build ID: 1b3956717a60d6ac35b133d7b0a0f5eb55e9155
OS: Debian Testing AMD64

Checked this with Germanophone UI as well as with the English one, both the same (though translated error message ... ;) ).

HTH
Thomas.

no problem in

Version: 7.1.0.0.alpha0+ (x64)
Build ID: fca525d570f4fada3db1a9bbee2e88a5a02839d9
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: CL

let's close it as WFM

I checked it in linux too, no problem