[libreoffice-users] chart help

[James]

I have 2 questions related to charts.
Say I have 2 columns: date and value
2 Rows Jan, 1
and Mar 3.

Q1. I want the x-axis to increment by month.

Q2. I want to only display the x-axis labels for the data points I have.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] chart help

[James]

I have 2 questions related to charts.
Say I have 2 columns: date and value
2 Rows Jan, 1
and Mar 3.

Q1. I want the x-axis to increment by month.

Q2. I want to only display the x-axis labels for the data points I have.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] chart help

[James]

On 01/26/14 11:29, Brian Barker wrote:
 At 00:54 25/01/2014 -0500, James Lockie wrote:
 I have 2 questions related to charts.  Say I have 2 columns: date and value  
 2 Rows Jan, 1 and Mar 3.

 Q1. I want the x-axis to increment by month.
 Q2. I want to only display the x-axis labels for the data points I have.
 
 I don't this problem is particularly well defined.  You mean the first of 
 January and the third of March - right? - not January 2001 (or 1901?) and 
 March 2003?  Do you want your January and March values to be located for 
 their month generally (as if for the Ides of March, maybe) or for their 
 actual dates?  You say you will have some months missing, but what happens if 
 you have two entries for one month?

I figured out Q1, I just wanted the x-axis to increment by 1 month.
The option wasn't there before but I recompiled LO and now resolution is there.
The only change I made was Resolution and LO thinks the document has not 
changed and won't let me save it.l

Q2 is in regards to the bubble help you see when you hover the mouse over a 
point on the graph.
It shows Jan 2001 instead of Jan 21 2001.
I have no idea how I changed that.

I apologize for the double post, I wasn't subscribed so I subscribed and 
reposted.
I didn't think the first one would post.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] trouble with Page Styles and Fields in Writer

[James]

I'm having a bit of trouble with Page Styles and Fields in Writer.
It's a pretty simple test file.
The current page Field works the way I want but the page count Field is 
not what I want.


http://lockie.ca/test/pageTest.odt.bz2


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] trouble with Page Styles and Fields in Writer

[James]

On 08/29/11 15:39, webmaster for Kracked Press Productions wrote:

On 08/29/2011 02:16 PM, James wrote:


I'm having a bit of trouble with Page Styles and Fields in Writer.
It's a pretty simple test file.
The current page Field works the way I want but the page count Field 
is not what I want.


http://lockie.ca/test/pageTest.odt.bz2



looked at your file.

Try the following.

Format  Page  Footer
check the Footer On box

Then go to the first page footer with the footer page count.

Insert  Field
There you have Page-Number and Page-Count options.

That should help you.


It's not that I can't make a footer.
I have the text
page  Field-Page-Number  of  Field-Page-Count
and it displays:
page 2 of 4

I want it to display 'page 2 of 2.

There are 3 physical pages but I set the starting page# to 1 on the 
FirstPage so I expect Page-Count to start from there.

There is no way it should even have Page-Count=4.


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] trouble with Page Styles and Fields in Writer

[James]

On 08/29/11 15:02, Cor Nouws wrote:

Hi James,

James wrote (29-08-11 20:16)

I'm having a bit of trouble with Page Styles and Fields in Writer.
It's a pretty simple test file.
The current page Field works the way I want but the page count Field is
not what I want.

http://lockie.ca/test/pageTest.odt.bz2


On the paragraph 'normal page' click Format  Paragraph, tab tex flow 
and set the page number there to 1.


Regards,


I must have done that wrong because it made Page-Count=5. :-(

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] trouble with Page Styles and Fields in Writer

[James]

On 08/29/11 19:05, Brian Barker wrote:

At 16:12 29/08/2011 -0400, James Lockie wrote:
There are 3 physical pages but I set the starting page# to 1 on the 
FirstPage so I expect Page-Count to start from there.  There is no 
way it should even have Page-Count=4.


At 08:26 30/08/2011 +1200, Steve Edmonds wrote:
LO just can't count.  [...]  Page Count is total pages, [...] 5 is 
definitely wrong and so is 4 as there are only 3 pages. That's a bug 
somewhere.


I can explain this bit, which LibreOffice will not see as a bug.  
Writer considers that you may wish to print your document 
double-sided.  You have set your second page (first page) to be 
numbered 1, an odd number, and Writer decides that you will 
therefore want this to be a recto (or right-hand page), not the verso 
(or left-hand page) that it would otherwise be.  To achieve this, it 
notionally inserts a blank page between cover page and first 
page.  Including this blank page, you do indeed now have four pages, 
not three.

Is there any way to just have pages that are not right or left pages?


In editing mode, you do not see the blank page, and this may be confusing.
It is confusing because it's wrong behaviour, if it forces people to 
print it, then it should be visible in editing mode.



  But you can see it in Page Preview.  You will want the page to print 
(as it were) if you are printing double-sided but not if you are 
printing single-sided.  You can control this at Tools | Options... | 
LibreOffice Writer | Print | Other | Print automatically inserted 
blank pages.  Alternatively you can reach the same dialogue on the fly 
via the Options... button in the Print dialogue.


Oh, and I'm not advocating this arrangement, merely describing it.

Thanks.
Why do the developers assume something is always going to be printed or 
put on the web?

Maybe there should be a View-PDF Layout.


Brian Barker





--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] help making text fill a page

[James]

I've been struggling with getting it to fill a page.
Maybe someone else can look at it and figure out how to make page 2 
start on page 1 (First Page).
Physically I want 'Cover' page style (as page 1), 'First Page' style (as 
page 2), 'Default' page style (as pages 3+).

Logically I want page 1, page 1, pages 2+.

http://lockie.ca/test/pageTest.odt.zip

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] help making text fill a page

[James]

On 09/10/11 19:19, Brian Barker wrote:

At 17:36 10/09/2011 -0400, James wrote:
I've been struggling with getting it to fill a page.  Maybe someone 
else can look at it and figure out how to make page 2 start on page 1 
(First Page).  Physically I want 'Cover' page style (as page 1), 
'First Page' style (as page 2), 'Default' page style (as pages 3+).  
Logically I want page 1, page 1, pages 2+.


http://lockie.ca/test/pageTest.odt.zip


You have the Keep with next paragraph option set on much of the 
material on your third page, and the only way this material can be 
kept together is if it is moved to that new page.

o  Select the first three rows on the third page.
o  Go to Format | Paragraph... | Text Flow | Options (or right-click | 
Paragraph... | Text Flow | Options) and remove the tick from Keep 
with next paragraph.

o  Select the next table and repeat.
o  Once more and you're done!

You may be able to achieve what you want making fewer changes, but 
that's probably not important.


I trust this helps.

Brian Barker



This was exactly the help I needed.
I had paragraph formatting that overroad my paragraph styles/

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: 48 hours plus

[James]

On 09/10/11 12:17, David H. Lipman wrote:

From: Cor Nouwsoo...@nouenoff.nl


Hi David,

David H. Lipman wrote (10-09-11 16:21)


How do you think this post was made ?
Or the posts I made in JRE older installs - Windows - now online - no need for 
Oracle
account ?

Your posts to the users-list come in the moderation cue. Each of your posts ask 
help of
the volunteers to get to the list. Maybe you would be so kind to make sure that 
you are
subscribed to the list?

If you want to send mails, without receiving, since you post via Gmane, you can
subscribe with a mail to users+subscribe-nom...@libreoffice.org.
A confirmation mail will be send to you (if you don't see it, check the spamm 
box) Reply
to that mail (with the same mail address of course)

