[libreoffice-users] Relatively new behavior (in 7.2.7)
I've noticed recently that the way the Find (Edit->Find or ^F) feature works in LO 7.2.7 is different - it treats the Find panel as a separate window without actually giving you a separate window, and won't let you do something else, like exit the search, without dismissing the panel. It does allow an escape to dismiss the panel IFF the focus is still in the panel and I'm not trying to do something outside the panel or have already typed . Am I alone in detesting this new "feature?" Am I wrong in seeing this as new? It makes getting out of the search more difficult than it used to be, without the (previous) actual sub-window that makes it clear (and easy to dismiss) that I am not in the same place as outside the search. I use Word now for my book writing (because LO is still not even close to 100% compatible). However, for almost all my spreadsheets and other writing, I prefer LO because I'm used to it. This "feature" drives me up the wall. It makes using "Find and Replace" (^H) a more attractive option. Is it worth a bug or should I find a way to adapt? Mark -- To unsubscribe e-mail to: users+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/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] multiplying time
± is not a time/date value it should be formated as a regular number and would show 8.75 8 hours and 45 minutes Values in time format versus values in number format. 08:45:00 AM 0.3645833 06:00:00 PM 8.75 The 8.75 gets converted to 8 being the number of days, and the .75 is 3/4 of a day being 18 hours, so isn't a time/date value. But is the correct value to multiple by the pay rate. On 13 Aug 2022 at 14:15, bill wrote: From: bill off...@michiganpsychotherapy.com> Date sent:60;Sat, 13 Aug 2022 14:15:55 -0400 Send reply to:will...@techservsys.com Subject: ;Re: [libreoffice-users] multiplying time To: 0;msetze...@gmail.com > On 8/8/2022 10:46 AM, Michael D. Setzer II wrote:> > If I understand > what you are looking at.> > With A1 having 8:45 > > B1 having A1/time(1,0,0) > > B1 would have decimal equivalent of time in hours > > C1 would be B1 * $15 (example rate) > > C1 would be 131.25 (8.75 * 15) > > > > I am missing something. > in B1: A1/ TIME(1,0,0) > If I put 08:45 AM into A1 the result I get is 06:00 PM in B1. > > bill > > > > > > On 8 Aug 2022 at 9:51, bill wrote: > > > > > > From:bill > > Date sent:Mon, 8 Aug 2022 09:51:51 -0400> > Send reply > > to:will...@techservsys.com > > To:users@global.libreoffice.org > > Subject:[libreoffice-users] multiplying time> > > > > >> On a spreadsheet I want to multiply time worked in hh:mm by pay > >> rate (integer) and I can't find out how.> >> > >> Help please. > >> > >> -- > >> Bill Drescher > >> william {at} TechServSys {dot} com > >> > >> -- > >> > >> > >> > > > -- > Bill Drescher > william {at} TechServSys {dot} com > ++ Michael D. Setzer II - Computer Science Instructor (Retired) 60; mailto:mi...@guam.net ; mailto:msetze...@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ ++ -- To unsubscribe e-mail to: users+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/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] LO Base Views and Queries
Hi John, ... MySQL/MariaDB with different drivers will be a new thread - or shouldn't we try it per private mail? ... Robert, I have only been following this thread as a lurker, not contributor, but if I may offer a view on that question: I'm surely not the only person finding this thread educational, and do not see this latest turn as off-topic. However, whether or not you find it appropriate to start a new thread, I do hope you will continue on-list. You are doing the world a service. … and I thought: Base - not much people are interested. In a mailinglist I'm missing the possibility to sort the mails by groups, to see something in screenshots. Better solution for this is something like https://ask.libreoffice.org/tag/base If there is any question related to Base I will (try to) answer also on this mailinglist. Regards Robert -- Homepage: https://www.familiegrosskopf.de/robert -- To unsubscribe e-mail to: users+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/users/ Privacy Policy: https://www.documentfoundation.org/privacy