Issue 123725 - [Enhancement] Better defaults for database range dialog
Summary: [Enhancement] Better defaults for database range dialog
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.0.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: 4.1.0
Assignee: AOO issues mailing list
QA Contact:
Keywords: needmoreinfo
Depends on:
Reported: 2013-11-20 18:51 UTC by Andreas Säger
Modified: 2018-11-30 17:31 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Database Range dialog (14.70 KB, image/png)
2018-10-31 14:54 UTC, Matthias Seidel
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Andreas Säger 2013-11-20 18:51:02 UTC
menu:Data>Define... [More Options] has 4 extra options. Only options 1 and 4 are meaningful. Options 2 and 3 should be set by default if we can't get rid of them.
I use them since version 1 but never found any use case which required them to be off.

Discussion, problem description and example document here: 
[Solved]Dynamic chart - how to do it?
Comment 1 Edwin Sharp 2014-01-15 13:55:12 UTC
IMHO checked by default better than get rid.
Comment 2 hanya 2014-01-15 14:54:21 UTC
Fixed on trunk revision 1558396 but no robot message from svn. Because I committed with 
wrong commit message and I fixed the commit message after the commit.
Comment 3 Edwin Sharp 2014-01-15 15:57:17 UTC
Thank you hanya
Comment 4 hanya 2014-01-16 15:14:11 UTC
Comment 5 Andreas Säger 2014-01-16 16:55:44 UTC
Thank you so much.
Comment 6 Andreas Säger 2018-10-27 10:06:54 UTC
What happened to this improvement? AOO 4.5. falls back to the old defaults with no options checked.
Comment 7 Matthias Seidel 2018-10-31 14:53:13 UTC
I can not confirm your observation.

Menu: Data -> Define Range... -> More opens with option 2 and 3 enabled.

This has been tested with AOO 4.1.5 and 4.1.6-RC1 on Windows 7 and Ubuntu 16.04.5.
Comment 8 Matthias Seidel 2018-10-31 14:54:40 UTC
Created attachment 86536 [details]
Database Range dialog

Options 2 and 3 are enabled by default
Comment 9 Matthias Seidel 2018-11-12 11:55:35 UTC
(In reply to Andreas Säger from comment #6)
> What happened to this improvement? AOO 4.5. falls back to the old defaults
> with no options checked.

Please give us more information why you reopened this issue.

Can someone confirm Andreas' observations?
Comment 10 Andreas Säger 2018-11-30 17:31:40 UTC
OK, it works with manually selected cell ranges but fails with import ranges. Drag some database object from the data source window into a sheet. The resulting database link does not have these options checked.