Thanks a lot  kind regards,
Cor Nouws


I use;  news://news.gmane.org/gmane.comp.documentfoundation.libreoffice.user

It is NOT my fault that the Foundation's implementation of GMane is not working 
properly.

The last post I made to;  gmane.network.tor.user  arrived in that news group 
within 15
minutes.

I have no plans to join an email list.


Because you're not subscribed, each post you make has to be manually 
approved by someone.
They encourage people to subscribe as a method to combat spam (if people 
have to subscribe, it is less likely they're a spammer).
gmane is working fine, you would experience the same delay if you sent 
directly to the list from any unsubscribed email address.


I think you could subscribe but not receive email from the list.
Some special-case subscribers might want to be able to post to a list 
but might not want to receive messages from that list (community 
contributors who post announcements, for instance). In this case, 
please subscribe to the so-called nomail version of the list by 
attaching -nomail to the normal subscription address. For example, to 
do this for The Document Foundation general discussions list, the 
subscription address would be: 
discuss+subscribe-nom...@documentfoundation.org 
mailto:discuss+subscribe-nom...@documentfoundation.org.



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] copy styles in writer

[James]

I have two documents. docA has a paragraph style docB does NOT have.
Copying text from docA to docB should copy the style, right?
It doesn't. :-(

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] copy from Thunderbird and paste to Calc

[James]

I want to see if this works for anyone (on another than Linux platform).

1. compose a new message in Thunderbird
2. Enter
libreoffice-users Mailing List users@global.libreoffice.org
on the to line:
3. Select all the to: and copy it to the clipboard
4. Create an empty spreadsheet
5. Past the clipboard in a cell

It should work.

Now try (quotes around the name):
libreoffice-users Mailing List users@global.libreoffice.org
It only pastes what is inside the quotes.
Even past-special doesn't work.

Past into the expression bar, it works.


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] merged cells in Writer (saved as Word 97/2000/xp/2003)

[James]

1. Create a new Writer document
2. Create a new table (whatever it defaults to (but at least 2 rows))
3. Type 'test' in the top left cell
4. Merge the 1st and 2nd cells in the first column
5. SaveAs (change the format to Microsoft Word 97/2000/xp/2003)
6. Close the document and then open it

The merge is lost.

Can anyone reproduce that?

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] merged cells in Writer (saved as Word 97/2000/xp/2003)

[James]

On 09/14/11 14:58, JOE Conner wrote:

On 9/14/2011 11:07 AM, James wrote:

1. Create a new Writer document
2. Create a new table (whatever it defaults to (but at least 2 rows))
3. Type 'test' in the top left cell
4. Merge the 1st and 2nd cells in the first column
5. SaveAs (change the format to Microsoft Word 97/2000/xp/2003)
6. Close the document and then open it

The merge is lost.

Can anyone reproduce that?


No problem with LO 3.4.3 on WinXP Pro.  The saved and
open document is the same for me, the merge is preserved.

Joe Conner, Poulsbo, WA USA


Thanks.
I guess it works on Windows.
Linux anyone?

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: merged cells in Writer (saved as Word 97/2000/xp/2003)

[James]

On 09/14/11 15:55, NoOp wrote:

On 09/14/2011 12:17 PM, James wrote:

On 09/14/11 14:58, JOE Conner wrote:

On 9/14/2011 11:07 AM, James wrote:

1. Create a new Writer document
2. Create a new table (whatever it defaults to (but at least 2 rows))
3. Type 'test' in the top left cell
4. Merge the 1st and 2nd cells in the first column
5. SaveAs (change the format to Microsoft Word 97/2000/xp/2003)
6. Close the document and then open it

The merge is lost.

Can anyone reproduce that?


No problem with LO 3.4.3 on WinXP Pro.  The saved and
open document is the same for me, the merge is preserved.

Joe Conner, Poulsbo, WA USA


Thanks.
I guess it works on Windows.
Linux anyone?


Works for me: LO 3.4.3 linux. Also tested by merging the cells in the rows.
BTW: you might want to let us know which version of LibreOffice you are
using.




3.4.3 for Linux but it is a build for Gentoo from source.

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: merged cells in Writer (saved as Word 97/2000/xp/2003)

[James]

On 09/14/11 21:50, Simon Cropper wrote:

On 15/09/11 11:05, James wrote:

On 09/14/11 15:55, NoOp wrote:

On 09/14/2011 12:17 PM, James wrote:

On 09/14/11 14:58, JOE Conner wrote:

On 9/14/2011 11:07 AM, James wrote:

1. Create a new Writer document
2. Create a new table (whatever it defaults to (but at least 2 
rows))

3. Type 'test' in the top left cell
4. Merge the 1st and 2nd cells in the first column
5. SaveAs (change the format to Microsoft Word 97/2000/xp/2003)
6. Close the document and then open it

The merge is lost.

Can anyone reproduce that?


No problem with LO 3.4.3 on WinXP Pro. The saved and
open document is the same for me, the merge is preserved.

Joe Conner, Poulsbo, WA USA


Thanks.
I guess it works on Windows.
Linux anyone?


Works for me: LO 3.4.3 linux. Also tested by merging the cells in the
rows.
BTW: you might want to let us know which version of LibreOffice you are
using.




3.4.3 for Linux but it is a build for Gentoo from source.



Worked OK with my system.

LibreOffice 3.4.2 OOO340m1 (Build:203) on Ubuntu LTS 10.04

I noted one difference though. In STEP 5 you save as Microsoft Word 
97/2000/xp/2003 -- my system has Microsoft Word 97/2000/XP. A subtle 
difference but maybe you have a different 'Save As...' routine than 
other people.



Very interesting but you are 1 version behind.

LibreOffice 3.4.3
OOO340m1 (Build:302)


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] percentage to get number in Calc

[James]

I have a number $646.15
and a number $556.85
How do I make a formula in a new cell that is the percentage of the 
first number that equals the second number?



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] percentage to get number in Calc

[James]

On 09/25/11 23:10, Tom Davies wrote:

Hi :)
Ok, say the numbers are written along the top row such that

A1 = 646.15
A2 = 556.85

then

A4 = A2/A1

Click on A4 and go up to the menus at the top to choose

Format - Cell - Number
in the first box Category select Percentage

I think it's better to avoid keying in the currency symbol and just format those cells as 
Currency instead of as Percentages.  That way you still get the currency 
symbol anyway but don't have to type it in.  It also avoids confusions.  Note that i left a gap 
between the data and the calculation purely because i think it looks nicer.

Thanks for the solution.
I feel stupid for making it seem hard. :-)
  


Regards from
Tom :)


--- On Mon, 26/9/11, Jamesbjloc...@lockie.ca  wrote:

From: Jamesbjloc...@lockie.ca
Subject: [libreoffice-users] percentage to get number in Calc
To: libreoffice-users Mailing Listusers@global.libreoffice.org
Date: Monday, 26 September, 2011, 3:46

I have a number $646.15
and a number $556.85
How do I make a formula in a new cell that is the percentage of the first 
number that equals the second number?


-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted





--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] equal width columns

[James]

I want the columns to each be the same width (the width of the selected 
columns divided by the number of selected columns).

I found this:



  Space Columns Equally

Adjusts the width of the selected columns to match the width of the 
widest column in the selection. The total width of the table cannot 
exceed the width of the page

but it is not what I want.

I can merge all the cells into one column and then split the one column 
into equal parts or I can manually set the column widths but each of 
those methods has drawbacks.



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] black background for bubblehelp

[James]

