Let me give you more context.
Data transformations were primarily designed to be used with Data > Data
Provider. It is currently not visible as an option because the UI is not
production ready yet.
So there are a couple of things I am hoping to work on.
1. Create a more usable UI for Data Providers so that the feature can be
shipped to production. However, that would be a big task and I am hoping
someone would pick up the task as part of this year's Gsoc. I think a
discussion with the UX team would be necessary to come up with a decent
design proposal that is also implementable.
2. The areas you mentioned *Data > Streams, Data > XML Source, Sheet > Link
to External Data* also seem good areas where we can make use of data
transformations. However, if I'm not wrong, we can maybe merge them into a
single Data > Data Provider once the UI is ready as it was designed to
import and refresh data from html, csv, xml, sql, etc.
My mentor, Markus pointed out that maybe instead of waiting for the UI to
complete, we can ship the data transformations to the users. He gave me an
example as follows:
*Take already the issue of removing a common prefix or suffix from a column
and converting the data to numbers after importing some data. This is a
surprisingly common issue when you have to deal with external data and yet
unless you add additional columns with complex formulas it is surprisingly
I tried doing it myself and indeed it is complex.
So, we were thinking if we can give the user an option to apply
transformations to existing data once they are imported (be it *Data >
Streams, Data > XML Source or Sheet > Link to External Data*).
We can then reuse this code when full Data > Data Provider is ready.
I hope this clarifies things.
@Markus Mohrhard <firstname.lastname@example.org> Please correct me if I'm
wrong or if you have additional inputs.
On Wed, Mar 24, 2021 at 3:05 PM Heiko Tietze <
sorry for the late answer, was hoping for a smarter reply. Thing is, it's
unclear to me when and where these transformations can be applied. Rough
Data > Streams... (and in this dialog you want to allow transformations to
data), or Data > XML Source..., or Sheet > Link to External Data... So
give us more details about the supposed workflow, the scenario, and the
In other words who, when, where.
PS: X-Post to the design ML, which would be the better choice for
On 18.03.21 12:56, Vikas Mahato wrote:
I had implemented a bunch of Data transformations for Calc as part of
a complete list of which can be found in this blog post along with the
I had a discussion with Markus about trying to make it available to
Libreoffice and so we want to make all transformations accessible from
through a shared menu entry.
Any input from the UX team on how this can be done would be greatly
LibreOffice mailing list
Dr. Heiko Tietze, UX-Designer and UX-Mentor
Tel: +49 30 5557992-63 | Mail: email@example.com
The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE
Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts
Legal details: https://www.documentfoundation.org/imprint
LibreOffice mailing list
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/design/
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy