Bug 353940 - Inserting a function by hand.
Summary: Inserting a function by hand.
Status: REPORTED
Alias: None
Product: calligrasheets
Classification: Applications
Component: functions (other bugs)
Version First Reported In: 2.9.2
Platform: Kubuntu Linux
: NOR normal
Target Milestone: ---
Assignee: Calligra Sheets (KSpread) Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-10-15 21:28 UTC by bat cooper
Modified: 2021-03-09 22:43 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed/Implemented In:
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description bat cooper 2015-10-15 21:28:47 UTC
Hello, if I insert a function in Calligra Sheets e.g. by typing in a cell:

=sum()

and then if I click between the '(' and ')' so that the cursor is there. If I then use the left mouse button to select some cells that I want to sum-up with the red 'elastic bad', the cell range overwrites the function, rather than going in between the brackets (), i.e. instead of saying 

=sum(G24:K24)

it becomes: 

=G24:K24()

and therefore needs editing back to the correct formula.

Reproducible: Always

Steps to Reproduce:
1. Enter numbers into spreadsheet.
2. Click a cell where a function should go.
3. Type =sum()
4. Put cursor between ( and )
5. Use the left-mouse button to select a cell-range.

Actual Results:  
=G24:K24()

Expected Results:  
=sum(G24:K24)

Maybe this is intended behaviour, but coming from an Excel background, I did not expect this to happen ;-)
Comment 1 Justin Zobel 2021-03-09 22:43:45 UTC
Thank you for the bug report.

As this report hasn't seen any changes in 5 years or more, we ask if you can please confirm that the issue still persists.

If this bug is no longer persisting or relevant please change the status to resolved.