Re: Changing default rounding in Writer Tables
I suggest modification to the "format code" of " Number - General " to leave the number exactly as entered, as a simple fix. Good idea, yay nay? From: Dean.Webber <2018001...@student.sit.ac.nz> Sent: Friday, 11 June 2021 11:06 AM To: dev@openoffice.apache.org Subject: Re: Changing default rounding in Writer Tables Thanks everyone. When I tried applying the format to the cells before entering any data, it was overwritten once I entered data. ie. Set cells x1,x2,x3 ect to text -> enter numbers -> then it reverts to number round to two dp. But yeah, I will be changing the default table in styles, great idea 🙂 We all use this powerful program for different uses, and I am very grateful both for your help, and for AOO itself. 😉 Had a quick look through the various styles, not sure which particular style is used for formatting, when editing the styles I could not find the "desired cell formatting" context. Probably in their somewhere, just pressed atm, will have a look in future. Perhaps add into a future feature list somewhere? ie. if user inputs number string to 8 decimal places, then do nothing, unless set to something specific. IE. By default no rounding should occur when I insert a large numerical string, unless I specifically tell the cell I want it rounded to a specific value. It would be better 🙂 From: Jörg Schmidt Sent: Thursday, 10 June 2021 7:13 PM To: dev@openoffice.apache.org Subject: RE: Changing default rounding in Writer Tables > -Original Message- > From: Dean.Webber [mailto:2018001...@student.sit.ac.nz] > Sent: Thursday, June 10, 2021 2:07 AM > To: dev@openoffice.apache.org > Subject: Changing default rounding in Writer Tables > > Dear Devs, > > How hard would it be to change the default rounding in the > tables to the entered value or similar. Or perhaps, can I > change it to accept text as an entry by default (ie in settings)... You can change this as you wish by defining a standard document template for Calc and adjusting the settings there. (a) In the menu: Format-->Styles and Formatting, select the cell template "Default" in the appearing dialog and in the context menu of this template set the desired cell formatting in the tab "Numbers". (b) Then call up the menu: File-Templates-Save and save the document as a template. (c) Finally call: File-Template-Organize, search for the newly saved template, create the context menu and select the entry "Set as default Template". Done. From now on the cell format in all new documents will be as you just set it in (a). Jörg - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Changing default rounding in Writer Tables
Thanks everyone. When I tried applying the format to the cells before entering any data, it was overwritten once I entered data. ie. Set cells x1,x2,x3 ect to text -> enter numbers -> then it reverts to number round to two dp. But yeah, I will be changing the default table in styles, great idea 🙂 We all use this powerful program for different uses, and I am very grateful both for your help, and for AOO itself. 😉 Had a quick look through the various styles, not sure which particular style is used for formatting, when editing the styles I could not find the "desired cell formatting" context. Probably in their somewhere, just pressed atm, will have a look in future. Perhaps add into a future feature list somewhere? ie. if user inputs number string to 8 decimal places, then do nothing, unless set to something specific. IE. By default no rounding should occur when I insert a large numerical string, unless I specifically tell the cell I want it rounded to a specific value. It would be better 🙂 From: Jörg Schmidt Sent: Thursday, 10 June 2021 7:13 PM To: dev@openoffice.apache.org Subject: RE: Changing default rounding in Writer Tables > -Original Message- > From: Dean.Webber [mailto:2018001...@student.sit.ac.nz] > Sent: Thursday, June 10, 2021 2:07 AM > To: dev@openoffice.apache.org > Subject: Changing default rounding in Writer Tables > > Dear Devs, > > How hard would it be to change the default rounding in the > tables to the entered value or similar. Or perhaps, can I > change it to accept text as an entry by default (ie in settings)... You can change this as you wish by defining a standard document template for Calc and adjusting the settings there. (a) In the menu: Format-->Styles and Formatting, select the cell template "Default" in the appearing dialog and in the context menu of this template set the desired cell formatting in the tab "Numbers". (b) Then call up the menu: File-Templates-Save and save the document as a template. (c) Finally call: File-Template-Organize, search for the newly saved template, create the context menu and select the entry "Set as default Template". Done. From now on the cell format in all new documents will be as you just set it in (a). Jörg - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: ppsx file doesn't open and could be fixed
> Have you tested it? No - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Hyperlink Warning Message
Hi Marcus, On 6/10/21 9:29 AM, Marcus wrote: Am 08.06.21 um 11:16 schrieb Matthias Seidel: Find the Windows build here: https://home.apache.org/~mseidel/AOO-builds/AOO-4111-Test/Full%20Installation/Apache_OpenOffice_4.1.11_Win_x86_install_en-US_6652b2eb2e.exe here my results: http://www.openoffice.org/ http://www.openoffice.org/test.exe http://www.openoffice.org/test.ods https://www.openoffice.org/ https://www.openoffice.org/test.exe https://www.openoffice.org/test.ods --> Any HTTP or HTTPS links are opened without warning. smb://www.openoffice.org/ smb://www.openoffice.org/test.exe smb://www.openoffice.org/test.ods file://www.openoffice.org/ file://www.openoffice.org/test.exe file://www.openoffice.org/test.ods --> Any SMB or FILE links get the warning dialog before opening. How can I test with UNO links like ".uno:reload"? The test document I created has a button with a .uno:Reload action. http://home.apache.org/~cmarcum/hyperlink-tests/ Or make a push button using form controls. Set Action to Open document/web page Set URL to .uno:Reload Best regards, Carl Thanks Marcus Am 07.06.21 um 18:09 schrieb Marcus: Am 07.06.21 um 02:12 schrieb Carl Marcum: Hi Arrigo, On 6/6/21 3:56 PM, Arrigo Marchiori wrote: Hello Carl, All, On Sun, Jun 06, 2021 at 11:50:12AM -0400, Carl Marcum wrote: Hi Arrigo and All, On 6/5/21 5:53 PM, Arrigo Marchiori wrote: Hello Carl, All, On Sat, Jun 05, 2021 at 03:47:12PM -0400, Carl Marcum wrote: Hi Arrigo, On 6/5/21 9:50 AM, Arrigo Marchiori wrote: Dear Matthias, Czesław, All, On Sat, Jun 05, 2021 at 12:39:16PM +0200, Matthias Seidel wrote: Hi Czesław, Am 05.06.21 um 12:35 schrieb Czesław Wolański: Hi Matthias, all A preliminary check in Calc (Windows 7, 64-bit) (1) in-document links beginning with # test: button with link to other sheet result: OK (no security warning) (2) .uno:XXX links result: security warning (3) Links to local files test: the "Hyperlink" dialog, button "WWW Browser" result: OK (no security warning) That's what I expected, since the patches are for file:// .uno: hasn't been addressed yet @Arrigo: correct me if I am wrong ;-) You should have just become wrong ;-) I found out that there are many checks on the URL protocol. I suggest that the warning was not checked at the right moment, but too soon. Because we had a report of unexpected _execution_ of malicious links, I suggest we leave the safety check on hyperlinks _just before calling the OS to execute them_. The result is that HTTP, HTTPS, but also "uno:" and all other protocols already understood by AOO are not checked, and no warnings will appear. We could argue that their safety must be assured by the code handling them, as we accepted to delegate the browser for Internet links. The latest commit, just pushed to branch bug128453, moves the check for "safe extensions" (or directory) from the beginning of hyperlinks' processing, to just before the execution of the link target by the OS. The protocol is not checked any more, because supported protocols are already filtered out and processed at that point. This should make all links to non-files work again, and still warn users when they are going to open JAR's, EXE's and other unknown types. What do you think about this? I like your thinking on this. I'll build this branch on Linux and test using some of the test documents and ones I've made to make sure I understand the different cases. Then I'll report back. You can find my 64 bit Linux builds here: https://home.apache.org/~ardovm/openoffice/bug128453/ I tried the "beta" option of the build script... I hope it works. Thank you for your cooperation! Best regards, I've built the bug128453 branch [1] on Linux CentOS 7 and ran the test suite that included the hyperlink tests for the dialogs [2]. I put together some test documents here [3]. Very nice, thank you! [...] So far everything looks good and I get the warning everywhere I expect to with one exception. The smb://nonexistant.url.com link does not display the warning and I get this output: --- This tool has been deprecated, use 'gio open' instead. See 'gio help open' for more info. gio: smb://nonexistant.url.com/: The specified location is not mounted --- Note that I build on CentOS 7 and use --enable-gio and --disable-gnome-vfs in configure. Maybe there is a reason the SMB protocol is treated differently than the others when there is only the host section of the url? I'm not saying this is bad but just different. We can discuss... Sure. The smb:// protocol is treated like file://. A proof of this is that the link to "smb://nonexistant.url.com/evil.jar" shows a warning dialog because the ".jar" extension is not considered safe. For the same reason, f you create a link to "smb://nonexistant.url.com/whatever.ods" it will be opened without warnings. The link you are discussing points to "smb://nonexistant.url.com/". The target ends with a backslash, therefore it is considered a
Re: Ubuntu 21.04 / dark mode
Hi Pedro, Am 30.05.21 um 19:42 schrieb Pedro Lino: > Hi Andrea > > Thank you for the links. FontAwesome requires a paid license to have access > to the SVGs so I guess that excludes it. > Personally I would avoid using something from Google so my choice would be > Remixicon. But I think we need to check which one has the most complete set. > Maybe we need a combination of both themes. I would never want to combine two different icon sets... But for Remixicon: It is open source and icons can be added/requested on GitHub. https://github.com/Remix-Design/remixicon Regards, Matthias > > Grazie mille! > Pedro > >> On 05/30/2021 8:51 AM Andrea Pescetti wrote: >> >> >> Andrea Pescetti wrote: >>> Pedro Lino wrote: > On 05/29/2021 9:32 PM Andrea Pescetti wrote: > https://remixicon.com/ This one is really interesting! Can you share the links to other projects that you have found? >>> FontAwesome https://fontawesome.com/license/free is really popular and >>> CC-BY (but recent versions include a "Pro" section that may have >>> different terms). >>> >>> Google's Material Design Icons ... are >>> AL2, come in different styles and, although the set is already quite >>> comprehensive, are extended by community projects. >> I copy-pasted the same link twice... the correct link to Google's >> Material Design Icons is https://fonts.google.com/icons >> >> Regards, >>Andrea. >> >> - >> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org >> For additional commands, e-mail: dev-h...@openoffice.apache.org > - > To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org > For additional commands, e-mail: dev-h...@openoffice.apache.org > smime.p7s Description: S/MIME Cryptographic Signature
Re: AOo 4.5.0 builds
Hi, Am 03.06.21 um 02:46 schrieb Delio Orozco Gonzalez: > Matthias, Rory and Dean: > > I run in Debian 10 LibreOffice_7.1.3 and AOO_4.5_es together without any > problem. > > I uninstall in Debian 9 LibreOffice and install AOO.4.5-es with "sudo dpkg -i > *.deb" > > I executed from the terminal the "soffice" file and the exit at the terminal > is this: > > delio@debian:/opt/openoffice4/program$ ./soffice > > (soffice:2733): Gtk-WARNING **: Theme directory 32/stutas of theme > Fluent-grey has no size field > > (soffice:2733): Gtk-WARNING **: Theme directory 32@2x/stutas of theme > Fluent-grey has no size field > > (soffice:2733): Gtk-WARNING **: Theme directory 16@3x/status of theme > Fluent-grey has no size field > > (soffice:2733): Gtk-WARNING **: Theme directory 22@3x/mimetypes of theme > Fluent-grey has no size field > > (soffice:2733): Gtk-WARNING **: Theme directory 32@3x/stutas of theme > Fluent-grey has no size field > > I also receive a window with the following error message: > > OpenOffice 4.5.0 - Fatal Error > No se puede iniciar la aplicación. > exception occurred raising singleton > "/singletons/com.sun.star.deployment.ExtensionManager": loading component > library failed: file:///opt/openoffice4/program/../program/deployment.uno.so > > PD: I run in Debian 9 LibreOffice_7.1.3 and AOO_4.2_es together without any > problem. Interesting, since AOO 4.5.0 and AOO 4.2.0 are basically the same... However, we now have fresh builds you may want to test: https://ci.apache.org/projects/openoffice/install/linux64/ Regards, Matthias > > Greetings to all, > > Delio. > > - Mensaje original - > De: "Dean.Webber" <2018001...@student.sit.ac.nz> > Para: "Delio Orozco Gonzalez" , "dev" > > Enviados: Miércoles, 2 de Junio 2021 19:12:52 > Asunto: Re: AOo 4.5.0 builds > > Have you also installed the desktop-integration? > > "Desktop integration. > Desktop integration for deb-based systems requires installation of one > package. > Historically, for rpm based systems, OpenOffice has provided desktop > integration packages for madriva, redhat, suse, and now freedesktop. These > packages are located in the desktop-integrationsubdirectory of the install > directory. > Many desktop window managers like KDE4, Gnome3, and Unity now adhere to the > freedsktop.org standard for icon placement and mime-type definitions. For > this reason, you may want to install the freedesktop desktop integration > package first before trying the others." > > Exerpt from https://www.openoffice.org/download/common/instructions.html > > You may want to purge LibreOffice from your system, to avoid any clashes. > Myself, I really enjoy this step (love it actually!) > > Run in terminal, > > sudo apt-get -y remove --purge libreoffice* > sudo apt-get -y autoremove > > I hope this helps :) > > From: Delio Orozco Gonzalez > Sent: Thursday, 3 June 2021 8:36 AM > To: dev > Subject: Re: AOo 4.5.0 builds > > Hi Mathias: > > I installed so for Debian 10 of this way: sudo dpkg -i *.deb > > Regards, Delio. > > - Mensaje original - > De: "Matthias Seidel" > Para: "dev" > Enviados: Miércoles, 2 de Junio 2021 12:28:51 > Asunto: Re: AOo 4.5.0 builds > > Hi, > > Am 02.06.21 um 04:47 schrieb Delio Orozco Gonzalez: >> Mathias and Rory: >> >> Bad news. AOO_4.5 works in Debian 10, but in Debian 9, when I run the >> application, I receive an error message: >> >> No se puede iniciar la aplicación. >> exception occurred raising singleton >> "/singletons/com.sun.star.deployment.ExtensionManager": loading component >> library failed: file:///opt/openoffice4/program/../program/deployment.uno.so > How did you install? > > Regards, > >Matthias > >> Regards, Delio. >> >> - Mensaje original - >> De: "Matthias Seidel" >> Para: "dev" >> Enviados: Martes, 1 de Junio 2021 17:35:25 >> Asunto: Re: AOo 4.5.0 builds >> >> Hi, >> >> Am 01.06.21 um 23:26 schrieb Delio Orozco Gonzalez: >>> Rory and Mathias: >>> >>> I made a new download and was able to unzip without problem. I was also >>> able to install. >> Great! >> >> Hopefully in the next days there will be a new build available. >> >> We have some other buildbots blocking our machine. ;-) >> >> Regards, >> >>Matthias >> >>> Thanks, >>> >>> Delio. >>> >>> - Mensaje original - >>> De: "Rory O'Farrell" >>> Para: "dev" >>> Enviados: Martes, 1 de Junio 2021 14:01:09 >>> Asunto: Re: AOo 4.5.0 builds >>> >>> On Tue, 1 Jun 2021 13:25:26 -0400 (CDT) >>> Delio Orozco Gonzalez wrote: >>> Hello Mathias and Rory: I unpack the file with "tar vxf" and in the process recieve the next error messages: tar: Fin de fichero inesperado en el archivo tar: rmtlseek no paró en los límites de un registro tar: Error is not recoverable: exiting now >>> If you get a file unpacking error, it is probably because of a bad download >>> and it is unwise to install from that. If tar cannot find the end of th
Re: Hyperlink Warning Message
Hi Keith, Could you provide a test document? Or (if you use Windows) make a test with this build: https://home.apache.org/~mseidel/AOO-builds/AOO-420-Test/Full%20Installation/Apache_OpenOffice_4.2.0_Win_x86_install_en-US_56e2535bb8.exe Regards, Matthias Am 04.05.21 um 16:05 schrieb k...@kshelton.plus.com: > For some years I've had a Reload button in my Calc document to avoid having > to use the File menu. Just updated to 4.1.10 and now I get a message when > pressing Reload button: > > This hyperlink is going to open “.uno:Reload”. Do you want to proceed? > > Is there a way of switching off this message please? > > Thanks. > > Regards > Keith Shelton > > smime.p7s Description: S/MIME Cryptographic Signature
Re: Hyperlink Warning Message
Am 08.06.21 um 11:16 schrieb Matthias Seidel: Find the Windows build here: https://home.apache.org/~mseidel/AOO-builds/AOO-4111-Test/Full%20Installation/Apache_OpenOffice_4.1.11_Win_x86_install_en-US_6652b2eb2e.exe here my results: http://www.openoffice.org/ http://www.openoffice.org/test.exe http://www.openoffice.org/test.ods https://www.openoffice.org/ https://www.openoffice.org/test.exe https://www.openoffice.org/test.ods --> Any HTTP or HTTPS links are opened without warning. smb://www.openoffice.org/ smb://www.openoffice.org/test.exe smb://www.openoffice.org/test.ods file://www.openoffice.org/ file://www.openoffice.org/test.exe file://www.openoffice.org/test.ods --> Any SMB or FILE links get the warning dialog before opening. How can I test with UNO links like ".uno:reload"? Thanks Marcus Am 07.06.21 um 18:09 schrieb Marcus: Am 07.06.21 um 02:12 schrieb Carl Marcum: Hi Arrigo, On 6/6/21 3:56 PM, Arrigo Marchiori wrote: Hello Carl, All, On Sun, Jun 06, 2021 at 11:50:12AM -0400, Carl Marcum wrote: Hi Arrigo and All, On 6/5/21 5:53 PM, Arrigo Marchiori wrote: Hello Carl, All, On Sat, Jun 05, 2021 at 03:47:12PM -0400, Carl Marcum wrote: Hi Arrigo, On 6/5/21 9:50 AM, Arrigo Marchiori wrote: Dear Matthias, Czesław, All, On Sat, Jun 05, 2021 at 12:39:16PM +0200, Matthias Seidel wrote: Hi Czesław, Am 05.06.21 um 12:35 schrieb Czesław Wolański: Hi Matthias, all A preliminary check in Calc (Windows 7, 64-bit) (1) in-document links beginning with # test: button with link to other sheet result: OK (no security warning) (2) .uno:XXX links result: security warning (3) Links to local files test: the "Hyperlink" dialog, button "WWW Browser" result: OK (no security warning) That's what I expected, since the patches are for file:// .uno: hasn't been addressed yet @Arrigo: correct me if I am wrong ;-) You should have just become wrong ;-) I found out that there are many checks on the URL protocol. I suggest that the warning was not checked at the right moment, but too soon. Because we had a report of unexpected _execution_ of malicious links, I suggest we leave the safety check on hyperlinks _just before calling the OS to execute them_. The result is that HTTP, HTTPS, but also "uno:" and all other protocols already understood by AOO are not checked, and no warnings will appear. We could argue that their safety must be assured by the code handling them, as we accepted to delegate the browser for Internet links. The latest commit, just pushed to branch bug128453, moves the check for "safe extensions" (or directory) from the beginning of hyperlinks' processing, to just before the execution of the link target by the OS. The protocol is not checked any more, because supported protocols are already filtered out and processed at that point. This should make all links to non-files work again, and still warn users when they are going to open JAR's, EXE's and other unknown types. What do you think about this? I like your thinking on this. I'll build this branch on Linux and test using some of the test documents and ones I've made to make sure I understand the different cases. Then I'll report back. You can find my 64 bit Linux builds here: https://home.apache.org/~ardovm/openoffice/bug128453/ I tried the "beta" option of the build script... I hope it works. Thank you for your cooperation! Best regards, I've built the bug128453 branch [1] on Linux CentOS 7 and ran the test suite that included the hyperlink tests for the dialogs [2]. I put together some test documents here [3]. Very nice, thank you! [...] So far everything looks good and I get the warning everywhere I expect to with one exception. The smb://nonexistant.url.com link does not display the warning and I get this output: --- This tool has been deprecated, use 'gio open' instead. See 'gio help open' for more info. gio: smb://nonexistant.url.com/: The specified location is not mounted --- Note that I build on CentOS 7 and use --enable-gio and --disable-gnome-vfs in configure. Maybe there is a reason the SMB protocol is treated differently than the others when there is only the host section of the url? I'm not saying this is bad but just different. We can discuss... Sure. The smb:// protocol is treated like file://. A proof of this is that the link to "smb://nonexistant.url.com/evil.jar" shows a warning dialog because the ".jar" extension is not considered safe. For the same reason, f you create a link to "smb://nonexistant.url.com/whatever.ods" it will be opened without warnings. The link you are discussing points to "smb://nonexistant.url.com/". The target ends with a backslash, therefore it is considered a directory, and thus safe. Thanks for pointing this out. I intended it to end without the /. For some reason AOO adds the trailing / for the smb link no matter what I try. But not for the other types. Even in the automated test since it just robots the UI. I've removed the smb link in the test documen
Re: ppsx file doesn't open and could be fixed
Hi, Am 10.06.21 um 11:19 schrieb Bidouille: > Anoying bug: unable to open a PPSX document > https://bz.apache.org/ooo/show_bug.cgi?id=101507 > Seems to be patched with > https://bz.apache.org/ooo/show_bug.cgi?id=111311 > > Somebody could push this fix? :-) Have you tested it? > > > - > To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org > For additional commands, e-mail: dev-h...@openoffice.apache.org > smime.p7s Description: S/MIME Cryptographic Signature
Re: Changing default rounding in Writer Tables
On 2021/06/10 00:07:01, Dean.Webber <2018001...@student.sit.ac.nz> wrote: > Dear Devs, > > How hard would it be to change the default rounding in the tables to the > entered value or similar. Or perhaps, can I change it to accept text as an > entry by default (ie in settings)... > > Just a little time consuming whenever I enter 895.714285 or similar into the > table and have to change the rounding per cell. Otherwise, if it just thinks > text as default this will be better (for my situation). > > Like if I enter 895.714285, would it be hard for writer to be like "oh, > wanting 6 decimal places" instead of being "895.71"... Really bad when > entering 0.8 for example... > > Thanks, > Dean > You can set it as you wish. Select the cells you want to apply the desired format to. Right-click on the table. Choose Number Format, select Number under Category and enter 000.0 in the box Format Code Click the green checkmark next to the box Format Code. That should do it - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
ppsx file doesn't open and could be fixed
Anoying bug: unable to open a PPSX document https://bz.apache.org/ooo/show_bug.cgi?id=101507 Seems to be patched with https://bz.apache.org/ooo/show_bug.cgi?id=111311 Somebody could push this fix? :-) - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
RE: Changing default rounding in Writer Tables
> -Original Message- > From: Dean.Webber [mailto:2018001...@student.sit.ac.nz] > Sent: Thursday, June 10, 2021 2:07 AM > To: dev@openoffice.apache.org > Subject: Changing default rounding in Writer Tables > > Dear Devs, > > How hard would it be to change the default rounding in the > tables to the entered value or similar. Or perhaps, can I > change it to accept text as an entry by default (ie in settings)... You can change this as you wish by defining a standard document template for Calc and adjusting the settings there. (a) In the menu: Format-->Styles and Formatting, select the cell template "Default" in the appearing dialog and in the context menu of this template set the desired cell formatting in the tab "Numbers". (b) Then call up the menu: File-Templates-Save and save the document as a template. (c) Finally call: File-Template-Organize, search for the newly saved template, create the context menu and select the entry "Set as default Template". Done. >From now on the cell format in all new documents will be as you just set it in (a). Jörg - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
