<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 - Interactive-type macros"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132266">132266</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Interactive-type macros
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.5.2 release
</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>Severity</th>
<td>enhancement
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>framework
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>r.a.scarfe@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
Conda and jupyter are integral parts of Python's ascendancy in data science,
and neither are python-specific tools.
I have a proposal in two parts:
* Add a core option for macros in Calc "Tools" -> "Macros" -> "Interactive" ->
"Python" that launches the bundled python repl and automatically includes the
local variable "document" as web browsers consoles do. When I exit the REPL I
should get an option to save my session as a macro.
* Add an extension that adds a jupyter kernel from a conda environment
installed outside libreoffice installation. There are graphical tools to manage
this such as Continuum Analytics' Anaconda Navigator. There are many jupyter
kernels available: <a href="https://github.com/jupyter/jupyter/wiki/Jupyter-kernels">https://github.com/jupyter/jupyter/wiki/Jupyter-kernels</a>. I
wouldn't expect a first implementation to provide libreoffice bindings for any
of these externally managed kernels.
This feature request represents is intended to document the minimum level of
support I would need as a dabbler in order to make LibreOffice a first option
for exploratory data science instead of opening up a jupyter notebook.
Steps to Reproduce:
Open up "Tools" -> "Macros" -> "Organise Macros" -> "Python..."
Actual Results:
As someone with a deep level of familiarity with the python REPL as a
calculator that's easy to jump into I fail to find anywhere to start writing
python commands and get confused as to why it seems so hard to start a new
macro.
Expected Results:
I can follow my nose and get to a REPL, then save my session as a macro after
I'm done.
Reproducible: Always
User Profile Reset: No
Additional Info:
I love LibreOffice but I am yet to use it as part of my daily workflow. Python
has no obvious GUI user story for beginners but being bundled with LibreOffice
means that it should be celebrated by the python community, whereas instead
it's complex and not idiomatic to ask a beginner to write "Hello World!".</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>