Re: [libreoffice-design] Some improvements

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
jslozier@gmail.com

-- 
Unsubscribe instructions: E-mail to design+help@global.libreoffice.org
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