Bug 165229 - [UI] Data provider dialog needs better wording/labels
Summary: [UI] Data provider dialog needs better wording/labels
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.8.0.0 alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsUXEval
Depends on:
Blocks: Data-Provider
  Show dependency treegraph
 
Reported: 2025-02-13 11:40 UTC by Olivier Hallot
Modified: 2025-02-17 18:55 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Data provider dialog (48.77 KB, image/png)
2025-02-13 11:40 UTC, Olivier Hallot
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Olivier Hallot 2025-02-13 11:40:21 UTC
Created attachment 199185 [details]
Data provider dialog

The Data provider dialog needs another look at the labels and the dropdown list 

Go to "Data Provider" in Data tab of the tabbed UI.

Label "Data Provider":
---------------------
This is actually the source data type, so the label should be "Data provider data type" or "Data Provider Type". The current accepted values are CSV, XML, HTML, SQL.

Data Provider dropdown list contents: 
-------------------------------------
The current contents list internal namespaces (?) such as 
org.libreoffice.calc.csv
org.libreoffice.calc.xml
org.libreoffice.calc.sql
org.libreoffice.calc.html

While people can guess the type, it is better to display the right name as "CSV, XML, HTML, SQL", or better "CSV (Comma Separated Values)", "XML (Extensive Markup Language)" and so on.

Label "Id/Xpath":
-----------------
Confusing for newcomers. Id means "table identifyer" in the provider file/URL and Xpath should be "XPath" to follow W3C. I suggest "Table Identifyer or XPath".
Comment 1 Olivier Hallot 2025-02-17 18:55:26 UTC
Furthermore, the transformations names should be rewritten. All operations below are transformations, so no need to repeat the word "Transformation"

Delete Column
Delete Row
Swap Rows
Split Column
Merge Columns
Text Transformation -> Texts
Sort Columns
Aggregate Functions
Number Transformations - Numbers
Replace Null Transformations -> Replace Null Data
Date & Time Transformations -> Date & Time
Find Replace Transformation -> Find & Replace