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
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
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
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:
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
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
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
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,
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
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
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?
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
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
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
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
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
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?
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
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
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?
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
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
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
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?
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
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 +
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
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:
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
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
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:
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:
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
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?
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
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:
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
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
t 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 i
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:
ot; 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 exam
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
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:
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
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:
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?
mula 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 +000
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
--
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
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
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:
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:
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
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:
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?
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:
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
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
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
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
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
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:
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(&
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:
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
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
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
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
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
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
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
e 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
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 pri
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:
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:
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
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?
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?
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
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
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
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:
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:
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:
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:
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?
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?
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:
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
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?
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:
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:
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:
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:
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
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:
ally, 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
lumn 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 operatio
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 operat
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
1 - 100 of 958 matches
Mail list logo