Date: prev next · Thread: first prev next last
2021 Archives by date, by thread · List index

Hi Heiko,

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 <>  Please correct me if I'm
wrong or if you have additional inputs.

Vikas Mahato

On Wed, Mar 24, 2021 at 3:05 PM Heiko Tietze <> wrote:

Hi Vikas,

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
Gsoc 2018
a complete list of which can be found in this blog post along with the
gerrit links.

I had a discussion with Markus about trying to make it available to
users of
Libreoffice and so we want to make all transformations accessible from
the UI
through a shared menu entry.

Any input from the UX team on how this can be done would be greatly

Vikas Mahato

LibreOffice mailing list

Dr. Heiko Tietze, UX-Designer and UX-Mentor
Tel: +49 30 5557992-63 | Mail:
The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE
Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts
Legal details:

LibreOffice mailing list

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.