Re: [libreoffice-design] Agenda for the design/UX meeting 2019-Feb-06 (Wed)
I use only real databases in enterprise and connect them via a webserver to writer cause my main documents are writer files and some basic parameters comes from the databases. The good thing is that I can separate the database stuff from the user stuff. So the user can write the documents, make the layout, ... and can use the values from the databases. You only have to link the file with the database query. I would love to see some improvements in this direction, not only we are not compatible with mso. Nobody like macros so we don't have to copy it but offer an better solution, could improve our situation. Am Mo., 11. Feb. 2019, 03:42 hat Franklin Weng geschrieben: > On February 11, 2019 7:44:49 AM GMT+08:00, Pedro Rosmaninho < > mota.pr...@gmail.com> wrote: > >How do the macros in LO work? I thought they were Basic macros? What's > >the > >difference for the VBA macros of excel? > > > > StarBasic, not Visual basic. Excel VBA cannot directly convert to > StarBasic so they need to be rewritten or recorded again. > > I would suggest using Python to recreate macros instead of using > StarBasic, just that currently there is not many documents available. > > -- > Franklin Weng, Member, Board of Director & Certification Commitee > The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE > > Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts > > Legal details: https://www.documentfoundation.org/imprint > > -- > To unsubscribe e-mail to: design+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/design/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: design+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/design/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-design] Agenda for the design/UX meeting 2019-Feb-06 (Wed)
On February 11, 2019 7:44:49 AM GMT+08:00, Pedro Rosmaninho wrote: >How do the macros in LO work? I thought they were Basic macros? What's >the >difference for the VBA macros of excel? > StarBasic, not Visual basic. Excel VBA cannot directly convert to StarBasic so they need to be rewritten or recorded again. I would suggest using Python to recreate macros instead of using StarBasic, just that currently there is not many documents available. -- Franklin Weng, Member, Board of Director & Certification Commitee The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts Legal details: https://www.documentfoundation.org/imprint -- To unsubscribe e-mail to: design+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/design/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-design] Agenda for the design/UX meeting 2019-Feb-06 (Wed)
Hi Italo, What do you mean when saying Base "is missing the scripting feature"? Surely you can use macros in Base, as well as in other components of LibreOffice. These macros can be written in Baisc, which I have often used, or in some other languages, which I haven't tried myself. And without these surely a database application generally would be very "raw", confined to the basic actions. The work that Base or the the database does is essential for the whole business, and without it nothing would work, but the checks and actions done by the additional programming (using macros or even some sophisticated functions of the database system) are the points that end users can value. They decide about a system being accepted. Now much can be done using Basic macros, which is quite easy. Using them really is adding the salt to the dish. There may be some cases where Basic is too slow, because it is interpreting the code. Then you can use other scripting languages, which I haven't done, but other people speak of it. But there may be a big problem for people used to Access: as far as I understand, macros used in Access cannot be simply transferred to LibreOffice, because the Basic dialects are not completely compatible. I have never had to do with these problems, so I cannot say more, but I fear that this may be the cause for some people to reject trying LibreOffice. Which is a shame because looking at a problem from a new angle is in many cases very helpful. As regards Excel instead of Access or Calc instead of Base: that seems to be a general problem, the practically endless table of Calc/Excel provides the basic features most needed at first sight , without any effort for definition of structures; the difficulties creep in later, and the users try for a very long time to mend the problems, instead of rethinking the situation. This is a general problem, not concerned only with LibreOffice. I can only offer my opinion that in many cases the use of Excel (or Calc) is second best and due to a neglect of deeper investigation, which would have yielded a database solution, but how can we change that? Greetings Gerhard Am 10.02.2019 um 19:08 schrieb Italo Vignoli: I cannot disagree more. In Italy, most enterprises and every public administration are using Microsoft Access, and this represents a problem when they have to migrate to LibreOffice (as Base is not seen as a good replacement for Microsoft Access, because is missing the scripting feature). On 10/02/2019 10:56, Pedro Rosmaninho wrote: Just to mention that Microsoft Access (the equivalent to Base) is barely used in the professional world. Usually companies use Excel and connect it to MySQL or apps like PowerBI depending on the purpose. On Sun, Feb 10, 2019 at 9:40 AM Heiko Tietze wrote: While the idea of the Notebookbar is exactly this, to provide completely different UIs, I doubt we can make Base "a variant of Calc“. But you are very welcome to draft the idea or implement yourself (should be possible for everyone who uses mailing lists). Am 07.02.2019 um 21:26 schrieb Miguel Mayol : I had today a idea i think is a very good one: One interface option - better if it is the default one - in LO BASE equal to the CALC one The reason is that people are using EXCEL for databases because they do not know because they have the cheaper version of MSO without Access and because they think it is "easier" Doing this and a promo viral video that shows that it is - as easy as a spreadsheet to insert and show data - and as powerful as a database to deal with it, especially addressed to university professors and PhD students, probably would increase a lot the use of BASE in substitution of MS Excel for managing databases, and the use of other components of LibreOffice. I went to bugzilla, but I was not able to log in, so sorry, but as I only collaborate with suggestions, I did not want this one that I think is great, and probably very easy to implement, to pass by. I remembered an old database named FileMaker that was very easy to use because it had a interface near to what a spreadsheet is. -- To unsubscribe e-mail to: design+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/design/ Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: design+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/design/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-design] Agenda for the design/UX meeting 2019-Feb-06 (Wed)
How do the macros in LO work? I thought they were Basic macros? What's the difference for the VBA macros of excel? On Sun, Feb 10, 2019 at 10:41 PM Franklin Weng wrote: > On February 11, 2019 2:08:58 AM GMT+08:00, Italo Vignoli < > it...@documentfoundation.org> wrote: > >I cannot disagree more. In Italy, most enterprises and every public > >administration are using Microsoft Access, and this represents a > >problem > >when they have to migrate to LibreOffice (as Base is not seen as a good > >replacement for Microsoft Access, because is missing the scripting > >feature). > > > >On 10/02/2019 10:56, Pedro Rosmaninho wrote: > >> Just to mention that Microsoft Access (the equivalent to Base) is > >barely > >> used in the professional world. > >> Usually companies use Excel and connect it to MySQL or apps like > >PowerBI > >> depending on the purpose. > >> > >> On Sun, Feb 10, 2019 at 9:40 AM Heiko Tietze > >wrote: > >> > >>> While the idea of the Notebookbar is exactly this, to provide > >completely > >>> different UIs, I doubt we can make Base "a variant of Calc“. But you > >are > >>> very welcome to draft the idea or implement yourself (should be > >possible > >>> for everyone who uses mailing lists). > >>> > Am 07.02.2019 um 21:26 schrieb Miguel Mayol : > > I had today a idea i think is a very good one: > > One interface option - better if it is the default one - in LO BASE > >>> equal to the CALC one > > The reason is that people are using EXCEL for databases > because they do not know > because they have the cheaper version of MSO without Access > and because they think it is "easier" > > Doing this and a promo viral video that shows that it is > - as easy as a spreadsheet to insert and show data > - and as powerful as a database to deal with it, > especially addressed to university professors and PhD students, > >probably > >>> would increase a lot the use of BASE in substitution of MS Excel for > >>> managing databases, and the use of other components of LibreOffice. > > I went to bugzilla, but I was not able to log in, so sorry, but as > >I > >>> only collaborate with suggestions, I did not want this one that I > >think is > >>> great, and probably very easy to implement, to pass by. > > I remembered an old database named FileMaker that was very easy to > >use > >>> because it had a interface near to what a spreadsheet is. > >>> > >>> > >>> -- > >>> To unsubscribe e-mail to: design+unsubscr...@global.libreoffice.org > >>> Problems? > >>> > >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > >>> Posting guidelines + more: > >https://wiki.documentfoundation.org/Netiquette > >>> List archive: https://listarchives.libreoffice.org/global/design/ > >>> Privacy Policy: https://www.documentfoundation.org/privacy > >>> > >> > > > > > >-- > >Italo Vignoli - Marketing & PR > >email italo.vign...@documentfoundation.org > >mobile/signal +39.348.5653829 - skype italovignoli > >hangout/jabber italo.vign...@gmail.com > >The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE > >Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts > >Legal details: http://www.documentfoundation.org/imprint > >GPG Key ID - 0xAAB8D5C0 > >DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0 > > > >-- > >To unsubscribe e-mail to: design+unsubscr...@global.libreoffice.org > >Problems? > >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > >Posting guidelines + more: > >https://wiki.documentfoundation.org/Netiquette > >List archive: https://listarchives.libreoffice.org/global/design/ > >Privacy Policy: https://www.documentfoundation.org/privacy > > Currently in enterprise migration there are still two big gaps : Macros > and Databases. IIRC a few years before when we talked about this, the > solutions were that we'd help the customers to use *real* rational > databases like MySQL/Mariadb, …etc., with some simple web interfaces (MySQL > admin?) to replace Access. After all, Access or Base is just(?) front-end > agents of these real databases. > > -- > Franklin Weng, Member, Board of Director & Certification Commitee > The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE > > Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts > > Legal details: https://www.documentfoundation.org/imprint > -- To unsubscribe e-mail to: design+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/design/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-design] Agenda for the design/UX meeting 2019-Feb-06 (Wed)
On February 11, 2019 2:08:58 AM GMT+08:00, Italo Vignoli wrote: >I cannot disagree more. In Italy, most enterprises and every public >administration are using Microsoft Access, and this represents a >problem >when they have to migrate to LibreOffice (as Base is not seen as a good >replacement for Microsoft Access, because is missing the scripting >feature). > >On 10/02/2019 10:56, Pedro Rosmaninho wrote: >> Just to mention that Microsoft Access (the equivalent to Base) is >barely >> used in the professional world. >> Usually companies use Excel and connect it to MySQL or apps like >PowerBI >> depending on the purpose. >> >> On Sun, Feb 10, 2019 at 9:40 AM Heiko Tietze >wrote: >> >>> While the idea of the Notebookbar is exactly this, to provide >completely >>> different UIs, I doubt we can make Base "a variant of Calc“. But you >are >>> very welcome to draft the idea or implement yourself (should be >possible >>> for everyone who uses mailing lists). >>> Am 07.02.2019 um 21:26 schrieb Miguel Mayol : I had today a idea i think is a very good one: One interface option - better if it is the default one - in LO BASE >>> equal to the CALC one The reason is that people are using EXCEL for databases because they do not know because they have the cheaper version of MSO without Access and because they think it is "easier" Doing this and a promo viral video that shows that it is - as easy as a spreadsheet to insert and show data - and as powerful as a database to deal with it, especially addressed to university professors and PhD students, >probably >>> would increase a lot the use of BASE in substitution of MS Excel for >>> managing databases, and the use of other components of LibreOffice. I went to bugzilla, but I was not able to log in, so sorry, but as >I >>> only collaborate with suggestions, I did not want this one that I >think is >>> great, and probably very easy to implement, to pass by. I remembered an old database named FileMaker that was very easy to >use >>> because it had a interface near to what a spreadsheet is. >>> >>> >>> -- >>> To unsubscribe e-mail to: design+unsubscr...@global.libreoffice.org >>> Problems? >>> >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >>> Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >>> List archive: https://listarchives.libreoffice.org/global/design/ >>> Privacy Policy: https://www.documentfoundation.org/privacy >>> >> > > >-- >Italo Vignoli - Marketing & PR >email italo.vign...@documentfoundation.org >mobile/signal +39.348.5653829 - skype italovignoli >hangout/jabber italo.vign...@gmail.com >The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE >Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts >Legal details: http://www.documentfoundation.org/imprint >GPG Key ID - 0xAAB8D5C0 >DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0 > >-- >To unsubscribe e-mail to: design+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/design/ >Privacy Policy: https://www.documentfoundation.org/privacy Currently in enterprise migration there are still two big gaps : Macros and Databases. IIRC a few years before when we talked about this, the solutions were that we'd help the customers to use *real* rational databases like MySQL/Mariadb, …etc., with some simple web interfaces (MySQL admin?) to replace Access. After all, Access or Base is just(?) front-end agents of these real databases. -- Franklin Weng, Member, Board of Director & Certification Commitee The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts Legal details: https://www.documentfoundation.org/imprint -- To unsubscribe e-mail to: design+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/design/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-design] Agenda for the design/UX meeting 2019-Feb-06 (Wed)
I cannot disagree more. In Italy, most enterprises and every public administration are using Microsoft Access, and this represents a problem when they have to migrate to LibreOffice (as Base is not seen as a good replacement for Microsoft Access, because is missing the scripting feature). On 10/02/2019 10:56, Pedro Rosmaninho wrote: > Just to mention that Microsoft Access (the equivalent to Base) is barely > used in the professional world. > Usually companies use Excel and connect it to MySQL or apps like PowerBI > depending on the purpose. > > On Sun, Feb 10, 2019 at 9:40 AM Heiko Tietze wrote: > >> While the idea of the Notebookbar is exactly this, to provide completely >> different UIs, I doubt we can make Base "a variant of Calc“. But you are >> very welcome to draft the idea or implement yourself (should be possible >> for everyone who uses mailing lists). >> >>> Am 07.02.2019 um 21:26 schrieb Miguel Mayol : >>> >>> I had today a idea i think is a very good one: >>> >>> One interface option - better if it is the default one - in LO BASE >> equal to the CALC one >>> >>> The reason is that people are using EXCEL for databases >>> because they do not know >>> because they have the cheaper version of MSO without Access >>> and because they think it is "easier" >>> >>> Doing this and a promo viral video that shows that it is >>> - as easy as a spreadsheet to insert and show data >>> - and as powerful as a database to deal with it, >>> especially addressed to university professors and PhD students, probably >> would increase a lot the use of BASE in substitution of MS Excel for >> managing databases, and the use of other components of LibreOffice. >>> >>> I went to bugzilla, but I was not able to log in, so sorry, but as I >> only collaborate with suggestions, I did not want this one that I think is >> great, and probably very easy to implement, to pass by. >>> >>> I remembered an old database named FileMaker that was very easy to use >> because it had a interface near to what a spreadsheet is. >> >> >> -- >> To unsubscribe e-mail to: design+unsubscr...@global.libreoffice.org >> Problems? >> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette >> List archive: https://listarchives.libreoffice.org/global/design/ >> Privacy Policy: https://www.documentfoundation.org/privacy >> > -- Italo Vignoli - Marketing & PR email italo.vign...@documentfoundation.org mobile/signal +39.348.5653829 - skype italovignoli hangout/jabber italo.vign...@gmail.com The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts Legal details: http://www.documentfoundation.org/imprint GPG Key ID - 0xAAB8D5C0 DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0 -- To unsubscribe e-mail to: design+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/design/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-design] Agenda for the design/UX meeting 2019-Feb-06 (Wed)
Just to mention that Microsoft Access (the equivalent to Base) is barely used in the professional world. Usually companies use Excel and connect it to MySQL or apps like PowerBI depending on the purpose. On Sun, Feb 10, 2019 at 9:40 AM Heiko Tietze wrote: > While the idea of the Notebookbar is exactly this, to provide completely > different UIs, I doubt we can make Base "a variant of Calc“. But you are > very welcome to draft the idea or implement yourself (should be possible > for everyone who uses mailing lists). > > > Am 07.02.2019 um 21:26 schrieb Miguel Mayol : > > > > I had today a idea i think is a very good one: > > > > One interface option - better if it is the default one - in LO BASE > equal to the CALC one > > > > The reason is that people are using EXCEL for databases > > because they do not know > > because they have the cheaper version of MSO without Access > > and because they think it is "easier" > > > > Doing this and a promo viral video that shows that it is > > - as easy as a spreadsheet to insert and show data > > - and as powerful as a database to deal with it, > > especially addressed to university professors and PhD students, probably > would increase a lot the use of BASE in substitution of MS Excel for > managing databases, and the use of other components of LibreOffice. > > > > I went to bugzilla, but I was not able to log in, so sorry, but as I > only collaborate with suggestions, I did not want this one that I think is > great, and probably very easy to implement, to pass by. > > > > I remembered an old database named FileMaker that was very easy to use > because it had a interface near to what a spreadsheet is. > > > -- > To unsubscribe e-mail to: design+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/design/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: design+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/design/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-design] Agenda for the design/UX meeting 2019-Feb-06 (Wed)
While the idea of the Notebookbar is exactly this, to provide completely different UIs, I doubt we can make Base "a variant of Calc“. But you are very welcome to draft the idea or implement yourself (should be possible for everyone who uses mailing lists). > Am 07.02.2019 um 21:26 schrieb Miguel Mayol : > > I had today a idea i think is a very good one: > > One interface option - better if it is the default one - in LO BASE equal to > the CALC one > > The reason is that people are using EXCEL for databases > because they do not know > because they have the cheaper version of MSO without Access > and because they think it is "easier" > > Doing this and a promo viral video that shows that it is > - as easy as a spreadsheet to insert and show data > - and as powerful as a database to deal with it, > especially addressed to university professors and PhD students, probably > would increase a lot the use of BASE in substitution of MS Excel for managing > databases, and the use of other components of LibreOffice. > > I went to bugzilla, but I was not able to log in, so sorry, but as I only > collaborate with suggestions, I did not want this one that I think is great, > and probably very easy to implement, to pass by. > > I remembered an old database named FileMaker that was very easy to use > because it had a interface near to what a spreadsheet is. -- To unsubscribe e-mail to: design+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/design/ Privacy Policy: https://www.documentfoundation.org/privacy