Minutes from the UX/design meeting 2024-Aug-28

[Heiko Tietze]

Present: Sahil, John, Eyal, Heiko
Comments: Regina, Jim, Ady, Robert

Tickets/Topics

  * Feature Request: Ability to navigate using document page number
    if page 1 starts later in document
    + https://bugs.documentfoundation.org/show_bug.cgi?id=147345
    + special character before the number to go to a "logical" number (Regina)
    + use the title page feature and add a checkbox "Virtual page" (Jim)
      + rather label it "[ ] Include title pages" (Heiko)
    + don't go-to but search-for (Heiko)
    + page number can become more complex (Eyal)
      + PN can have an offset at any place, for example (Heiko)
    + relative/absolute sounds good (John)
    + could be solved per extension (Sahil)
      + though a fundamental feature and rather worth a core function (John)
    + take the "Virtual page" idea, make it a radio button "(o) Absolute page"
      and "( ) Relative page number", show next/prev interaction for the latter
      and go through the document to any page with the respective number
    => do it

  * Draw - no useful scaling factors for English units
    + https://bugs.documentfoundation.org/show_bug.cgi?id=162501
    + 1,2,10,12,16,100 (Heiko)
    + pwr(2), pwr(10), imperial, sqrt(2)... (Eyal)
    + locale dependent (Eyal)
      + sounds like over-engineering (OP)
    + stay away from imperial units (Sahil)
    + make it locale dependent (John)
    + quick solution would be 1,2,5,10,12,24,48,50,100
    + but more flexible input with arbitrary values would be desirable (Eyal)
    => quick solution first, advanced later

  * PIVOTTABLE: Warning does not show range when overwriting destination
    range contents
    + https://bugs.documentfoundation.org/show_bug.cgi?id=162417
    + prevent growth of a pivot table by adding a "locked" attribute (OP)
      + why not just copy/paste the PT then (Ady)
    + when the PT is filtered new data items should be added as hidden (Ady)
      + same concept in case of autofilter but adding new data should show it
        in fact Excel and LibreOffice do show it but add the new value as
        disabled item to the AF
      + some users may expect the opposite, current behavior (Eyal)
      + add a compatibility option (Heiko)
    + use data field options (Heiko)
      + no proper solution (OP)
    + expanding into the next PT is a source of errors and should be
      totally blocked (Eyal, John, Heiko)
    => add option "[x] Enable new items in autofilter", defaulting to on, at
       the autofilter widget
    => consider to block PT expanding into other data (and make it possible
       per advanced option)

  * Improve UX for SQL dialog
    + https://bugs.documentfoundation.org/show_bug.cgi?id=140298
      a) don’t make it a modal dialog
      b) save the list of previous commands at least for the entire session
         + save the commands in the Base file and allow to delete (Robert)
      c) for select statements, display the number of rows returned
    + fully agree to a) and b), with some privacy concerns to b1) (Heiko)
    + status may return the total number of rows, ie. c)
    + could be a nice sidebar (Sahil)
      + Base has no sidebar yet
    + mysql shows the number of rows (Eyal)
    + other tools return results in a way more convenient way (John)
      + 
https://global.discourse-cdn.com/quest/original/2X/c/ce7f3552d4db3d738f17105ad411338b84608553.png
      + 
https://ptgmedia.pearsoncmg.com/images/chap3_9780134131856/elementLinks/03fig01_alt.jpg
    => remember the dialog per session and handle the persistent in the
       document another ticket
    => make the dialog amodal and do show the number of rows
    => fix colors on dark themes

-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_signature.asc
Type: application/pgp-signature
Size: 495 bytes
Desc: OpenPGP digital signature
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20240828/d75dc3cc/attachment.sig>