Have you checked into using the auto filters option? Select all the columns in
the sheet that you want to apply filtering, then go to Data > More Filters and
select AutoFilter.
This will then add a drop down list to each column header that has options for
sorting/searching. It may not be quite
I have a spreadsheet with parts for equipment. It has these columns:
SKU MakeModel TypeSerial
To find a SKU number, I want to be able to have search boxes and enter
the Make and Model and get the resulting search in a list of options
that match.
What feature should I implement
On Sat, 2024-07-20 at 08:36 +0200, Robert Großkopf wrote:
> Am 20.07.24 um 08:16 schrieb Robert Großkopf:
> > Hi Harvey,
> > > >
> > > I don't have mariadb installed on my desktop (which is LOBase
> > > client
> > > connectect via ethernet (hone zone) to mariadb on NAS sever)
> >
> > There
On Sat, 2024-07-20 at 08:16 +0200, Robert Großkopf wrote:
>
> There shouldn't be any difference between MariaDB on a Linux sytem
> connected through localhost or connected from another system in your
> local network.
>
> How did you create the connection to MariaDB to JDBC?
>
> I could
Am 20.07.24 um 08:16 schrieb Robert Großkopf:
Hi Harvey,
I don't have mariadb installed on my desktop (which is LOBase client
connectect via ethernet (hone zone) to mariadb on NAS sever)
There shouldn't be any difference between MariaDB on a Linux sytem
connected through localhost or
Hi Harvey,
I don't have mariadb installed on my desktop (which is LOBase client
connectect via ethernet (hone zone) to mariadb on NAS sever)
There shouldn't be any difference between MariaDB on a Linux sytem
connected through localhost or connected from another system in your
local
What about
=ISERR(SEARCH("Nationwide";B1))+1
> Op 19 jul. 2024, om 23:30 heeft James het volgende
> geschreven:
>
> I want to do something like this now:
> =IF(FIND("Nationwide", B1)>0,1,2)
> It works if "Nationwide" is found in B1 but I get #VALUE! if it is not found.
> I'm guessing because
At 17:30 19/07/2024 -0400, James Lockie wrote:
I want to do something like this now:
=IF(FIND("Nationwide", B1)>0,1,2)
It works if "Nationwide" is found in B1 but I get #VALUE! if it is not found.
I'm guessing because the FIND is not returning a number?
Yes: FIND() itself returns error 519,
I want to do something like this now:
=IF(FIND("Nationwide", B1)>0,1,2)
It works if "Nationwide" is found in B1 but I get #VALUE! if it is not
found.
I'm guessing because the FIND is not returning a number?
On 2024-07-16 23:41, Brian Barker wrote:
At 21:11 16/07/2024 -0400, James Lockie
On Fri, 2024-07-19 at 21:48 +0200, Robert Großkopf wrote:
> Hi Harvey,
>
> tested with LO 24.2.5.2 and MariaDB on OpenSUSE 15.6 64bit rpm Linux.
>
> Works well with internal driver, also with JDBC (mariadb-java-client
> 3.1.3)
>
> Its the same behavior with special version LO 24.2.4.2 fronm
Hi Harvey,
tested with LO 24.2.5.2 and MariaDB on OpenSUSE 15.6 64bit rpm Linux.
Works well with internal driver, also with JDBC (mariadb-java-client 3.1.3)
Its the same behavior with special version LO 24.2.4.2 fronm OpenSUSE
you use.
Note: A funny bug appears: The wizard (JDBC-connection)
On Wed, 2024-07-17 at 09:02 -0400, Java Joe wrote:
> Different databases have different ways of implementing Auto-
> Increment
> or Serial numbers.
>
> I expect this to be related to the database you're using (Mariadb), a
> Base compatibility issue but not really a bug.
>
Until now, in the
On Wed, 2024-07-17 at 09:02 -0400, Java Joe wrote:
> Different databases have different ways of implementing Auto-
> Increment
> or Serial numbers.
>
> I expect this to be related to the database you're using (Mariadb), a
> Base compatibility issue but not really a bug.
>
It hasn't been a
Different databases have different ways of implementing Auto-Increment
or Serial numbers.
I expect this to be related to the database you're using (Mariadb), a
Base compatibility issue but not really a bug.
I have no experience with Mariadb, but expect you can resolve your
problem by running
I wonder if anyone else sees this issue with LOBase. It would be good
to know, if it might be an issue to be addressed to the OpenSUSE forum.
Version: 24.2.4.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 2; OS: Linux 6.4; UI render: default; VCL: gtk3
Locale: en-GB
At 21:11 16/07/2024 -0400, James Lockie wrote:
B1 = Data Nationwide
B2 = =FIND("Nationwide", B1, 0)
I get #VALUE!
Good! Your computer is working properly.
You have asked FIND() to start looking at the zeroth character in the
text, which doesn't exist. The characters are the first, second,
Hi, I changed the third parameter from 0 to 1 and it works
=FIND("Nationwide", B1, 2)
Sent with Proton Mail secure email.
On Wednesday, July 17th, 2024 at 11:11 AM, James wrote:
> B1 = Data Nationwide
> B2 = =FIND("Nationwide", B1, 0)
> I get #VALUE!
>
> --
> To unsubscribe e-mail to:
B1 = Data Nationwide
B2 = =FIND("Nationwide", B1, 0)
I get #VALUE!
--
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
Greetings!
I am running LO 24.2.4.2 on OpenSUSE Leap 156 with LOBase as desktop
client to Mariadb backend on my home network. I wanted to create a new
simple table in LOBase Design View with two columns (logevent as
VARCHAR(100), ID as INT (primary key set)). The ID has AutoValue and
Entry
On Sat, 25 May 2024, Rob Jasper wrote:
Paul,
Yes, you should use a formula as condition.
To use a formula as condition:
Go to Format -> Conditional -> condition -> More rules -> formula:
$C$3=$Sheet1.$A$14
And use A5:J10 as range (if you select the range before defining the
conditional
Paul,
Yes, you should use a formula as condition.
To use a formula as condition:
Go to Format -> Conditional -> condition -> More rules -> formula:
$C$3=$Sheet1.$A$14
And use A5:J10 as range (if you select the range before defining the
conditional formatting LO sets it automatically).
Succes
I've read the docs, and tried several ways, but I cannot seem to
get it right.
I'd like to apply conditional formatting to a group of cells, based
on the value of one cell in the group. Something like
In cell range a5:j10, if the row-N column-C entry is equal
to
On Wed, 15 May 2024 16:14:31 -0300
ady wrote:
> > I would like to get help for LibreOffice
> > portable in Czech. Is it somewhere to download it, please? Best
> > regards
>
> For the (Windows) portable package, the offline help is available in
> English only.
>
> In the LibreOffice download
> I would like to get help for LibreOffice
> portable in Czech. Is it somewhere to download it, please? Best regards
For the (Windows) portable package, the offline help is available in
English only.
In the LibreOffice download site, you could select to download a Help
package to _install_, but
Greetings to the group, I would like to get help for LibreOffice
portable in Czech. Is it somewhere to download it, please? Best regards
--
Jarek
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
Emily,
The following presumes you use Windows.
This is a test to attempt to isolate the problem...
* Use a thumb drive (USB drive) ,
* create and save a file to the thumb drive (use Write, Calc, or whichever
program you use most)
* close the program used to create the file
* eject the thumb
FYI, on Fedora Linux using Libre Office 7.5.9.2 there is a "Restart in Safe
Mode" function on the
"help" pop down menu. About halfway down the menu. If you clicked this is may
have a "leave safe
mode" or equivalent in the same place because I don't have the "Start in Test
Mode" function on
El mié, 06-03-2024 a las 23:16 +0100, Philip Jackson escribió:
> Are you sure this isn't a Windows' problem? Typically it's Windows
> that has stuff blocked and restricted to those with administrator
> privileges.
> Philip
>
> On 06/03/2024 22:56, Emily Scharf wrote:
> > I have used Libreoffice
Are you sure this isn't a Windows' problem? Typically it's Windows that has
stuff blocked and restricted to those with administrator privileges.
Philip
On 06/03/2024 22:56, Emily Scharf wrote:
I have used Libreoffice for years. But recently I downloaded it and -
mistakenly - responded to an
I have used Libreoffice for years. But recently I downloaded it and -
mistakenly - responded to an option for greater security. This turns out
to be 'administrator' which continually blocks me from anything but
read-only documents.
How do I turn off the 'administrator'? I even tried to
Dear LibreOffice team,
Thank you so much for developing this amazing tool.
I am using Python to dynamically write formulas in my LibreOffice file.
However, I am noticing when LibreOffice opens the file, it adds an extra
")" at the end of the formula which results in a bad formula:
Here is my
An error popped up it says, BASIC runtime error. Property or method not found:
CellAddress
I don't know what to do
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Patel
> Date: Monday, 9 October 2023 at 3:03 PM
> To: Dave Howorth , users@global.libreoffice.org
> , documentfoundat...@maxired.fr
> , aguador
> Subject: Re: [libreoffice-users] Help: Convert a Multi-Page Text/word
> file to PNG using LibreOffice API in JAVA Hi folks,
>
> It
...@maxired.fr
, aguador
Subject: Re: [libreoffice-users] Help: Convert a Multi-Page Text/word file to
PNG using LibreOffice API in JAVA
Hi folks,
It would be great if I can get an official response and/or update in the
documentation, so that we can forward the dependency proceedings internally
From: Dave Howorth
Date: Thursday, 28 September 2023 at 1:47 AM
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Help: Convert a Multi-Page Text/word file to
PNG using LibreOffice API in JAVA
EXTERNAL: Use caution when clicking on links or opening attachments.
On Tue, 26 Sep
e.
>
> From: aguador
> Date: Tuesday, 26 September 2023 at 2:49 PM
> To: users@global.libreoffice.org
> Subject: Re: [libreoffice-users] Help: Convert a Multi-Page Text/word
> file to PNG using LibreOffice API in JAVA EXTERNAL: Use caution when
> clicking on links or opening a
-users] Help: Convert a Multi-Page Text/word file to
PNG using LibreOffice API in JAVA
EXTERNAL: Use caution when clicking on links or opening attachments.
El lun, 25-09-2023 a las 04:20 +, Madhu Patel escribió:
> Hey folks!
>
> How to convert a Multi-Page Text file to PNG, for example
El lun, 25-09-2023 a las 04:20 +, Madhu Patel escribió:
> Hey folks!
>
> How to convert a Multi-Page Text file to PNG, for example:- I have a
> Text document of 5 pages and I want to convert that into PNG. By
> default, it's giving a PNG of only 1st page. How to get the PNG file
> for ith
Hey folks!
How to convert a Multi-Page Text file to PNG, for example:- I have a Text
document of 5 pages and I want to convert that into PNG. By default, it's
giving a PNG of only 1st page. How to get the PNG file for ith page using
LibreOffice.
I used the PageRange filter like this, but it
On Fri, 7 Jul 2023 12:40:08 +0100
Dave Howorth wrote:
Hello Dave,
>It's an 8-page document and opens exactly as I would expect with each
>page shown above the next page. I'm not sure how else to expect a
>document to be shown?
Pages can be displayed separate sheets, side by side, or where each
On Thu, 6 Jul 2023 21:19:51 +0100
Brad Rogers wrote:
> On Thu, 6 Jul 2023 20:39:41 +0100
> Budge wrote:
>
> Hello Budge,
>
> >I see the screenshot didn't copy. Is this a settings thing here or
> >rule for the site?
>
> _All_ attachments are stripped.
>
> Document opened fine here. Yes,
Hi Regina,
You have it exactly. Now I have what I want so very many thanks.
Thanks also to all who helped.
All good for now thanks.
Budge.
On 06/07/2023 21:20, Regina Henschel wrote:
Hi Budge,
Budge schrieb am 06.07.2023 um 17:15:
I have downloaded a document from the
With the link, thank you, I see that opening the document always shows me a
full screen view with thumbnails of all seven pages. If that is what you
mean by "it opens to show 7 pages all at once and showing in the same
window" then...
Use the "View > Zoom" menu and select a page view that works
Hi Budge,
Budge schrieb am 06.07.2023 um 17:15:
I have downloaded a document from the VistitBritain/VisitEngland website
which is in which is in a Windows 2007 .docx format.
When I open the document it LibreOffice Writer it opens to show 7 pages
all at once and showing in the same window.
On Thu, 6 Jul 2023 20:39:41 +0100
Budge wrote:
Hello Budge,
>I see the screenshot didn't copy. Is this a settings thing here or
>rule for the site?
_All_ attachments are stripped.
Document opened fine here. Yes, it opened as a single column, but you
can change that by selecting one of the
Which website? There are visitbritain . com and . org
And what file name or document title?
With the above info, others can attempt to open it and solve the problem.
I've tried opening several .docx downloaded from the . org site. All opened
with no issue in LO 6.4.x
On Thu, Jul 6, 2023 at
On 2023-07-06 15:39, Budge wrote:
I see the screenshot didn't copy. Is this a settings thing here or rule for
the site?
The list works in plain text, not HTML, and does not take attachments. If you
want to show a screenshot, best to use a sharing service like Dropbox and cite
the URL.
--
I see the screenshot didn't copy. Is this a settings thing here or rule for
the site?
On 06/07/2023 20:37, Budge wrote:
Hi all,
Sorry I was distracted earlier.
Here is the link:-
Hi all,
Sorry I was distracted earlier.
Here is the link:-
https://www.visitbritain.org/sites/default/files/vb-corporate/business-hub/resources/visitengland_fire_risk_assessment_template_for_tourism_businesses_march2023.docx
opened it in another machine and it opened slightly differently in
On Thu, 6 Jul 2023 16:42:26 +0100
Brad Rogers wrote:
> On Thu, 6 Jul 2023 16:15:34 +0100
> Budge wrote:
>
> Hello Budge,
>
> >How may I break this down into individual pages within the document
> >please so I may work on each page and then page down?
>
> I could only find one .docx file
Brad is doing better than me, may be include the link to be sure we are
on the same page, so to speak.
steve
On 7/07/23 03:15, Budge wrote:
I have downloaded a document from the VistitBritain/VisitEngland
website which is in which is in a Windows 2007 .docx format.
When I open the document it
On Thu, 6 Jul 2023 16:15:34 +0100
Budge wrote:
Hello Budge,
>How may I break this down into individual pages within the document
>please so I may work on each page and then page down?
I could only find one .docx file there and it opened fine.
--
Regards _ "Valid sig separator is
I have downloaded a document from the VistitBritain/VisitEngland website which
is in which is in a Windows 2007 .docx format.
When I open the document it LibreOffice Writer it opens to show 7 pages all at
once and showing in the same window.
How may I break this down into individual pages
On Tue, 6 Jun 2023 10:50:47 +0100
Angeline Ball wrote:
> Hi there,
> I am in a blind panic.
> I am trying to find a writing document I am working on.
> I have saved it at various times but really wanted the last one I
> worked on. I always save it but can’t seem to find it at the moment.
> It
On 6/6/23 2:50 AM, Angeline Ball wrote:
Hi there,
I am in a blind panic.
I am trying to find a writing document I am working on.
I have saved it at various times but really wanted the last one I
worked on.
I always save it but can’t seem to find it at the moment.
It usually appears in my
On 2023-06-06 11:26, Tom wrote:
This is a long shot but maybe use your operating system's file
manager/explorer and sort various folders where you save documents
(Desktop, Documents, etc) by date and see if you can locate the file
that way?
On Linux, you could probably use the find command.
This is a long shot but maybe use your operating system's file
manager/explorer and sort various folders where you save documents
(Desktop, Documents, etc) by date and see if you can locate the file
that way?
Peace...
Tom
On 6/6/23 2:50 AM, Angeline Ball wrote:
Hi there,
I am in a blind
Hi there,
I am in a blind panic.
I am trying to find a writing document I am working on.
I have saved it at various times but really wanted the last one I worked on.
I always save it but can’t seem to find it at the moment.
It usually appears in my desktop I put all of them into a file but when I
Hi Greg,
Am 18.11.2022 um 16:19 schrieb Gregory Forster:
Hi Herald,
I checked your references, but I did not see any profile.
What I did with both computers, I totally deleted LibreOffice,
deleted all references to LibreOffice including the entire folders
C:\Program Files\LibreOffice,
Hi Greg,
Am 18.11.2022 um 16:19 schrieb Gregory Forster:
Hi Herald,
I checked your references, but I did not see any profile.
What I did with both computers, I totally deleted LibreOffice,
deleted all references to LibreOffice including the entire folders
C:\Program Files\LibreOffice,
By any chance, did you start by importing a Power Point?
On 11/11/22 12:34, Gregory Forster wrote:
Hi
Recently, I volunteered to teach computer classes at a senior
center. I'm teaching Excel, Word, Power Point, etc. I'm trying to
promote LibreOffice. I use LibreOffice at home.
Hello Gregory,
I teach LibreOffice class with many students and now they use Impress
7.4 too. All succeeded doing presentations with 20-50 slides without
any crash. However, they all use GNU/Linux. So I can confirm at least
Impress 7.4 works normally on GNU/Linux.
Firstly, could you send your
Hi Gregory,
it's a pity that it doesn't work properly for you.
Please have a look at the points in the following link:
https://wiki.documentfoundation.org/QA/FirstSteps
Test steps 3 and 2 from there, in that order, to see if it brings
improvement.
If this is not helpful, I would ask you to
Hi
Recently, I volunteered to teach computer classes at a senior
center. I'm teaching Excel, Word, Power Point, etc. I'm trying to
promote LibreOffice. I use LibreOffice at home. However, I am having
an extremely difficult time with LibreOffice Impress. After saving after
every new
What version of LO and what operating system do you have.
On 01/09/2022 03:14, Bids BR HVAC wrote:
Why is my LibreOffice Calc doing this?
The dropdown bars are all blacked out.
The number column is all janky. The numbers are stacked on top of each
other and gets worse when I scroll down.
When I
Why is my LibreOffice Calc doing this?
The dropdown bars are all blacked out.
The number column is all janky. The numbers are stacked on top of each
other and gets worse when I scroll down.
When I open Calc there is a big section of the page that turns pink, but
not in any specific spot. It is
On 17 Mar 2022 at 9:49, Dave Barton wrote:
Subject:Re: [libreoffice-users] Help with find &
replace. [SOLVED]
To: users@global.libreoffice.org
From: Dave Barton
Date sent: Thu, 17 Mar 2022 09:49:41 +
> On 16/03/202
On 16/03/2022 16:29, Dave Barton wrote:
> I am looking for a find & replace solution in Writer, where there is a
> blank space as the last character of a paragraph
> (eg. last word ).
Thanks to all who replied.
Dave
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Subject: [EXTERNAL] Re: [libreoffice-users] Help with find & replace.
**EXTERNAL EMAIL**
This email originated outside of The University of Texas at San Antonio.
Please exercise caution when clicking on links or opening attachments.
Hi jomali,
Would you care to elaborate and provide l
sers.
>>
>> Original Message
>> From: Michael D. Setzer II [mailto:msetze...@gmail.com]
>> Sent: Wednesday, March 16, 2022, 20:53 UTC
>> To: Dave Barton; users@global.libreoffice.org
>> Subject: [libreoffice-users] Help with find & replace.
>
3 UTC
> To: Dave Barton; users@global.libreoffice.org
> Subject: [libreoffice-users] Help with find & replace.
>
> > On 16 Mar 2022 at 20:41, Dave Barton wrote:
> >
> > Subject: Re: [libreoffice-users] Help with find &
> > replace.
> > To:
]
Sent: Wednesday, March 16, 2022, 20:53 UTC
To: Dave Barton; users@global.libreoffice.org
Subject: [libreoffice-users] Help with find & replace.
> On 16 Mar 2022 at 20:41, Dave Barton wrote:
>
> Subject: Re: [libreoffice-users] Help with find &
> replace.
> To:
Den ons 16 mars 2022 kl 21:44 skrev Dave Barton :
> On 16/03/2022 20:01, Steve Edmonds wrote:
> >
> >
> > On 17/03/2022 08:34, Dave Barton wrote:
> >> On 16/03/2022 18:27, Brian Barker wrote:
> >>> At 16:29 16/03/2022 +, Dave Barton wrote:
> I am looking for a find & replace solution in
On 16 Mar 2022 at 20:41, Dave Barton wrote:
Subject:Re: [libreoffice-users] Help with find &
replace.
To: users@global.libreoffice.org
From: Dave Barton
Date sent: Wed, 16 Mar 2022 20:41:43 +
> On 16/03/2022 20:01
On 16/03/2022 20:01, Steve Edmonds wrote:
>
>
> On 17/03/2022 08:34, Dave Barton wrote:
>> On 16/03/2022 18:27, Brian Barker wrote:
>>> At 16:29 16/03/2022 +, Dave Barton wrote:
I am looking for a find & replace solution in Writer, where there is a
blank space as the last character
On 17 Mar 2022 at 9:01, Steve Edmonds wrote:
Date sent: Thu, 17 Mar 2022 09:01:42 +1300
Subject:Re: [libreoffice-users] Help with find &
replace.
To: users@global.libreoffice.org
From: Steve Edmonds
>
>
> On 17/
On 16/03/2022 18:27, Brian Barker wrote:
> At 16:29 16/03/2022 +, Dave Barton wrote:
>> I am looking for a find & replace solution in Writer, where there is a
>> blank space as the last character of a paragraph (eg. last word
>> ). In the original OOo and most of the text editors I
>> use the
[:space:]{1,}$ Seemed to work for me in find option and
left replace completely blank. Than replace all.
On 16 Mar 2022 at 16:29, Dave Barton wrote:
To: LibreOffice Users
From: Dave Barton
Subject:[libreoffice-users] Help with find
Den ons 16 mars 2022 kl 17:56 skrev Dave Barton :
> I am looking for a find & replace solution in Writer, where there is a
> blank space as the last character of a paragraph
> (eg. last word ).
>
I think ␊␍ is Windows only, but maybe that doesn't matter in this case.
> In the original OOo and
I am looking for a find & replace solution in Writer, where there is a
blank space as the last character of a paragraph
(eg. last word ).
In the original OOo and most of the text editors I use the simple
solution that worked/works perfectly is:
Find = $ Replace = $
(Note: I use here to represent
Hi Stephen,
On 4/14/21 3:20 PM, STEPHEN COLEMAN wrote:
Fault Module Name: ucrtbase.DLL
The issue is related to ucrtbase.dll, which is a Windows module.
The gift_aid_schedule_libre_.ods file, which is easy to download from
the UK Gov website, opens without any issue if that module is not
Hi -- I need your help.
We successfully downloaded LO 7.1.2.2 and am trying to use it to open an .ODS
file received from UK Inland Revenue that is labelled
'gift_aid_schedule_libre_.ods' however while it opens up the LibreOffice 7.1
Document Recovery and pulls up the document file with the
On 14/05/2020 15:42, Stephan Bergmann wrote:
On 14/05/2020 13:24, asbaeza65 wrote:
Since a little while I sole to install/update libreoffice using
flatpak. It
works just great, but it does not install the help system. Is there
any way
to do that using flatpak?
You explicitly need to install
On 14/05/2020 13:24, asbaeza65 wrote:
Since a little while I sole to install/update libreoffice using flatpak. It
works just great, but it does not install the help system. Is there any way
to do that using flatpak?
You explicitly need to install the
org.libreoffice.LibreOffice.Help extension.
Hello.
Since a little while I sole to install/update libreoffice using flatpak. It
works just great, but it does not install the help system. Is there any way
to do that using flatpak?
Thanks in advice.
--
Sent from:
On 05/12/2019 14:05, Budge wrote:
I have just started to try and learn about templates and I read that to
open the templates manager I should use Ctrl+Shift+E.
Well nothing happened but when I then opened writer for a new document
there was a lower case e underlined at the start of the letter.
I have just started to try and learn about templates and I read that to
open the templates manager I should use Ctrl+Shift+E.
Well nothing happened but when I then opened writer for a new document
there was a lower case e underlined at the start of the letter. I could
not delete it and what is
sc...@valuedinsights.com wrote:
I have unsubscribed numerous times. Stop sending me your junk!
Most of us receiving mail from this list are just other users, like you,
and have no ability to remove you from the list. You should be able to
remove yourself by sending an email to
. Make sure
I have unsubscribed numerous times. Stop sending me your junk!
-Original Message-
From: Harvey Nimmo
Sent: Thursday, July 11, 2019 1:55 PM
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Help with formula - number conversion
On Thu, 2019-07-11 at 14:05 -0400
On Fri, 2019-07-12 at 13:00 -0400, Tanstaafl wrote:
> On Thu Jul 11 2019 15:12:05 GMT-0400 (Eastern Standard Time), Harvey
> Nimmo wrote:
> > Sorry, Tanstaafl!
> >
> > There is a slight error in the above. The formula should read
> > =HOUR(A1)*60+MINUTE(A1)+ROUND(SECOND(A1)/60,0)
> >
> > 'SEC'
At 14:05 11/07/2019 -0400, Charles Marcus wrote:
I need some help with converting a number (in a text field) to a
different type. The type of number is time, and it is in the form
of: hh:mm:ss I need to convert this to just minutes, rounded up, so
if ss is more than 30 it adds another minute.
On Thu Jul 11 2019 15:12:05 GMT-0400 (Eastern Standard Time), Harvey
Nimmo wrote:
> Sorry, Tanstaafl!
>
> There is a slight error in the above. The formula should read
> =HOUR(A1)*60+MINUTE(A1)+ROUND(SECOND(A1)/60,0)
>
> 'SEC' is the secant function. Also 'MIN' would also be wrong since it
>
On Thu, 2019-07-11 at 20:55 +0200, Harvey Nimmo wrote:
> On Thu, 2019-07-11 at 14:05 -0400, Tanstaafl wrote:
> > Hi everyone,
> >
> > I need some help with converting a number (in a text field) to a
> > different type.
> >
> > The type of number is time, and it is in the form of:
> >
> >
On Thu, 2019-07-11 at 14:05 -0400, Tanstaafl wrote:
> Hi everyone,
>
> I need some help with converting a number (in a text field) to a
> different type.
>
> The type of number is time, and it is in the form of:
>
> hh:mm:ss
>
> I need to convert this to just minutes, rounded up, so if ss is
Hi everyone,
I need some help with converting a number (in a text field) to a
different type.
The type of number is time, and it is in the form of:
hh:mm:ss
I need to convert this to just minutes, rounded up, so if ss is more
than 30 it adds another minute.
I'm at a loss as to how to even
On 6-3-2019 17:48, Tom Williams wrote:
On 3/6/19 8:26 AM, Tom Williams wrote:
I know it's odd to ask for Excel help in this mailing list but I need
help locating a LibreOffice Calc function/feature in Excel. :)
I'm helping a friend create a billing invoice and since I'm a Linux
user, I'm
On 3/6/19 5:42 PM, Tom Davies wrote:
> Hi :)
> Sounds like a perfect time to suggest they install LO too.
>
> If an Excel person hadn't immediately found what they were looking for in
> Calc they would have immediately claimed that Calc couldn't do the task.
>
> There are loads of articles about
On 3/6/19 10:18 AM, Luuk wrote:
>
> On 6-3-2019 17:48, Tom Williams wrote:
>> On 3/6/19 8:26 AM, Tom Williams wrote:
>>> I know it's odd to ask for Excel help in this mailing list but I need
>>> help locating a LibreOffice Calc function/feature in Excel. :)
>>>
>>> I'm helping a friend create a
Hi :)
Sounds like a perfect time to suggest they install LO too.
If an Excel person hadn't immediately found what they were looking for in
Calc they would have immediately claimed that Calc couldn't do the task.
There are loads of articles about LO that have such posts in the comments
section.
On 6-3-2019 17:48, Tom Williams wrote:
On 3/6/19 8:26 AM, Tom Williams wrote:
I know it's odd to ask for Excel help in this mailing list but I need
help locating a LibreOffice Calc function/feature in Excel. :)
I'm helping a friend create a billing invoice and since I'm a Linux
user, I'm
1 - 100 of 488 matches
Mail list logo
