Bug 81408

Summary: There is a bug when creating a formula starting from “-” or “+”.
Product: LibreOffice Reporter: tagezi <lera.goncharuk>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: minor CC: 79045_79045, helenrussian, himajin100000
Priority: low    
Version: Inherited From OOo   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108253    

Description tagezi 2014-07-16 04:59:37 UTC 
If I type “-SUM” in a cell, pop-up tip appears, I press enter to get “-SUM()”, where blinking cursor is between parenthesis, and then I select needed cell range, but it is not recorded in the formula resulting in selected cell range and separate empty formula in the initial cell “=-SUM()”. The bug doesn't occur if I select just some cell after “-” or “+” without formula or if I start with “=”.
Comment 1 ign_christian 2014-07-16 05:49:15 UTC 
Confirmed with LO 3.3.0.4, 4.2.5.2, AOO 4.1.0 on Ubuntu 12.04 x86. Really like inherited from OOO.

I don't know whether it's a bug since pop-up tip appears. If the pop-up not appears should be not a bug.

Lowering the priority, since AFAIK many people usually start with "=" before entering a formula.
Comment 2 tagezi 2014-07-16 07:19:44 UTC 
Problem is not with pop-up tip, problem is that there is no possibility to set the cell range in the formula starting from “-” or “+” except direct typing. When selecting the range it is not recorded into the formula and it remains empty. 

I agree that less people use possibility to enter formulas with “-” or “+”, but it exist, besides that it is very convenient and can safe time.
Comment 3 Helen 2014-07-16 07:31:26 UTC 
I confirmed it with LibreOffice 4.3.0.2 on Linux and with LibreOffice 4.3.0.2 on WinXP.
Comment 4 QA Administrators 2015-07-18 17:44:00 UTC Comment hidden (obsolete)
Comment 5 tagezi 2015-08-06 21:14:06 UTC 
Yes. I see this bug.

OS: Kubuntu 14.04 (64-bit)
LibreOffice 5.0.0.5
ID build: 437e4abdf9e72fd0a6e6f8697a0e659bc77f9b10
Local: ru-RU (ru_RU.UTF-8)
Comment 6 QA Administrators 2016-09-20 10:21:09 UTC Comment hidden (obsolete)
Comment 7 tagezi 2016-09-20 10:30:31 UTC 
confirm on

Version: 5.2.3.0.0+
ID: 4b7707bb8bcf0965d2d81f9c82672cb11829737f
OS: Linux 4.6;
local: ru-RU (ru_RU.UTF-8); Calc: group
Comment 8 Xisco Faulí 2017-09-29 08:52:15 UTC Comment hidden (obsolete)
Comment 9 Xavier Van Wijmeersch 2017-09-29 17:49:49 UTC 
confirm with

Version: 6.0.0.0.alpha0+
Build ID: 19910c461230f70bb9e98ad44db3525f0d755724
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group

but when using -sum( then select range and then enter, the range is recorded
Comment 10 QA Administrators 2018-10-01 02:53:23 UTC Comment hidden (obsolete)
Comment 11 Roman Kuznetsov 2019-02-15 21:28:13 UTC 
don't repro in

Version: 6.3.0.0.alpha0+
Build ID: c57dc7d41bd62f933cffab6131edb7252606382d
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded

Status->WFM