Bug 159397 - Enhancements of formula
Summary: Enhancements of formula
Status: RESOLVED DUPLICATE of bug 157089
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.0.1 rc
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-01-27 11:36 UTC by p_kongstad
Modified: 2024-01-27 23:25 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 p_kongstad 2024-01-27 11:36:11 UTC 
Hi,

In Google sheet you can write a formula like this

=SUM(A2:A) That'll sum from A2 to end of the column.

In calc you can have somthing like this =SUM(A:A) summing the whole column, while a formula like SUM(A2:A) will return an error #NAME?

So it would be nice to enhance this in all functions accepting parameters this way.
Comment 1 m_a_riosv 2024-01-27 23:25:58 UTC 

*** This bug has been marked as a duplicate of bug 157089 ***