My bubblehelp for libreoffice is black text on a black background.
Bubble help in thunderbird, firefox, and elsewhere work fine.
I tried deleting .libreoffice but that didn't help.

3.4.4 OOO340m1
Gentoo Linux

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] black background for bubblehelp

[James]

On 11/17/11 11:58, El Cico wrote:
 
 
 
 
 - Messaggio originale -
 Da: James bjloc...@lockie.ca
 A: libreoffice-users Mailing List users@global.libreoffice.org
 Cc: 
 Inviato: Giovedì 17 Novembre 2011 17:39
 Oggetto: [libreoffice-users] black background for bubblehelp

 My bubblehelp for libreoffice is black text on a black background.
 Bubble help in thunderbird, firefox, and elsewhere work fine.
 I tried deleting .libreoffice but that didn't help.

 3.4.4 OOO340m1
 Gentoo Linux
 
 Hello!
 If you're using KDE, you've got to change comments background color in KDE 
 (applications?) system settings; I'm at the moment on Gnome, and I'm quite 
 new to KDE, so I don't remember exactly; if you don't solve let me know and 
 I'll give you more clear suggestions, after looking at KDE on another PC.
 Namastè! cico :)
 
 

That helped but I think I found a bug.
I changed 'KDE:System Settings/Application Appearance/Colors/Colors tab/Tooltip 
Background' to brown and it worked but the tooltip text is black.
I changed 'System Settings/Application Appearance/Colors/Colors tab/Tooltip 
Text' to white and the text is still black.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] mod

[James]

I get err 509 when I try this: =34 mod 12

How do I use mod?

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] mod

[James]

On 12/01/11 13:04, Regina Henschel wrote:
 Hi James,
 
 James schrieb:
 I get err 509 when I try this: =34 mod 12

 How do I use mod?

 
 It is a function and not an operator. Use
 =mod(34;12)
 
 Kind regards
 Regina
 

I guess it used to be an operator:
http://help.libreoffice.org/Basic/Mod-Operator_Runtime

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] calc sort

[James]

I made a simple sheet in calc that just contained 'Tue' and 'Wed'.
Both cells are a date format but I tried to sort them and they won't change 
order.
3.5

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] calc sort

[James]

On 01/07/12 03:48, Johnny Rosenberg wrote:
 2012/1/7 James bjloc...@lockie.ca:
 I made a simple sheet in calc that just contained 'Tue' and 'Wed'.
 Both cells are a date format but I tried to sort them and they won't change 
 order.
 3.5
 
 I don't know about other people on this list, but I certainly need a
 some more information about this.
 Those two cells, how did you enter their content? Just typing ”Tue”
 and ”Wed” into them or typing actual dates and then format them to
 only view weekdays?
 Exactly how did you sort them?
 
 
 Kind regards
 
 Johnny Rosenberg
 ジョニー・ローゼンバーグ
 

I typed 'Tue' and 'Wed' and then formatted them as NN.
I used the Data-Sort menuitem.
Are they strings even though I made them NN format?
If so, shouldn't Calc put ' in front of them?

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] numbers to time

[James]

I have two cells, one with the number 8 and one with the number 15.
I want to combine them into a time cell, 8:15.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] crash open a non Calc file name *.ods

[James]

I use KDE.
I created a new text file and named it usage.ods.
I then tried to open it and LibreOffice crashed.
I sometimes create new documents this way.
If I rename the file usage.txt and open it with Calc, it imports fine.
If I rename it as usage.ods and open it with Calc, it crashes.

Does this happen for anyone else?


-- 
E-mail to users+h...@libreoffice.org for instructions on how to unsubscribe
List archives are available at http://www.libreoffice.org/lists/users/
All messages you send to this list will be publicly archived and cannot be 
deleted

[libreoffice-users] formula years since date

[James]

I want the years since a date and today.
I tried this function:
=YEARS(7/16/2012,TODAY(),1)
but it returns 1900.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] formula years since date

[James]

On 07/19/14 21:34, Brian Barker wrote:
 At 20:27 19/07/2014 -0400, James Lockie wrote:
 I want the years since a date and today. I tried this function:
 =YEARS(7/16/2012,TODAY(),1)
 but it returns 1900.
 
 Your first argument is 7 divided by 16 divided by 2,012. This is 
 approximately 0.00022, representing - as a date and time - nineteen seconds 
 after midnight on the date origin. So I'd expect the result to be 115. But in 
 any case it won't have anything to do with a date in July 2012.
 
 The arguments of YEARS() need to be numeric dates, so I think you need 
 something like
 =YEARS(DATE(2012,7,16),TODAY(),1)
 or
 =YEARS(DATEVALUE(7/16/2012),TODAY(),1)
 
 I trust this helps.
 
 Brian Barker
 
 
I tried:
=YEARS(DATE(2012,7,16),TODAY(),1)
I still get 1900.
The cell format is .

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] formula years since date

[James]

On 07/19/14 22:44, James wrote:
 On 07/19/14 21:34, Brian Barker wrote:
 At 20:27 19/07/2014 -0400, James Lockie wrote:
 I want the years since a date and today. I tried this function:
 =YEARS(7/16/2012,TODAY(),1)
 but it returns 1900.

 Your first argument is 7 divided by 16 divided by 2,012. This is 
 approximately 0.00022, representing - as a date and time - nineteen seconds 
 after midnight on the date origin. So I'd expect the result to be 115. But 
 in any case it won't have anything to do with a date in July 2012.

 The arguments of YEARS() need to be numeric dates, so I think you need 
 something like
 =YEARS(DATE(2012,7,16),TODAY(),1)
 or
 =YEARS(DATEVALUE(7/16/2012),TODAY(),1)

 I trust this helps.

 Brian Barker


 I tried:
 =YEARS(DATE(2012,7,16),TODAY(),1)
 I still get 1900.
 The cell format is .
 

I set the cell format to numeric and got what I want. :-)

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Justifying some texts causes big spaces between words

[James]

On 14-09-15 12:57 AM, Daniel wrote:

Is there a reason why when I justify some texts, automatically there are
big spaces between words?

Thanks

Daniel

Full Justification justifies to both left and right sides.
Try left or right justification.

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] converting txt to dates

[James]

Column A has text strings that are DD/MM/ format.
I want to make them real dates.
I tried these 2 datevalue formulas but I can't make it work.

14/03/2015Err:502
14/03/2015Err:502


=DATEVALUE(TEXT(A1,##/##/))
=DATEVALUE(A2)

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: save button in Calc 5.1.3.2

[James]

On 2016-06-04 12:21 PM, Kruno wrote:

Are you viewing file in read only mode?

Kruno

04.06.2016 u 16:16, James je napisao/la:

When the save button is clicked, it shows the "SaveAs..." and "Save
Remote File..." dropdown (I'm clicking on the button, not the dropdown
arrow).

Ubuntu 16.04 LTS (actually lubuntu :-)).



The file is writeable, control-S works fine.



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] save button in Calc 5.1.3.2

[James]

When the save button is clicked, it shows the "SaveAs..." and "Save 
Remote File..." dropdown (I'm clicking on the button, not the dropdown 
arrow).


Ubuntu 16.04 LTS (actually lubuntu :-)).



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] white text on tabs in writer edit style dialog

[James]

I'm having a problem in writer when I open the edit style dialog, all 
the text on the tabs is white and very hard to read.


Version: 5.2.2.2
Build ID: 1:5.2.2-0ubuntu2
CPU Threads: 8; OS Version: Linux 4.8; UI Render: default;
Locale: en-CA (en_CA.UTF-8); Calc: group


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Can't enter 12:12:52 in calc cell

