Some improvements

classic Classic list List threaded Threaded
3 messages Options
Miguel Verdú Miguel Verdú
Reply | Threaded
Open this post in threaded view
|

Some improvements

Hi everyone,

First of all I want to congrats for your work with LibreOffice design and
propousals about. I'm just a simple "expert" user of Openoffice.org (before)
and LibreOffice (now), I've migrate from MS Office to OpenOffice/Libreoffice
in three spanish companies, a total of about 60 terminals with Libreoffice
(in differents OS). Second, I would like to say sorry about my english...
;-(  (I'm working on it). And third ... I have some improvements sugestions
about the user interface:


   1. One of the main complaints I have receibed from the users of these
   companies is: "Libreoffice is very slow charging the first time..." NO
   COMENT, one litle solution: I think it could be good to have by default the
   autostart load libreoffice libraris option selected.
   2. The current color selector is very limited, In our company we need to
   use the corporate colors and of course these colors are not in the default
   color selector. We know we can add it in Tools/Options/Libreoffice/Colors,
   but its very unconfortable because I have to do in a lot of computers, and
   every time we update the Libreoffice version, the colors have gone!.... I
   think it would be more productive to change the color selector. I'd like to
   have several tabs when I select a color (for a table, text, background,
   ...), at least: RGB selector, CMYK selector,  HTML color code, Circle color
   selector... (I add few images: colors_cmyk.png, colors_roda.png,
   colors_paleta.png)
   3. A Zebra button: I think it could be nice to have a "zebra" button in
   writer, calc and impress for autoformat tables with two colors and make more
   easy readible the data. The procidemt could be the next: 1º We select the
   cells we want to format of a table. 2º we push the zebra button and a color
   dialog apears. 3º we select the color we want (this could be the dark). 4º
   then the cells we have selected have changed the background color
   alternatively by rows, one row with the color we have choose and the next
   with the same color but  up L level (L of HSL color value "lighter").
   4. CALC: Multiple easy filter selector (multiple_selection_filter.png)
   5. BASE: I think it must be easy to add several table sources for the
   same .odb file, for example: one table indeed in the same odb file, other
   from mysql server, and other from a xls file.... (linked_tables.png)
   6. BASE: It could be easier and quickly to create buttons with a similar
   MSAccess wizard that automaticlly generate the code. Create button: for
   reports (open a report in preview mode, print a report, ...) / for records
   (erase a record, create new record, duplicate this record...) / for forms
   (close this form / open other form / ...)
   7. I tried to send you all these recomendations by the wiki or the main
   Libreoffice official site, but I didn't find the right place! I think it
   could be awesome to creat one space at one website called brainstorm where
   the user can make suggestions like these ones. If this site exits it's not
   easy enought to send the improvements suggestions


Tanks for read me and sorry If this mail shouldn't have been send to you....
I would appreciate you send it to the right person.


See you

--
Unsubscribe instructions: E-mail to [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/design/
All messages sent to this list will be publicly archived and cannot be deleted

Christoph Noack Christoph Noack
Reply | Threaded
Open this post in threaded view
|

Re: Some improvements

Hi Miguel,

thanks for your mail. I'll try to address your comments as good as I
can ... and by the way, the mailing list doesn't allow attachments, so I
can only guess what you've sent.

Am Freitag, den 30.09.2011, 16:39 +0200 schrieb Miguel Verdú:
> Hi everyone,
>
> First of all I want to congrats for your work with LibreOffice design and
> propousals about. I'm just a simple "expert" user of Openoffice.org (before)
> and LibreOffice (now), I've migrate from MS Office to OpenOffice/Libreoffice
> in three spanish companies, a total of about 60 terminals with Libreoffice
> (in differents OS).

Very cool, thanks!!!

> Second, I would like to say sorry about my english...
> ;-(  (I'm working on it). And third ... I have some improvements sugestions
> about the user interface:

Oh, there is something that can be improved :-)

>    1. One of the main complaints I have receibed from the users of these
>    companies is: "Libreoffice is very slow charging the first time..." NO
>    COMENT, one litle solution: I think it could be good to have by default the
>    autostart load libreoffice libraris option selected.

I searched in the bug reports and found:
https://bugs.freedesktop.org/show_bug.cgi?id=31206#c2

I don't know exactly the reasons, so I propose that you write a bug
report mentioning the feedback you've got. For the meantime, is there
any way for you tweaking the config settings for all the computers in
the company?


>    2. The current color selector is very limited, In our company we need to
>    use the corporate colors and of course these colors are not in the default
>    color selector. We know we can add it in Tools/Options/Libreoffice/Colors,
>    but its very unconfortable because I have to do in a lot of computers, and
>    every time we update the Libreoffice version, the colors have gone!.... I
>    think it would be more productive to change the color selector. I'd like to
>    have several tabs when I select a color (for a table, text, background,
>    ...), at least: RGB selector, CMYK selector,  HTML color code, Circle color
>    selector... (I add few images: colors_cmyk.png, colors_roda.png,
>    colors_paleta.png)

Yes, we know that the color stuff is limited ... there are a few
improvements on the way. From the Release Notes 3.5 (DRAFT!) page:
        "Template creator:
        LibreOffice Writer implements a new concept of template creator.
        Users can easily create a template by inserting a title page and
        designing it, by specifying the headings format and their
        numbering style. Templates will include color sets and they can
        be directly shared with other users through the
        Documentfoundation template server. Included a colour set
        switcher to easily change the template colors."

And:
        The color picker that is available eg. in Tools -> Options ->
        Colors, press Edit has been rewritten to be more modern, and
        usable. See the video how it works here:
        http://www.youtube.com/watch?v=rPu6EmIxkIM&hd=1 (Christian
        Lippka)

Furthermore, a developer and I started to collect some issues to rework
the color selection - unfortunately, both of us have *very* limited time
for that (sorry!):
        http://wiki.documentfoundation.org/Design/Whiteboards/Color_Handling

I hope that already helps a bit...


>    3. A Zebra button: I think it could be nice to have a "zebra" button in
>    writer, calc and impress for autoformat tables with two colors and make more
>    easy readible the data. The procidemt could be the next: 1º We select the
>    cells we want to format of a table. 2º we push the zebra button and a color
>    dialog apears. 3º we select the color we want (this could be the dark). 4º
>    then the cells we have selected have changed the background color
>    alternatively by rows, one row with the color we have choose and the next
>    with the same color but  up L level (L of HSL color value "lighter").

Okay, Impress has such a feature since quite some time.

For Calc, the current workaround is to use a formula and conditional
formatting (awkward, but works).

For Writer, there is no such solution at the moment.

My proposal: please write but reports (for enhancements), so that the
developers know what is important for users.


>    4. CALC: Multiple easy filter selector (multiple_selection_filter.png)

What are you referring to? Since I don't see the attachment, its hard to
guess - Markus implemented some cool improvements to allow more than one
AutoFilter.

>    5. BASE: I think it must be easy to add several table sources for the
>    same .odb file, for example: one table indeed in the same odb file, other
>    from mysql server, and other from a xls file.... (linked_tables.png)

Sorry, I'm not a base expert :-\

>    6. BASE: It could be easier and quickly to create buttons with a similar
>    MSAccess wizard that automaticlly generate the code. Create button: for
>    reports (open a report in preview mode, print a report, ...) / for records
>    (erase a record, create new record, duplicate this record...) / for forms
>    (close this form / open other form / ...)

>    7. I tried to send you all these recomendations by the wiki or the main
>    Libreoffice official site, but I didn't find the right place! I think it
>    could be awesome to creat one space at one website called brainstorm where
>    the user can make suggestions like these ones. If this site exits it's not
>    easy enought to send the improvements suggestions

True, something like that is missing. On the other hand, the development
is currently busy with lots of different stuff - so even if we had such
a site, it wouldn't help much. At the moment - but we keep that in mind.
Some of us even worked towards such an approach during the
OpenOffice.org times.

For now, such enhancement requests can be raised via bugs.

> Tanks for read me and sorry If this mail shouldn't have been send to you....
> I would appreciate you send it to the right person.

Well, I hope you got the feeling that I could help somehow ...

Cheers,
Christoph


--
Unsubscribe instructions: E-mail to [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/design/
All messages sent to this list will be publicly archived and cannot be deleted
Jay Lozier Jay Lozier
Reply | Threaded
Open this post in threaded view
|

Re: Some improvements

In reply to this post by Miguel Verdú
On Fri, 2011-09-30 at 16:39 +0200, Miguel Verdú wrote:

> Hi everyone,
>
> First of all I want to congrats for your work with LibreOffice design and
> propousals about. I'm just a simple "expert" user of Openoffice.org (before)
> and LibreOffice (now), I've migrate from MS Office to OpenOffice/Libreoffice
> in three spanish companies, a total of about 60 terminals with Libreoffice
> (in differents OS). Second, I would like to say sorry about my english...
> ;-(  (I'm working on it). And third ... I have some improvements sugestions
> about the user interface:
>
>
>    1. One of the main complaints I have receibed from the users of these
>    companies is: "Libreoffice is very slow charging the first time..." NO
>    COMENT, one litle solution: I think it could be good to have by default the
>    autostart load libreoffice libraris option selected.
>    2. The current color selector is very limited, In our company we need to
>    use the corporate colors and of course these colors are not in the default
>    color selector. We know we can add it in Tools/Options/Libreoffice/Colors,
>    but its very unconfortable because I have to do in a lot of computers, and
>    every time we update the Libreoffice version, the colors have gone!.... I
>    think it would be more productive to change the color selector. I'd like to
>    have several tabs when I select a color (for a table, text, background,
>    ...), at least: RGB selector, CMYK selector,  HTML color code, Circle color
>    selector... (I add few images: colors_cmyk.png, colors_roda.png,
>    colors_paleta.png)
>    3. A Zebra button: I think it could be nice to have a "zebra" button in
>    writer, calc and impress for autoformat tables with two colors and make more
>    easy readible the data. The procidemt could be the next: 1º We select the
>    cells we want to format of a table. 2º we push the zebra button and a color
>    dialog apears. 3º we select the color we want (this could be the dark). 4º
>    then the cells we have selected have changed the background color
>    alternatively by rows, one row with the color we have choose and the next
>    with the same color but  up L level (L of HSL color value "lighter").
>    4. CALC: Multiple easy filter selector (multiple_selection_filter.png)
>    5. BASE: I think it must be easy to add several table sources for the
>    same .odb file, for example: one table indeed in the same odb file, other
>    from mysql server, and other from a xls file.... (linked_tables.png)

Are you wanting to import data from several sources directly into a
database?

For example the data in a spreadsheet becomes the data in table using a
wizard with very few steps. The steps would be navigate and select the
spreadsheet, select the correc worksheet, and then import into the
correct table. There might be an option to either update or over write
the existing data. The user would not need to know SQL to import the
data. I suggest you submit a feature request / bug report describing
this.

AFAIK there is not a database engine that will link directly to
different data sources. My understanding is that the various databases
are not compatible wth each other, eg PostgreSQL can not directly
understand a MySQL/MariaDB table. It is not a requirement that they be
compatible for SQL to be implemented, only that their APIs and other
interfaces be defined so that users can write valid queries for that
engine. The way to import/export data in many is to use txt or csv
files. You might find a database engine that is compatible with another
database such as Mariadb with MySQL, but is a initial design criteria.
Base use HyperSQL as its embedded engine. One work around this problem
is use MySQL as the backend engine - this would eliminate the problem of
different database engines being incompatible. I personally prefer this
method even a single user system.

You may want to post your Base questions to the Users list to see if
anyone has a workaround they could share. If you do post please provide
the OS(s) used and the LO versions installed.


> 6. BASE: It could be easier and quickly to create buttons with a similar
>    MSAccess wizard that automaticlly generate the code. Create button: for
>    reports (open a report in preview mode, print a report, ...) / for records
>    (erase a record, create new record, duplicate this record...) / for forms
>    (close this form / open other form / ...)

Please submit a feature request / bug report for this. This would be a
nice feature for many users.

> 7. I tried to send you all these recomendations by the wiki or the main
>    Libreoffice official site, but I didn't find the right place! I think it
>    could be awesome to creat one space at one website called brainstorm where
>    the user can make suggestions like these ones. If this site exits it's not
>    easy enought to send the improvements suggestions
>
>
> Tanks for read me and sorry If this mail shouldn't have been send to you....
> I would appreciate you send it to the right person.
>
>
> See you
>



--
Jay Lozier
[hidden email]

--
Unsubscribe instructions: E-mail to [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/design/
All messages sent to this list will be publicly archived and cannot be deleted