<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Cloud-connected data types"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116744">116744</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Cloud-connected data types
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Keywords</th>
<td>needsDevEval, needsUXEval
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>tietze.heiko@gmail.com
</td>
</tr>
<tr>
<th>CC</th>
<td>libreoffice-ux-advise@lists.freedesktop.org
</td>
</tr></table>
<p>
<div>
<pre>Microsoft recently announced [1] this new "data type", which is actually a
connection between input in Excel and the proprietary "knowledge graph", and
users start to ask for equivalents [2] (the MS posting was prior to 1st of
April).
The user stories are like this
* Eve enters "Country" in cell A1 (and some countries below like USA, Canada,
Spain, Japan...) and "Population" in cell B1 expecting the function to retrieve
the values from an external source.
* Eve takes names and addresses of her customers and wants to retrieve the
current area codes from an external source.
* Eve enters "Year" in A1 (and 2018..2010 below) and "Football Champion" in B1
and expects the winning teams of her country.
* Eve enters "Element" in A1 and expects a dropdown list of external
information in B1 where she can choose "Molecular Mass".
* Eve wants to know where exactly the external data come from and on what basis
it was collected.
(Dynamical data like stock value or exchange rates are a different type of
information.)
In terms of open source such a feature would be a query to Wikidata (the
sidebar facts at Wikipedia), or any other open and transparent data provider,
which is technically pretty simple. The challenge is to get the right data out
of the external source accepting fuzzy input (like USA instead of United States
of America, or to understand Element as Chemical Element) and the interesting
information itself (the prioritization of locale information in the second
example is artificially).
I think such a function goes beyond the actual scope and should be implemented
as an extension. But that's up for discussion as such data retrieval with full
transparency would be a killer feature.
[1]
<a href="https://techcommunity.microsoft.com/t5/Excel-Blog/Preview-of-Stocks-and-Geography-New-Data-Types-in-Excel/ba-p/176185">https://techcommunity.microsoft.com/t5/Excel-Blog/Preview-of-Stocks-and-Geography-New-Data-Types-in-Excel/ba-p/176185</a>
[2]
<a href="http://nabble.documentfoundation.org/quot-Microsoft-Excel-Is-Going-Beyond-Text-and-Numbers-quot-tt4236894.html">http://nabble.documentfoundation.org/quot-Microsoft-Excel-Is-Going-Beyond-Text-and-Numbers-quot-tt4236894.html</a>
PS: The feature is compared with Lotus Improv [3] and Jvelin [4] but I cannot
follow this derivation idea.
[3] <a href="https://en.wikipedia.org/wiki/Lotus_Improv">https://en.wikipedia.org/wiki/Lotus_Improv</a>
[4] <a href="https://en.wikipedia.org/wiki/Javelin_Software">https://en.wikipedia.org/wiki/Javelin_Software</a></pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>