https://bugs.freedesktop.org/show_bug.cgi?id=55940
--- Comment #10 from [email protected] --- It is easy to miss the –. It really is not a problem for me in the file. I thought it might be a problem with Calc since it doesn’t seem normal to use a double minus. You are correct, If I just add the cell the result is the same. I think that since the 2 cells have a negative number they are automatically subtracted when you add them up. I had sort of thought that was what might be happening. I just went and removed the minus in the 2 cells and the formula with all plus signs then added the 2 cells instead of subtracting them. Again this is not a problem for me and it seems to me that Calc might doing the correct thing. If you use a single minus then it seems to change the negative cells to positive, so then you have to use the second minus to actually subtract the negative cells. This is interesting, I wonder if all spreadsheets would do the same. Oh well, that is not important but it has been a good learning experience for me. I hope I have not wasted a lot of your time. Thank you for your help, Jerry From: [email protected] Sent: Saturday, October 20, 2012 7:33 PM To: [email protected] Subject: [Bug 55940] To subtract a cell requires a double minus. Julien Nabet changed bug 55940 What Removed Added Status UNCONFIRMED NEEDINFO Ever confirmed 1 Comment # 9 on bug 55940 from Julien Nabet Thank you for your feedback, I had missed the cell where there was a double minus. But I still can't see the problem: 2 minus = an addition. If in a cell, I put this: =B12+B16+B22+B29+B33+B48 I got the same result as: =B12+B16+B22--B29--B33+B48 aka here 937136,7 Sorry, I must really miss something but I still don't see problem. If we focus on ods file (so let's forget for the moment the txt file), is there a problem for you in this file? If yes which one? (again sorry if I miss something obvious) -------------------------------------------------------------------------------- You are receiving this mail because: a.. You reported the bug. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
