Thanks, got vlookup to do what I 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:
Is the long list in any other file?
I think it is gone from Writer and you need to restore it from a backup.
translate.google.com
On 2024-06-05 18:31, Harry Stoller wrote:
Hello. During data recovery, I recovered Libre office writer. Almost
everything from it recovered. Some writing isn't how
Say I have column A with the numbers 1, 2, 3:
A1 (1)
A2 (2)
A3 (3)
and column B with the numbers 11, 22, 33:
B1 (11)
B2 (22)
B3 (33)
Column A Row 4 contains a reference to one of row 1, 2, or 3 (I switch
which row is referenced so I can see the effects of different choices).
Is there a calc
for the
time during which it is selected?
Regards
Fred James
--
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
e/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Is it possible that there is a page size to paper size mismatch?
Regards
Fred James
--
To unsubscr
Sus Spencer
Send the spreadsheet file as an attachment to the email
Regards
Fred James
Sue Spencer wrote:
Good afternoon
I have made a spreadsheet using Libre calc. When I print the spreadsheet off, it runs to
19 pages. However, when I email the spreadsheet to another party, only the first
Mike Scott wrote:
On 08/02/2024 18:14, Fred James wrote:
Mike Scott wrote:
Hi all. I've just been looking at making pdf forms with Writer.
Easier than I'd thought.
I've been able to create a sample form with text fields and open
this with xreader, evince or firefox. Firefox is able
,
on a Windows system as I don't have one.
Regards
Fred James
Mageia 8 64bit, Plaama desktop
$ uname -a
Linux localhost.localdomain 5.15.126-desktop-1.mga8 #1 SMP Fri Aug 11
21:17:00 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux
LO 7.4.5.1
--
To unsubscribe e-mail to: users+unsubscr
Nov 18, 2023 2:20:22 PM Pat Brown :
Hi,
I have just installed the latest version of LO but when I opened an
.odt
document none of my cross-references work. None of them are greyed out
to
indicate they are cross-references. When I hover the cursor over them
they
change colour to indicate
On 2023-11-13 18:57, Jose David Alcantara wrote:
Dear LO,11 13 23
I am getting this message and cannot really use my LO Writer:
The lock file could not be created for exclusive access by LibreOffice, due
to missing permission to create a lock file on that file location or lack
of free
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
On 2023-10-31 12:41, Chris J. wrote:
How come I can’t open a PDF on my Mac? I just purchased LibreOffice
for the sole purpose of editing PDF.
Uh, you purchased LibreOffice? It's free unless you give a donation.
Is that scam back? Years ago, we'd commonly hear about people paying
for
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?
Cool! I add my thanks for that ... and I also saw the "watermark"
option under "Format/Page style" as well (LO Version 7.4.5.1, under
Mageia 8 Linux) ... thanks again
Regards
Fred James
Tom wrote:
On 10/28/23 2:41 PM, Joe Conner wrote:
I want to use one of my images (.j
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?
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:
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:
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:
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
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
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 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:
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?
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:
On 2023-08-18 11:03, Gabriele Bertolucci wrote:
Anyway I extremely suggest you to use Mozilla Thunderbird.
I thought it split from Mozilla.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
On 2023-08-18 10:14, Turritopsis Dohrnii Teo En Ming wrote:
By the way, does LibreOffice have the equivalent of Microsoft Outlook?
Many people use Thunderbird.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
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:
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?
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:
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:
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
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:
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
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
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
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:
I would stick to the ubuntu one unless there is a bug you need fixed.
Then try to upgrade.
https://www.debugpoint.com/libreoffice-upgrade-update-latest/
I wonder if it can run from a usb flash drive.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
Why do you need the most recent as opposed to the ubuntu one?
--
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
Uninstall the installed packages and install the downloaded one.
--
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 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
Just copy it back from the backup you made.
--
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:
On 2023-06-06 11:26, Tom wrote:
This is a long shot but maybe use your operating system's file
manager/explorer and sort various folders where you save documents
(Desktop, Documents, etc) by date and see if you can locate the file
that way?
On Linux, you could probably use the find command.
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:
Can PowerPoint save to something like docx?
I think that is a more opensource file format.
--
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 2023-05-06 15:04, charles meyer wrote:
Hi All,
I have a PNG I wish to remove, delete or erase a vertical line which goes
down the entire page of a one page flyer.
Would you please share the precise steps of how I can remove that line?
Must I choose something like a Rectangle Tool and
)
James wrote:
Hello James,
be the date in the first cell but only display the month.
Currently, the formatting clones cell A2; You need to change it.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how
I want the date in the first cell to display as day month year but the sec cell
be the date in the first cell but only display the month.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
-05-05 16:14, Brian Barker wrote:
At 15:41 05/05/2023 -0400, James Lockie wrote:
Does this work for you? The A1 cell contains a date with a date
format (NN, MMM D, ) that displays the weekday month day year.
The B1 cell contains a reference to the A1 cell but has a date format
(
Does this work for you?
The A1 cell contains a date with a date format (NN, MMM D, ) that
displays the weekday month day year..
The B1 cell contains a reference to the A1 cell but has a date format
() that is only supposed to display the month.
I uploaded a sample file to:
uld assume that addressing it in one
might effect the other?
Anything I am missing here? Any help or advise?
Thank you
Regards
Fred James
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Postin
On 2023-03-18 14:06, Larry Sanders wrote:
I have been able to run libreoffice portable off a thumb drive successfully of
of my PC at work. At home I have a Mac Pro and need to access the same files
(for me mainly the database) and I would like to do so without having a virtual
machine (i.e.
On 2022-12-13 15:39, charles meyer wrote:
How do I do that?
I have never used W11, but on W10 it's easy, at least with Open-Shell,
which provides a normal Start menu, instead of those d*mn tiles. Under
All Programs there's a folder for LibreOffice. In there, are icons for
the various
On 2022-11-10 12:08, ddalem...@aol.com wrote:
I recently installed LibreOffice on my laptop and find that I cannot Save to a
USB flashdrive for possible future editing AND delete the document from my
laptop. Deleting document on my laptop (in LibreOffice) leaves anything I think
I’ve Saved to
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?
On 2022-01-27 3:08 a.m., NE NE wrote:
Hi, My name is Hatice from Turkey.
First of all, thank you for making free software available to people. And my
question to you is:
"When we use the programs included in your software, for example; When we write a
document, no one but us can access this
On 2021-09-13 11:38 p.m., Tom Williams wrote:
So, what's a good/reliable way to test changes saved in DOCX format in
Writer? Is using Word online, as I did, akin to loading it in MS Word
2016? I believe the document was last edited in MS Word 2016 before it
was sent to me.
What I did was
RESOLVED - compose key was mapped to a key that was being used for
something else
Regards
Fred James
Mageia 8
Plasma
LibreOffice 7.0.4.2
Liberation Serif
In older versions this worked by pressing stuff like ,
letter but not now?
How does one add accented characters to a text document today
Mageia 8
Plasma
LibreOffice 7.0.4.2
Liberation Serif
In older versions this worked by pressing stuff like ,
letter but not now?
How does one add accented characters to a text document today?
Thanks
Regards
Fred James
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
I just tested that on Mageia 7, HP p6-2419 ...
Linux 5.10.46-desktop-1.mga7 #1 SMP Thu Jun 24 14:55:57 UTC 2021 x86_64
x86_64 x86_64 GNU/Linux
... using LO 6.4.7.2 ... works well
Regards
Fred James
Regina Henschel wrote:
Hi Eric,
Eric Beversluis schrieb am 15.07.2021 um 00:24:
Is there a way
The current version is 7.1.3
https://www.libreoffice.org/download/download
On 2021-06-09 4:00 a.m., Italo Vignoli wrote:
LibreOffice 6.7.4.2 does not exist, you are probably referring to
LibreOffice 6.4.7.2, which is an old version and can be downloaded
from the following link:
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
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
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
On 2021-02-22 4:31 p.m., charles meyer wrote:
Is there a quick/easy way to eliminate all that wasted white space around
the business card?
I adjust the scanned area, before the scan.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
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
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
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
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
orientation of the page (Portrait -
Landscape) ...
Format -> Page, select the "Page" tab ... the radio buttons for Portrait
and Landscape are a little less than 1/2 the way down
Hope that helps
Regards
Fred James
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
P
On 7/17/20 8:56 AM, James Knott wrote:
On 7/17/20 8:37 AM, Gilles wrote:
I have a spreadsheet where time is formatted as HHhMM.
In the next column, I'd like to show this in minutes. What would be a
good
way to achieve this?
Many years ago, when copying records to cassettes (remember them
On 7/17/20 8:37 AM, Gilles wrote:
I have a spreadsheet where time is formatted as HHhMM.
In the next column, I'd like to show this in minutes. What would be a good
way to achieve this?
Many years ago, when copying records to cassettes (remember them?), I
used the decimal degree to degree,
On 2020-07-08 01:05 PM, John Kaufmann wrote:
Umm... when you begin this way:
"... LibreOffice ... is actually quite good, although Microsoft's
Office is far superior."
you lose all credibility. [FWIW, in my experience, LO is more capable
than MSO.]
Yeah, I noticed that too. I guess he
I came across this article:
https://betanews.com/2020/07/06/libreoffice-money/
--
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-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:
chieve your desired formating, edge
spacing, etc.
Click on the Synchronize Labels button.
Done
Here is the URL for the YouTube that supplied this knowledge.
https://www.youtube.com/watch?time_continue=278=qP3NCdRlO8Q=emb_logo
Hope that helps
Regards
Fred James
--
To unsubscr
ugh the answers I found (once
again) point to stuff that is not in LO, at least not in the version I
have. Possibly out of date answers? Possibly the answer would vary a
lot between OS's?
Regards
Fred James
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? ht
On 2020-06-06 02:57 PM, Office User wrote:
I have a client who would like to run LO on Vista. Should I advise them
to go with AOO instead?
Advise them to move to Windows 10. Even Windows 7 is pretty much out of
support now, which means they don't even get security updates.
--
To
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-06-01 02:35 PM, Philip Jackson wrote:
Have you tried that ^ to the left of the close button? It's
remembered on my openSUSE system.
Yes, that is the problem. I always have to click that icon to get full
screen but LO's idea of full screen is about 3/4 of the width of my
screen.
On 2020-06-01 09:42 AM, Philip Jackson wrote:
I have searched for a way to force them to open at full screen width
but with no success. Is there some setting(s) buried somewhere in the
'advanced' settings which can be arranged to force full width opening?
Have you tried that ^ to the left
Perhaps you're being proactive, but the time on your post is still a
couple of minutes from now. ;-)
On 2020-05-31 03:52 PM, Drew Jensen wrote:
Looking at your requirements I was curious if using captions for the
images could give you what you want.
If the caption was the name of the document
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-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-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 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.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems
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-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
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
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:
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
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
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-03-02 05:25 AM, M Henri Day wrote:
I'm not a Mac user myself, but according to Jack Wallen at *Tech Republi*c (
https://www.techrepublic.com/article/how-to-sign-libreoffice-6-documents-with-gnupg/),
if one has installed a PGP tool for MacOS (he suggests GPG Suite), one can
sign documents
James wrote:
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
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
1 - 100 of 962 matches
Mail list logo