[James]

I make a new spreadsheet, formatted A1 as hh:mm:ss, tried to type 
"12:12:52".
After the second colon, the contents change to 12 (the one is overlapped 
by another character).

Version: 5.1.4.2
Build ID: 1:5.1.4-0ubuntu1
OS: lubuntu 4.4


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] not relative formulas and no bubble help for File/Open/Recent Documents

[James]

Did something change to make the formulas not relative to the current sheet?
Instead of "=A1" I have "=sheet_name.A1".
It is very hard to read.

When I moved the mouse down the list of Recent Documents on the
File/Open/Recent Documents menu, the full path showed in a little bubble
help.
It have been gone for a while on mine.
Does anyone have this anymore?


Linux, 5.3.1.2


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] difference in hours between two times

[James]

I have a calc spreadsheet with column A being a date and column B is a time.
I am trying to make a foruma that calculates the difference in days and
another for the difference in hours between 2 rows.

For example:
column A
Wed, May 16, 2018
Mon, May 21, 2018

column B
08:30 PM
12:05 PM

column C
=((A13+B13)-(A12+B12))
=((A14+B14)-(A13+B13))[4.65]

column D
=TRUNC(C13)
=TRUNC(C14) [4]

column E
-
formula? [.65]


-- 
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

[libreoffice-users] Re: difference in hours between two times

[James]

On 2018-05-24 03:41 PM, Steve Edmonds wrote:
> Is there a reason you can't put A and B in one column.
> Format cell as date, define the format DDD MMM DD  HH:MM AM/PM
> You can then subtract easily and result is in days or x 24 for hours.
It is hard to enter both a date and time.
It is easy to enter "5/24" and it is converted to Mar 24, 2018.
> 
> Steve
> 
> On 25/05/18 07:07, James wrote:
>> I have a calc spreadsheet with column A being a date and column B is a
>> time.
>> I am trying to make a foruma that calculates the difference in days and
>> another for the difference in hours between 2 rows.
>>
>> For example:
>> column A
>> Wed, May 16, 2018
>> Mon, May 21, 2018
>>
>> column B
>> 08:30 PM   
>> 12:05 PM
>>
>> column C
>> =((A13+B13)-(A12+B12))
>> =((A14+B14)-(A13+B13))[4.65]
>>
>> column D
>> =TRUNC(C13)
>> =TRUNC(C14) [4]
>>
>> column E
>> -
>> formula? [.65]
>>
>>
> 
> 



-- 
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

[libreoffice-users] saving when nothing to save

[James]

Control-s saves the document even when there is nothing new to save.
I think it disabled the save when there was nothing to do.
Was this changed or is a regression bug in Calc?

Calc
Version: 6.0.3.2
Build ID: 1:6.0.3-0ubuntu1
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3;
Locale: en-CA (en_CA.UTF-8); Calc: group


-- 
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] corrupt letter

[James]

It is not a format problem because sometimes it works.
It seems to corrupt something in the OS after a while that shows up in 
libreoffice.

The most recent problem was '2' was garbled.

On 2018-11-25 12:09 p.m., Remy Gauthier wrote:

Hi,

It almost looks like if the "Monthly car payment" string was displayed 
using the date format of the A1 cell. What are the language and 
formats used in the A1 and B1 cells?


Rémy.
Le mercredi 21 novembre 2018 à 20:05 -0500, James a écrit :

I use lubuntu-18.10.
Sometimes, a letter gets corrupted but I only see it in libreoffice.

This example the 'p' displays as a ',':
http://lockie.ca/lubuntu_/libreoffice.jpg

I've also seen it when '2' displays garbled.

Any ideas about how to track down what software has the problem?




--
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

[libreoffice-users] corrupt letter

[James]

I use lubuntu-18.10.
Sometimes, a letter gets corrupted but I only see it in libreoffice.

This example the 'p' displays as a ',':
http://lockie.ca/lubuntu_/libreoffice.jpg

I've also seen it when '2' displays garbled.

Any ideas about how to track down what software has the problem?


--
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

[libreoffice-users] libreoffice doesn't remember file-open dialog size

[James]

I use lubuntu-18.10 and the open file dialog doesn't open the window at 
the last size it was.


Version: 6.1.2.1
Build ID: 1:6.1.2-0ubuntu1.1
CPU threads: 8; OS: Linux 4.18; UI render: default; VCL: gtk3_kde5;
Locale: en-CA (en_CA.UTF-8); Calc: group threaded


--
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

[libreoffice-users] corrupt letter on display

[James]

Repost with better title. :-)

I use lubuntu-18.10.
Sometimes, a letter gets corrupted but I only see it in libreoffice.

This example the 'p' displays as a ',':
http://lockie.ca/lubuntu_/libreoffice.jpg

I've also seen it when '2' displays garbled.

Any ideas about how to track down what software has the problem?


--
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

[libreoffice-users] android calendar dates

[James]

I backed up the calendar on my android phone.
It is CSV and I want to import it into Calc.
It has these numbers which I think are the dates.
Does anyone know how to convert then to Calc dates?

1459397923718
1427831701482
1459397923718
1491348608631
1526254831608


-- 
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

[libreoffice-users] percent to whole fraction

[James]

I need a formula that takes as input a percent and outputs a fraction 
that only has whole numbers.

Eg.
1% -> "1/100"
0.5% -> "1/200"
1.5% -> "3/200"

--
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] percent to whole fraction

[James]

Yes, Calc.

It works well enough using format code "# ??/200".
I guess I can use /200 for all of them but I was hoping for a formula 
that would pick the lowest denominator.


Thanks.


On 2019-04-25 6:45 p.m., Remy Gauthier wrote:

Hi,

I am assuming you are using Calc. There is no formula to do this: it 
is a cell formatting accessible via Format -> Cells... -> Numbers Tab, 
then go to the "Fraction" category. There you can select the # ???/??? 
format which will do what you are looking for.


I hope this helps.

Rémy.
Le jeudi 25 avril 2019 à 21:42 +, James a écrit :

I need a formula that takes as input a percent and outputs a fraction
that only has whole numbers.
Eg.
1% -> "1/100"
0.5% -> "1/200"
1.5% -> "3/200"


--
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

[libreoffice-users] mouse pointer doesn't change when clone formatting button pressed

[James]

The mouse pointer doesn't change when the clone formatting button is 
pressed.

It used to.
Does anyone else see this?


Version: 6.3.2.2
Build ID: 1:6.3.2-0ubuntu2
CPU threads: 12; OS: Linux 5.3; UI render: default; VCL: gtk3;
Locale: en-CA (en_CA.UTF-8); UI-Language: en-US
Calc: threaded



--
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

[libreoffice-users] filter bank transactions and then sum

[James]

I've got a spreadsheet of all my bank transactions and I want to filter 
them by type and them the results.


eg.
Tran Type Amount
1 A   1.5
2 B   2.0
3 A   3.5

I can use Data/More Filters/Standard Filer to get:
Tran Type Amount
1 A   1.5
3 A   3.5

but sum(C1:C3) gives 7.0 (the sum of the unfiltered spreadsheet.

I can copy but filtered rows but that is too easy. :-)
What is the hardest overkill way? :-)
Maybe a template or macro that I can reuse.
I just want to filter them so I can add up the interest I got.


--
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] full date string to date

[James]

On 2019-12-30 4:43 p.m., Alan B wrote:

James,

