Issue 123725 - [Enhancement] Better defaults for database range dialog
Summary: [Enhancement] Better defaults for database range dialog
Status: REOPENED
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:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
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: ---

Attachments
Database Range dialog (14.70 KB, image/png)
2018-10-31 14:54 UTC, Matthias Seidel 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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:
https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=65861 
[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 
Fixed.
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.