[HN Gopher] LibrePythonista allows running IPython code in a Lib...
       ___________________________________________________________________
        
       LibrePythonista allows running IPython code in a LibreOffice
       spreadsheet
        
       Author : buovjaga
       Score  : 114 points
       Date   : 2024-09-04 07:56 UTC (4 days ago)
        
 (HTM) web link (github.com)
 (TXT) w3m dump (github.com)
        
       | buovjaga wrote:
       | Built extension available here:
       | https://extensions.libreoffice.org/en/extensions/show/99231
        
         | mdaniel wrote:
         | I know this comment is a lot of words, and may feel critical,
         | but I assure you I mean them in the spirit of "for your
         | consideration" and want to start off by saying thank you for
         | sharing such a cool toy with the world under a permissive
         | license. Great job, and thank you!
         | 
         | I was trying to find out which version of python it offered,
         | and while digging into that I found surprising references to
         | win32 binaries in the pyproject <https://github.com/Amourspirit
         | /python_libre_pythonista_ext/b...> although the extensions page
         | says it's for all 3 major OSes.
         | 
         | Related to that permalink, please do consider creating a formal
         | tag that represents the code that went into the 0.1.1 binary
         | you linked to. It'll greatly help those trying to track down
         | bugs if they don't have to $(git bisect) in order to find out
         | which sha created the extension they're using
         | 
         | Kind of related to that, future you (and folks who clone your
         | repo) are going to be sad if you keep putting the release
         | artifacts in git, since it will make your repo grow without
         | bound. If you want to make the .oxt available to folks outside
         | of the libreoffice.org URL, that's another fine reason to
         | create a tag since GitHub will cheerfully hold on to the .oxt
         | with a permalink forever, but _outside_ of your repo. It 'll
         | also motivate you, or a contributor, to create a GitHub Action
         | showing how normal people could possibly build the release
         | artifact for themselves
        
           | buovjaga wrote:
           | Ok, can you report that to the developer: https://github.com/
           | Amourspirit/python_libre_pythonista_ext/i...
           | 
           | I'm not affiliated with this project.
        
       | WillAdams wrote:
       | Why not just use pyspread?
       | 
       | https://pyspread.gitlab.io/
        
         | jsyang00 wrote:
         | because they want the sheet in LibreOffice?
        
       | morkalork wrote:
       | I feel like if you're asking how to shove Python into a
       | spreadsheet app, you've made a mistake somewhere in your process
       | and should reconsider everything.
        
         | josenyc wrote:
         | Walk us through your hypothesis. People solve problems in
         | various ways, and workflows can change. Having more options can
         | be useful and lead to new solutions.
        
           | add-sub-mul-div wrote:
           | Unfortunately, main character syndrome can't be cured with
           | talk therapy.
        
             | morkalork wrote:
             | Do you even know what that is or do you just parrot insults
             | you've seen others use?
        
               | SoftMachine wrote:
               | I feel like you've made a mistake somewhere in your
               | process and should reconsider everything.
        
         | dang wrote:
         | " _Please don 't post shallow dismissals, especially of other
         | people's work. A good critical comment teaches us something._"
         | 
         | https://news.ycombinator.com/newsguidelines.html
        
         | mardifoufs wrote:
         | What do you mean? How is it worse than spreadsheet specific
         | languages, like VBA or even in-cell formulas in say, Excel?
        
       | jordigh wrote:
       | If Python in a spreadsheet is what you want, you might like
       | Grist:
       | 
       | https://www.getgrist.com/
       | 
       | Disclaimer: I work there. I'm trying to make it easier to self-
       | host. Send me github issues or pull requests if you have ways of
       | making it better. :)
        
         | abdullahkhalids wrote:
         | I have been meaning to use Grist for an educational org I
         | volunteer for - mainly to manage student data. We would
         | definitely self-host, and it is great that there is already a
         | Class Enrollment template. Your self-hosting docs [1] seem
         | pretty straightforward. However,
         | 
         | * I am annoyed that the the app requires providing inputs
         | through command line args or environment variables rather than
         | a fixed config file that I can store in git. * Some directions
         | on creating a service that starts the app on server restart etc
         | would be good.
         | 
         | [1] https://support.getgrist.com/self-managed/
        
         | slightwinder wrote:
         | Grist is not really a spreadsheet, it's a row-orientated
         | database-system. Quite different in usage.
        
         | guestbest wrote:
         | How does this compare to using something like visual foxpro?
        
       | 2Gkashmiri wrote:
       | shouldn't this functionality be included in the base libreoffice
       | itself? so... just asking, how much efforts would it take to
       | integrate it fully into the code as opposed to an extension? that
       | way more people would use this feature and more people would help
       | improving the code.
       | 
       | good job. need more work done like yours in libreoffice.
        
       | fn-mote wrote:
       | This project has the most incredible, strikingly artistic icon I
       | have ever seen.
       | 
       | It's worth a visit to their landing page just to see it.
       | 
       | I don't need the functionality, but wow.
       | 
       | Edit: I really hope the art wasn't made by an "AI"... but if it
       | was they just passed my Turing test.
        
         | progfix wrote:
         | The design looks very much AI generated.
        
         | BlackLotus89 wrote:
         | It's AI. Have no background information you don't have I think
         | I'm just good at spotting it.
         | 
         | Scales are intricate and seem correct yet the gears are
         | irregular and often not gear shaped, assymetrical etc. Some
         | things look nonsensical and functionless. The circle around has
         | has imperfections and the resolution of the image is too low.
        
         | keyshapegeo99 wrote:
         | The inconsistent teeth on the gears give it away. I'd wager a
         | lot that it's AI generated
        
         | punnerud wrote:
         | Definitely AI, almost all of the gears does not work. A real
         | artist already putting this much effort into it, would never
         | make this mistake
        
           | olejorgenb wrote:
           | > A real artist already putting this much effort into it,
           | would never make this mistake
           | 
           | I'm not so sure that's true. See
           | https://youtu.be/6JwEYamjXpA?t=321 Granted - most of the
           | examples in Matt Parker's talk isn't exactly work of art, but
           | I'm sure effort were put into them.
           | 
           | Edit: I agree the way the cogs don't work in the project's
           | logo is of a different class, so maybe you have point.
        
       | IgorPartola wrote:
       | This is off topic but I feel like Pythonista should have been
       | called Parseltongue. Total missed opportunity.
        
       ___________________________________________________________________
       (page generated 2024-09-08 23:00 UTC)