The only way I could get the text sample you provided to be accepted 
as a date was to leave the day name off. Typing Wed, Jan 2, 2020 into 
a cell resulted in a cell that contained text. Typing Jan 2, 2020 into 
a cell resulted in a cell that contained a date in the default date 
format, mm/dd/yy. That could then be formatted to NN, MMM D,  and 
display as Wed, Jan 2, 2020.


The DATEVALUE() function will convert the string Jan 2, 2020 to a 
date. It returns Err:502 when pointed at the string Wed, Jan 2, 2020.


My suggestion would be to input the substring Jan 2, 2020 into the 
DATEVALUE function then format as desired to get your dates back.


e.g. =DATEVALUE(MID(A1,6,20))


That works, thanks.

I have a spreadsheet with 2018 dates and I did a replace of '2018' for 
'2019' to make a copy of the spreadsheet for 2019.

When I did the replace for 2020 dates it changed the cells to text.
I maybe had an option checked that I didn't before. :-(




On Mon, Dec 30, 2019 at 2:55 PM James <mailto:bjloc...@lockie.ca>> wrote:


I had a spreadsheet with dates that I think somehow got converted
to text.
I tried pasting it as plain text with detecting special numbers and I
tried setting the column to a date format but it still seems to
come out
as text.

'Wed, Jan 2, 2020'


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

<mailto:users%2bunsubscr...@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



--
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011



--
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

[libreoffice-users] full date string to date

[James]

I had a spreadsheet with dates that I think somehow got converted to text.
I tried pasting it as plain text with detecting special numbers and I 
tried setting the column to a date format but it still seems to come out 
as text.


'Wed, Jan 2, 2020'


--
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

[libreoffice-users] Re: Test

[James]

On 2020-05-09 9:44 p.m., Jim wrote:
For some time now I have been unable to post to this list using gmane, 
so I decided to try subscribing to the list and using email. Hopefully 
this gets posted.


Regards,  Jim


https://en.wikipedia.org/wiki/Gmane
Use gmane.io


--
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

[libreoffice-users] template to set default font and font size problems with 6.4.3.2

[James]

I have 3 problems:

1. I made a template to set the default font for new Calc documents.
Is there a way to set the default font for existing documents instead of 
selecting them all and increasing the size?


2. A new Calc document defaults to the new size I saved in a template 
but the rows are not the optimum size for the default font.

Should the rows default to the optimum height for the default font?

3. Menus are a decent size since I changed the system font but sheet tab 
names at the bottom are still tiny.


Version: 6.4.3.2
Build ID: 1:6.4.3-0ubuntu0.20.04.1
CPU threads: 12; OS: Linux 5.4; UI render: default; VCL: qt5;
Locale: en-CA (en_CA.UTF-8); UI-Language: en-US
Calc: threaded



--
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

[libreoffice-users] Re: LO garbled chapter numbering of docx

[James]

Can everyone use LO for Windows?


--
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

[libreoffice-users] IF problem

[James]

A    B C D    E
3/10/2020    15    KB    0    15

E1 contains this:
=IF(C3="KB",B3/1024,B3)
It displays 15

I tried:
=IF(C3="KB")
It displays TRUE

My formula works elsewhere.
Any ideas?



--
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

[libreoffice-users] Re: IF problem

[James]

On 2020-05-17 4:46 p.m., Wade Smart wrote:

Make sure there is no spaces at all in the C column.
I removed all formatting and your formula result
is .014648438


Very weird, I just closed the file and reoponed it.
Maybe it needed to do a recalculation.



--
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

[libreoffice-users] Re: LO garbled chapter numbering of docx

[James]

On 2020-05-17 4:47 p.m., James Knott wrote:

On 2020-05-17 04:42 PM, James wrote:

Can everyone use LO for Windows?




Yes, it's a free download from https://www.libreoffice.org.  You can 
use it for business or personal use.  You can also give it to others.




I meant as a solution to the OP's problem, everyone use LO instead of 
Microsoft.



--
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

[libreoffice-users] Re: Test

[James]

On 2020-05-10 12:22 p.m., Jim wrote:


I am using gmane.io. I switched to it when the original gmane stopped 
working. The problem started on the original gmane and continued to 
gmane.io. I have always been able to read the group but at some point 
in  time I could no longer post to it.


At some point I corresponded with a moderator. He replied to my 
problem with some questions, I answered him but never heard anything 
back. At that point I just gave up.


I am sending this reply via gmane.io, we'll see what happens.

Maybe you need to be subscribed.
I can't find a way to check my subscription.
You could leave yourself subscribed the "-nomail" way.
Some special-case subscribers might want to be able to post to a list 
but might not want to receive messages from that list (community 
contributors who post announcements, for instance). In this case, 
please subscribe to the so-called "nomail" version of the list by 
attaching -nomail to the normal subscription address. For example, to 
do this for The Document Foundation general discussions list, the 
subscription address would be: 
discuss+subscribe-nom...@documentfoundation.org 
.




--
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

[libreoffice-users] sum text column of common unit of measure numbers

[James]

My cell phone provider only provides me a CSV with a text field for the 
usage.

I want to =sum( it so I need it to be numbers.
Is a macro the easiest way to make a new column of common unit of 
measure (GB?) numbers?


15 KB
5 KB
10 KB
15 KB
5 KB
5 KB
5 KB
1.8 MB
5 KB
5 KB
15 KB
215 KB
130.2 MB
9.2 MB
475 KB
11.7 MB
10 MB
15 KB
12.1 MB
5 KB
10 KB
7.1 MB
5.3 MB
4.9 MB
15 KB
240 KB
130 MB
2.9 MB


--
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

[libreoffice-users] Re: sum text column of common unit of measure numbers

[James]

On 2020-05-07 4:17 p.m., Malcolm Jaros wrote:

In Cell C1 put =IF(B1="MB",A1*1000,A1)


How can I have 2 IFs in case there are GBs?


--
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

[libreoffice-users] Re: sum text column of common unit of measure numbers

[James]

On 2020-05-07 6:04 p.m., Remy Gauthier wrote:

Hi,
If your values takes up, for instance the range A2 to A29, you can
enter this formula as an array formula:
=SUM(VALUE(SUBSTITUTE(SUBSTITUTE(A2:A29," KB","")," MB","")))
The only trick is to hit CTRL-SHIFT-ENTER instead of just ENTER at the
end of the formula entry: if you only use ENTER, this will be a
"normal" formula and it will not work. To make sure you did it right,
the formula should appear with curly braces on each side in the formula
display, like this:
{=SUM(VALUE(SUBSTITUTE(SUBSTITUTE(A2:A29," KB","")," MB","")))}
Another thing toi be careful about: if your decimal separator is the
comma (","), the dot in your list of numbers will also have to be
changed. You can change the formula like this to make the change of
separator:
=SUM(VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2:A29," KB",""),"
MB",""),".",",")))
Now, if you really want to be fancy, you can use the REGEX function to
remove the units. This will remove KB, MB, and GB:
=SUM(VALUE(REGEX(A2:A29," [KMG]B","")))
And don't forget that CTRL-SHIFT !
I hope this helps.
Rémy.

This looks promising. :-)


--
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

[libreoffice-users] key to default formatting

[James]

I used to use ctl-m to clear direct formatting of a cell but this key 
closes the document.

Has the key combination changed?

Version: 6.4.3.2
Build ID: 1:6.4.3-0ubuntu0.20.04.1
CPU threads: 12; OS: Linux 5.4; UI render: default; VCL: qt5;
Locale: en-CA (en_CA.UTF-8); UI-Language: en-US
Calc: threaded


--
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

[libreoffice-users] Re: date strings to date

