Download it now!
Bug 90782 - Named formula not documented correctly
Summary: Named formula not documented correctly
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.0.3 release
Hardware: Other All
: medium normal
Assignee: Olivier Hallot
URL:
Whiteboard: target:5.0.0
Keywords:
Depends on:
Blocks:
 
Reported: 2015-04-22 10:30 UTC by Olivier Hallot
Modified: 2015-04-22 15:58 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Image showing the issue. (21.63 KB, image/png)
2015-04-22 10:30 UTC, Olivier Hallot
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Olivier Hallot 2015-04-22 10:30:39 UTC
Created attachment 115004 [details]
Image showing the issue.

In LibreOffice Calc, as well as in Excel, you can name a formula. That is, instead of writing a extensive and complex formula, you can give a short name for a long expression.

However, the dialog Insert -> Names only list "Range" as content of the expression.

It should be "Range or formula expression", to spark the idea into user's mind.

The image attached shows the string to modify.

The Help content should also include this feature more explicitely.
Comment 1 Commit Notification 2015-04-22 12:42:10 UTC
Olivier Hallot committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=e893c5ff7a251de867747184bd084c02dcfe549e

Fix tdf#90782: better label for named formulas

It will be available in 5.0.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.
Comment 2 Commit Notification 2015-04-22 15:49:43 UTC
Adolfo Jayme Barrientos committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=d3b6f1de8971a086aa1da829fc01d7c77a09502b

Related: tdf#90782 Switch to a single-column layout

It will be available in 5.0.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.
Comment 3 Commit Notification 2015-04-22 15:58:57 UTC
Olivier Hallot committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=0cf38e7d0c5d2b67dca828aae1797bff58b6c5fe

tdf#90782: better string also for Manage Names dlg

It will be available in 5.0.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.