[Libreoffice-bugs] [Bug 118656] let user choose default options in calc

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118656

--- Comment #4 from Doug <consult.result at gmail.com> ---
(In reply to Mike Kaganski from comment #2)
> Thank you for your report. Yet, there are some problems with it.
> 
> First: it doesn't work like "let me saver options (I don't tell you the
> exact list); *for example* sort". You either list all options you need, or
> even file different reports for each (group of) options. Otherwise, the
> report is about unspecified matter, and thus about nothing.
> 
> Second: there is already such option. It is called "templates". Just save a
> spreadsheet with your preferred options as a template (*.OTS), and
> (optionally) set that template as your default. See online help:
> https://helponline.libreoffice.org/latest/en-US/text/shared/01/01110000.html
> for details.
> 
> Resolving INVALID. Anyway, thank you for your help making LibreOffice better.

Mike Kaganski 

Perhaps I wasn't clear but your suggestion doesn't solve my problem. Your
suggestion makes sense only IF the problem is one where data from the same
source is being re-examined again and again. It fails when the data is coming
from different sources. This seldom the case for me. I am creating new
spreadsheets for one or two analysis and then working with an entirely new data
set. This can happen ten or fifteen times a day.

The problem I was looking to solve was some of the time the data has a range of
column labels sometimes not. Which means when there are labels in the data I
have to go to the window (see the screenshot I included) and select the option
that lets LibreOffice know how to address the top row. I have to do it every
freaking time the data has a set of labels which is most of the time. The
default is the opposite of what I need. If I could override the defaults for
the window in the preferences I could create my own defaults for the data and
not have to futz with those options every time I import or paste a new sheet
into the file.

The problem is not unique to that specific option which is why being able to
set up preferences which actually allow you to control the options in all these
windows would be a boon to mankind.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180712/3d08a7a0/attachment.html>