Re: Nobody Ever Lay On Their Deathbed Thinking ...

On Wed, 8 Jan 2025 22:54:29 -0500, DFS wrote:

On 1/8/2025 4:39 PM, Lawrence D'Oliveiro wrote:

>
s/LO Basic/Basic/

>
VBA makes absolute mincement out of LO Basic.  VBA is built for and
great for manipulating the Office environment and managing data.

What a laugh. I already showed you some more advanced Python code for
working with LibreOffice documents, and your reaction was one of pure
terror and confusion.

It offers much more advanced DBMS functionality than Microsoft Access
can match.

>
Prove this claim in detail, with screenshots and code as needed.

We’ve been through this before. You ran away that time; are you going
to do it again?

<https://help.libreoffice.org/latest/en-US/text/sdatabase/dabawiz00.html?DbPAR=BASE#bm_id2026429>

Plus the form and report designers are bogus.

>
What can Office do that they can’t?

>
*  the Access form designer offers NINE types of autoforms/starters to
    quickly give you a skeleton layout you can then customize
>
    https://imgur.com/5zJKuWM

Interesting: no subform components, just a fixed list.

<https://help.libreoffice.org/latest/en-US/text/shared/autopi/01090000.html?&DbPAR=BASE&System=UNIX>

*  the Access report designer lets you easily add standalone code or
    existing macros to every section of the report (header, footer,
    group/s, detail) or to the report object itself (which code fires
    during report events activate/deactivate, open/close, error, Page,
    NoData).  I couldn't find a way to add LO Basic code to an LO report
    at all.

Maybe you were looking in the wrong place?

<https://help.libreoffice.org/latest/en-US/text/shared/02/01170000.html?&DbPAR=BASE&System=UNIX>

The LO Base reporting functionality is buggy and weird and limited...
just FUBAR:
>
* create a report on a table, save the report, dbl-click to open it and
   it shows the data as expected.  It also says 'This document is open
   in read-only mode.' and there's an 'Edit Document' button.  Click
   that button and it changes into a weird spreadsheet-like edit mode
   where you can make changes to the labels and the data (insert rows,
   delete rows, edit data), but those label changes aren't saved, and
   data edits aren't propagated to the underlying table.  I don't get
   it.

You do realize, forms and reports are two different things?

* LO Base report objects have 10 editable properties and settings.  MS
   Access report objects have 47.
>
* LO Base labels have 16 editable properties; Access report
   labels have 32.
>
* LO Base data fields have 20 editable properties; Access report
   data fields have 39.
>
   https://imgur.com/a/6yaK2q3

LO has a bit more than that.

<https://help.libreoffice.org/latest/en-US/text/shared/guide/data_report.html?&DbPAR=BASE&System=UNIX>

There are many, many oddball bugs and weird behaviors in LO form and
report designers.

I think you just have no clue how to use software that isn’t from
Microsoft.

Face facts: MS is smarter than FOSS and works harder than FOSS.

So why is Microsoft trying to hard to embrace FOSS? And more than
that, to turn Windows into Linux?