[James]

On 2020-07-02 2:50 a.m., Luuk wrote:


On 2-7-2020 00:53, James wrote:


I have a column of date strings like "Thu, Aug 1, 2020".
I want to convert them to a real date column.



Suppose the date is in B2, then:

=DATE(RIGHT(TRIM(B2);4);(FIND(TRIM(MID(B2;FIND(",";B2)+1;4));"JanFebMarAprMayJunJulAugSep")-1)/3+1;1) 



You only need to:

1) Extend the monthnames ("JanFeb...") for the rest of the year

2) Fill in a formula for the day in the month (currently set to 1
=DATE(RIGHT(TRIM(A449),4),(FIND(TRIM(MID(A449,FIND(",",A449)+1,4)),"JanFebMarAprMayJunJulAugSepOctNovDec")-1)/3+1,TRIM(SUBSTITUTE(MID(A449,FIND(" 
",A449)+5,2),",","")))



--
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

[libreoffice-users] date strings to date

[James]

I have a column of date strings like "Thu, Aug 1, 2020".
I want to convert them to a real date column.


--
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

[libreoffice-users] Re: key to default formatting

[James]

On 2020-05-22 3:13 p.m., Philip Jackson wrote:

On 22/05/2020 18:08, Brad Rogers wrote:

On Fri, 22 May 2020 10:30:56 -0400
James  wrote:

Hello James,


I used to use ctl-m to clear direct formatting of a cell but this key
closes the document.
Has the key combination changed?

-M still clears direct formatting here (LO 6.4.4.1, Debian
testing).

Have you, perhaps inadvertently, assigned the same key combo to close
document?


In any case, you can check out and modify the key assignments here :

Tools > Customise > Keyboard tab

At least this is where it is done in v 6.3.5.2  (where Ctrl M is set 
as clear formatting )


Philip


I have nothing set beside ctrl+M.
I set it to "Clear".
It doesn't say "Clear Formatting" and there are two entries named Clear".
I think it doesn't like my video card because the UI all seems small.


--
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

[libreoffice-users] Re: Suggestion: 3D spreadsheets

[James]

On 2020-11-24 9:45 a.m., PaddleS wrote:

Something new an that would be really great is to add implementation for 3
(and potentially more) dimensional spreadsheets.
What it would look like :
Basically the same as a 2D spreadsheet. But by holding Alt+scrolling with
the mouse, you could change the third dimension, showing the 2D spreadsheet
of that third index.

For instance let's say the third dimensions use greek characters. Then by
default you see the "α" 2D spreadsheet showing the numbers and letters grid
at that value "α".
You hold Alt and scroll once and it changes to "β" 2D spreadsheet. And so
on.

Also it would require a way to select the X and Y axis in order to visualize
the data. So for instance you could change the X axis to display the greek
letters dimension and show the numbers on Y axis.

This could be really powerful. What do you think?



--
Sent from: 
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html


Give an example of what it could be used for.



--
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] calc: index column A with column B

[James]

Great, thanks.

On 2021-01-24 5:59 p.m., Rob Jasper wrote:

Is this what you mean:

=INDIRECT("$A"(MIN(B:B);B:B;0))


Op 24 jan. 2021, om 23:14 heeft James <mailto:bjloc...@lockie.ca>> het volgende geschreven:


I want to find the row in column A that corresponds to the row of a 
value in column B.


eg.

row    AB

1      1022

2      2015

3      303000

4      4010

=some_function('A',minimum_function(B));

where minimum_function(B) returns 4 and some_function('A',4) returns 
the value in column A at row 4.




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org 
<mailto:users+unsubscr...@global.libreoffice.org>
Problems? 
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 
<https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
Posting guidelines + more: 
https://wiki.documentfoundation.org/Netiquette 
<https://wiki.documentfoundation.org/Netiquette>
List archive: https://listarchives.libreoffice.org/global/users/ 
<https://listarchives.libreoffice.org/global/users/>
Privacy Policy: https://www.documentfoundation.org/privacy 
<https://www.documentfoundation.org/privacy>





--
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] calc: index column A with column B

[James]

Another problem.

Some of the numbers display as 0 but are calculated so have fractions like

0.000812344372353
I want to find the last row that displays as non-zero.  


On 2021-01-29 6:30 a.m., Rob Jasper wrote


James,

Since a MINIF function does not exist you can use MINIFS.

Change MIN(B:B) to MINIFS(B:B;B:B;">0”)

Success,
Rob



Op 29 jan. 2021, om 03:59 heeft James  het volgende 
geschreven:


I want to find the row in column A that corresponds to the row of a

value in column B.

eg.

rowAB
1  10   22
2  20   15
3  30   3000
4  40   10

=some_function('A',minimum_function(B));

where minimum_function(B) returns 4 and some_function('A',4) returns the

value in column A at row 4.

I asked the previous and someone gave me the formula:

=INDIRECT("$A"(MIN(B:B);B:B;0))


It worked fine but now I have some rows with zeros (more than one row):
row A   B
1   10  22
2   20  15
3   30  3000
4   40  10
5   50  0
6   60  0

Is there a MINBUTGREATERTHANZERO function?



--
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

[libreoffice-users] re: calc: index column A with column B

[James]

I want to find the row in column A that corresponds to the row of a

value in column B.

eg.

rowAB
1  10   22
2  20   15
3  30   3000
4  40   10

=some_function('A',minimum_function(B));

where minimum_function(B) returns 4 and some_function('A',4) returns the

value in column A at row 4.

I asked the previous and someone gave me the formula:

=INDIRECT("$A"(MIN(B:B);B:B;0))


It worked fine but now I have some rows with zeros (more than one row):
row A   B
1   10  22
2   20  15
3   30  3000
4   40  10
5   50  0
6   60  0

Is there a MINBUTGREATERTHANZERO function?



--
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

[libreoffice-users] calc: index column A with column B

[James]

I want to find the row in column A that corresponds to the row of a value in 
column B.

eg.

row    A  B

1      10     22

2      20     15

3      30     3000

4      40     10

=some_function('A',minimum_function(B));

where minimum_function(B) returns 4 and some_function('A',4) returns the value 
in column A at row 4.



--
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

[libreoffice-users] days since beginning of year

[James]

How do I get the number of days since the beginning of year?


--
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] days since beginning of year

[James]

How about this?

=DAYS(CONCAT(YEAR(TODAY()),"-",MONTH(TODAY()),"-",DAY(TODAY())),CONCAT(YEAR(TODAY())-1,"-12-31"))

On 2021-04-04 7:30 p.m., cspi...@ieee.org wrote:
I assume you're asking about how to get the days since the beginning 
of the year given an existing date and that you're using LibreOffice 
Calc.  With this in mind, here is an example:


=DATEDIF("2020-12-31","2021-01-27","d")

The resulting value in the cell will be 27.

The first parameter is the starting date.  Middle parameter is the 
current date in question (I used Jan 27th in my example).  The third 
parameter is the interval Calc should use, which is days here, hence 
"d".  Note that if you use 2020-01-01 as the start date, then the 27th 
day of January would actually only be the 26th day since Jan 1st, so 
you need to use a starting date of the last day of the prior year.


Hope this helps!


On Sun, Apr 4, 2021 at 3:59 PM James <mailto:bjloc...@lockie.ca>> wrote:


How do I get the number of days since the beginning of year?


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

<mailto:users%2bunsubscr...@global.libreoffice.org>
Problems?
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
<https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
Posting guidelines + more:
https://wiki.documentfoundation.org/Netiquette
<https://wiki.documentfoundation.org/Netiquette>
List archive: https://listarchives.libreoffice.org/global/users/
<https://listarchives.libreoffice.org/global/users/>
Privacy Policy: https://www.documentfoundation.org/privacy
<https://www.documentfoundation.org/privacy>




--
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] days since beginning of year

[James]

How do I get the start date to be dynamically the current year?

Apr. 4, 2021 19:30:53 cspi...@ieee.org:

> I assume you're asking about how to get the days since the beginning of the 
> year given an existing date and that you're using LibreOffice Calc.  With 
> this in mind, here is an example:
> 
> =DATEDIF("2020-12-31","2021-01-27","d")
> 
> The resulting value in the cell will be 27.
> 
> The first parameter is the starting date.  Middle parameter is the current 
> date in question (I used Jan 27th in my example).  The third parameter is the 
> interval Calc should use, which is days here, hence "d".  Note that if you 
> use 2020-01-01 as the start date, then the 27th day of January would actually 
> only be the 26th day since Jan 1st, so you need to use a starting date of the 
> last day of the prior year.
> 
> Hope this helps!
> 
> 
> On Sun, Apr 4, 2021 at 3:59 PM James  wrote:
>> How do I get the number of days since the beginning of year?
>> 
>> 
>> --
>> To unsubscribe e-mail to: 
>> users+unsubscr...@global.libreoffice.org[users%2bunsubscr...@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

-- 
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

[libreoffice-users] Read documents

[James]

I don't know if Writer has it built in but I'm sure there are screen 
readers for the OS you're using.


--
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] Changing the way a document opens

[James]

What OS?

On 2023-10-19 12:50, Kenneth Groninga wrote:

I have a document that I try to open in Libre Office Writer and it opens in
Libre Office Draw. It is a .doc document. How can I get it to open in Libre
Office Writer?

Kenneth Groninga




--
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] CalcGuide auto sum

[James]

I could find it but the help says it is somewhere.
I have always put a sum formula on the last row I wanted to total.
It would be easier if we find the button. :-)

On 2023-11-01 09:46, Jackie Beauchamp wrote:

Good morning
I am unsure where the total (auto sum) feature is in order to total my
columns, can you please
advise where that tool/feature is in CalcGuide ?
Sincerely yours,
Jackie Beauchamp




--
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] Fw: trying to make a date box in a form, tried loads of times and I can't get it to work

[James]

Can you access a flash drive?
Maybe you can download the help and save it to a flash drive you can then 
take home?

Does the library have anyone that can help?

--
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

[libreoffice-users] Fwd: Draw and Writer

[James]

It is a bit map picture if you scan it as a jpg.
Are you sure you did that before?
Maybe Writer can edit the text of pdfs, I don't know, try and scan it as 
that.


--
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] Can't insert citation (Zotero)

[James]

Sep 28, 2023 1:42:11 AM John Jason Jordan :


I have recently installed SparkyLinux, based on Debian Stable, and it
came with LibreOffice 7.4.7.2 installed without choice in the default.
The default, however, did not install Zotero, which I absolutely must
have. The distribution's repositories have Zotero 6.0.27, so I
installed it, and later I replaced it with Beta 7.0.0.42. When I launch
Writer I find the Zotero toolbar in View > Toolbars, and it looks
normal, but when I click on it to enter a citation nothing happens; no
error messages, nada. There is also a button for Add/Edit Bibliography,
but it also does nothing.

The installation added a launch entry for Zotero, which brought up my
hundreds of documents, so I guess I haven't lost anything yet. But it
would be really nice if I could use it.

The only literature I can find says that installing Zotero
automatically links it to installed word processors. In my case I must
characterize that as wishful thinking.

Some have said that you must have Java installed. OpenJDK came with
the operating system, and LO finds it, with the 'Use' button checked in
the Advanced window. However, below that is a little place which is
supposed to list the provider of the Java, and it is blank. 
Furthermore,

if I un-check the 'Use' button, a few minutes later it becomes checked
again, all by itself. Weirdness abounds.

I have Zotero.oxt from a previous LO, so I added it in Tools >
Extensions, but it didn't make any difference. And 'Add Extensions'
produced an Unofficial Zotero add-in, which I also installed, also
without accomplishing anything. The Add Extensions option also offered
the official extension from Zotero, but it doesn't actually download an
.oxt file. I'm not sure what it did, but whatever it did resulted in no
change.

I need my Zotero! Can anyone offer suggestions?


--
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
My suggestion is to try the non beta version of zotero and see if that 
does what you want.


--
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] shrink size and font size of styles sidebar

[James]

I have no idea what this is

Calc?
Minimum width of a column?

--
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] shrink size and font size of styles sidebar

[James]

Maybe there is no write permission to registrymodifications.xcu.

--
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

[libreoffice-users] text to date

[James]

The shortform of a day (eg. Sun) is not recognized as a date but the 
fullname (eg. Sunday) is.


Sun, Jan 1, 2024 isn't a date
Sunday, Jan 1, 2024 is a date.

Does anyone know how to converttext in the format NN, MMM D,  to a date?

--
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

[libreoffice-users] LO 7.6.2 cross-ref problem

[James]

Does pressing control and then clicking work?

--
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

[libreoffice-users] how to generate a re-scaled column

[James]

I think you can do =a1/max($a).
I'm not sure of the format but you can specify shortform for the whole 
row.


--
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] Cool! LibreOffice is free, open source and very good office suite!

[James]

Google "Targeted Individual in Singapore".
The Singaporean government is out to get him.

--
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] alter appearnce hypertext

[James]

I think it is how the mailing list is set up that sets where replies 
default to.
My opinion is that it is up to the user to check the recipients before 
hitting send


--
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

[libreoffice-users] export to pdf with frozen row

[James]

I froze the first row so it shows up as a header on each page.
When I export it to pdf I want it to show up as the first row of each page.
Can I do that?


--
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] Calc - Can't highlight a column and set background shading

[James]

Jul. 2, 2023 11:33:27 lo.harald.ber...@t-online.de:

Formatting with toolbars is also called direct formatting, and is not 
well suited for larger documents.


To format cells (or columns/rows), cell styles should be used.
How to do that you can find here:
https://wiki.documentfoundation.org/Videos/Cell_Styles_in_Calc


Maybe LO can be smart and create a style when appropriate.

--
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] How can I rejoin this list please?

[James]

Jul. 6, 2023 11:03:22 Budge :


Hi DaveB,
Just a line to say thanks but also be aware that something strange 
happened in the background when I first asked how to renew.

I had from postmas...@outlook.com the following message:-

*mx.google.com rejected your message to the following email addresses:*

alarmax...@gmail.com
Your message wasn't delivered because the recipient's email provider 
rejected it.


*mx.google.com gave this error:
This mail is unauthenticated, which poses a security risk to the sender 
and Gmail users, and has been blocked. The sender must authenticate 
with at least one of SPF or DKIM. For this message, DKIM checks did not 
pass and SPF check for [errichel.co.uk] did not pass with ip: 
[2a01:111:f400:7e8b::207]. The sender should visit 
https://support.google.com/mail/answer/81126#authentication for 
instructions on setting up authentication. 
p13-20020a056402074d00b0051bfa6da365si551974edy.585 - gsmtp

*

No idea why or what.  Whoever uses Outlook anyway but does it mean my 
mail has been hacked?


Regards,
Budge.

On 06/07/2023 13:49, DaveB wrote:



 Original Message 
From: John Kaufmann [mailto:kaufm...@nb.net]
Sent: Thursday, July 6, 2023, 11:57 UTC
To: Budge; LibreOffice Users
Subject: [libreoffice-users] How can I rejoin this list please?


On 2023-07-06 05:15, Budge wrote:
I disconnected a year ago and now wish to subscribe.  Please advise 
how I can join. ...


If not now subscribed, just send mail, Subject: "Subscribe", to: 
LibreOffice Users .
The correct subscribe address is: 
users+subscr...@global.libreoffice.org





--
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

I used to get that sometimes.
My isp fixed the server I send mail from.
They need to add dkim or spf to the maul server you send mail from.

--
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] optimal width always

[James]

You need to turn on macros in the settings (google how, I forgot) and the 
setting is enabled to record it (google where :-)). I think you can 
assign the macro to a key.


--
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] MY DOCX WAS AUTOMATICALLY REDECTED

[James]

Restore the docx from your backup.

--
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] optimal width always

[James]

It's a great idea for a feature.

I don't know how hard it would be to add a checkbox beside column type 
to make the column the automatic width.


You can record a macro and see if that works but it is probably easier 
to manually do it each time.



--
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

[libreoffice-users] Get rid of- Inserted: Author unknown...

[James]

I think that is a comment.
Turn off track changes.

-- 
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] Documentation of LibreOffice

[James]

The mailing list strips off attachments.
You need to upload them to a file sharing platform (I use mediafire).

--
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

[libreoffice-users] problems with border menu

[James]

The borders menu is hard to read.
1. The shadow lines up the top and left of each box look like an actual 
border.
2. Is the setting of the selected cell highlighted because I can't see 
anything.


I uploaded a screenshot here:
https://www.mediafire.com/view/d8h07ti16gnbpt8/borders.jpg/file

Version: 7.5.4.2 (X86_64) / LibreOffice Community
Build ID: 50(Build:2)
CPU threads: 12; OS: Linux 6.3; UI render: default; VCL: qt5 (cairo+xcb)
Locale: en-CA (en_CA.UTF-8); UI: en-US
Ubuntu package version: 4:7.5.4-0ubuntu0.23.04.1
Calc: threaded


--
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

[libreoffice-users] text fields to time fields

[James]

I have text fields like:

10:06:59 a.m.
8:57:36 p.m.

How do I convert them to 24-hour time fields?
--
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] text fields to time fields

[James]

That seems to leave 11 pm as 11:00 (I expect 23:00).
Maybe I am doing it wrong.

On 2023-06-28 17:10, Alan B wrote:

Select the text fields, hopefully they are in a column or columns.

After selecting the fields select "Data > Text to Columns..." from the menu

In the Text to Columns dialog box select the following options:
For "Separator Options" tick "Separated by".
The only separator option that should be ticked is "Space".
Be certain "Detect special numbers" is ticked in the "Other Options"
choices.
Click the "OK" button.

The time portion of the column will now be a time formatted number in the
column it was already in. Depending on the default format it may or may not
have AM/PM. If it doesn't, just change the time format to what you need at
this point.

The "a.m." or "p.m." portion of your original text will be moved one column
over. It will overwrite what is in the next column if the column is not
empty.

To prevent adjacent columns from being overwritten, while still in the
"Text to Columns" dialog box, go to the "Fields" section at the bottom.

There should be two columns with a heading of "Standard", one column
showing the time portion of your text, the other column showing the a.m/p.m
portion. Click the word "Standard" over the a.m/p.m column.

Now open the "Column type" list and pick the "Hide" option.

Finally, click OK to close the dialog box.

You text time will now be a time number in the column it was already in.
The a.m/p.m portion has not overwritten the adjacent column as it has been
discarded as part of the Text to Columns operation.


On Wed, Jun 28, 2023 at 4:32 PM James  wrote:


I have text fields like:

10:06:59 a.m.
8:57:36 p.m.

How do I convert them to 24-hour time fields?
--
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






--
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] text fields to time fields

[James]

I created a spreadsheet with 3 columns:

a1 -> 11:28
b1 -> p.m.
c1 -> =IFS(B1="p.m.",A1+24,A1+24)

c1 always displays 11:28


On 2023-06-28 17:10, Alan B wrote:

Select the text fields, hopefully they are in a column or columns.

After selecting the fields select "Data > Text to Columns..." from the menu

In the Text to Columns dialog box select the following options:
For "Separator Options" tick "Separated by".
The only separator option that should be ticked is "Space".
Be certain "Detect special numbers" is ticked in the "Other Options"
choices.
Click the "OK" button.

The time portion of the column will now be a time formatted number in the
column it was already in. Depending on the default format it may or may not
have AM/PM. If it doesn't, just change the time format to what you need at
this point.

The "a.m." or "p.m." portion of your original text will be moved one column
over. It will overwrite what is in the next column if the column is not
empty.

To prevent adjacent columns from being overwritten, while still in the
"Text to Columns" dialog box, go to the "Fields" section at the bottom.

There should be two columns with a heading of "Standard", one column
showing the time portion of your text, the other column showing the a.m/p.m
portion. Click the word "Standard" over the a.m/p.m column.

Now open the "Column type" list and pick the "Hide" option.

Finally, click OK to close the dialog box.

You text time will now be a time number in the column it was already in.
The a.m/p.m portion has not overwritten the adjacent column as it has been
discarded as part of the Text to Columns operation.


On Wed, Jun 28, 2023 at 4:32 PM James  wrote:


I have text fields like:

10:06:59 a.m.
8:57:36 p.m.

How do I convert them to 24-hour time fields?
--
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






--
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] text fields to time fields

[James]

detect special numbers looks checked but I can't uncheck it.
I looked at it to see if it was the problem with converting text to columns.

On 2023-06-28 17:10, Alan B wrote:

Select the text fields, hopefully they are in a column or columns.

After selecting the fields select "Data > Text to Columns..." from the menu

In the Text to Columns dialog box select the following options:
For "Separator Options" tick "Separated by".
The only separator option that should be ticked is "Space".
Be certain "Detect special numbers" is ticked in the "Other Options"
choices.
Click the "OK" button.

The time portion of the column will now be a time formatted number in the
column it was already in. Depending on the default format it may or may not
have AM/PM. If it doesn't, just change the time format to what you need at
this point.

The "a.m." or "p.m." portion of your original text will be moved one column
over. It will overwrite what is in the next column if the column is not
empty.

To prevent adjacent columns from being overwritten, while still in the
"Text to Columns" dialog box, go to the "Fields" section at the bottom.

There should be two columns with a heading of "Standard", one column
showing the time portion of your text, the other column showing the a.m/p.m
portion. Click the word "Standard" over the a.m/p.m column.

Now open the "Column type" list and pick the "Hide" option.

Finally, click OK to close the dialog box.

You text time will now be a time number in the column it was already in.
The a.m/p.m portion has not overwritten the adjacent column as it has been
discarded as part of the Text to Columns operation.


On Wed, Jun 28, 2023 at 4:32 PM James  wrote:


I have text fields like:

10:06:59 a.m.
8:57:36 p.m.

How do I convert them to 24-hour time fields?
--
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






--
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] text fields to time fields

[James]

Done.

On 2023-06-28 17:09, Steve Edmonds wrote:
It depends how you want the sheet to function. If you use Edit>Find 
and Replace... find a.m. replace with AM, find p.m. replace with PM it 
automatically converts.


On 29/06/2023 08:31, James wrote:

I have text fields like:

10:06:59 a.m.
8:57:36 p.m.

How do I convert them to 24-hour time fields?






--
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