Hello Steve,
You cannot attach files to your emails to this group since they do not
get relayed. Your only option is to attach it to a topic on LO's nabble
site (
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html
). You could also send it to me directly and I'll have
THANKS! I checked my wife's computer - sure enough.
On 3/29/2017 12:46 PM, Brian Barker wrote:
At 09:29 29/03/2017 -0500, you wrote:
In Calc, how do insert page breaks in version 5.? The documentation
for LO 5 states what's in version 4.2.2, but it's missing from LO 5.?
The facility is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Greg,
mark the row and choose
Sheet > Insert Page Break > Row Break
Regards
Robert
- --
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE-
Version: GnuPG v2
Hi Greg,
You can find the solution in the online help.
https://help.libreoffice.org/Calc/Insert_Page_Break
Met vriendelijke groeten, Salutations distinguées, Kind Regards,
DRIES FEYS
CORPORATE SERVICES • Specialist Software Developer
TVH GROUP NV
Brabantstraat 15 • BE-8790 WAREGEM
T +32 56 43
On Jun 25, 2014, at 9:52 AM, Budgie aje...@errichel.co.uk wrote:
I have been able to create a column with the dates in required format using
the formula =TEXT(B2,DD/MM/) but this leaves the underlying formula in
the cell so when I try and remove unwanted columns the formula fails. What
At 16:52 25/06/2014 +0100, Budgie Noname wrote:
I have several columns in sheet with dates in the format 25 Jun 2014
which have been imported into Calc via a .csv file from another
programme. I have to manipulate the data and then export it as a
.csv file for import by yet another program
On Wednesday, June 25, 2014 04:52:24 PM Budgie wrote:
25 Jun 2014
Not sure about openoffice but in LibreOffice you can start calc, go to
Format --Cells -- Date and create a format like you want by inserting
in the Format Code box what you want:
Example: DD/MM/ this will give 25/06/2014.
On 25/06/14 18:13, Oogie McGuire wrote:
On Jun 25, 2014, at 9:52 AM, Budgie aje...@errichel.co.uk wrote:
I have been able to create a column with the dates in required format using the formula
=TEXT(B2,DD/MM/) but this leaves the underlying formula in the cell so when I try
and remove
On Fri, Jan 24, 2014 at 7:51 AM, Carl Paulsen carlpaul...@comcast.netwrote:
Dang, I hate the new list behavior of replying to the sender instead of
the list. C
+1 there. I spammed Carl trying to reply and ask for feedback on
alternatives suggested to OP
Now from computer instead of phone
Dang, I hate the new list behavior of replying to the sender instead of
the list. Can't that be changed back? My reply below, sent only to
Alan B by mistake.
Original Message
Subject:Re: [libreoffice-users] Calc question
Date: Fri, 24 Jan 2014 07:50:14 -0500
From
Alan B has written on 1/23/2014 9:58 PM:
Have labels at the top of each column such as Buyer and Price.
Once you're ready to get your totals by buyer
1) sort by buyer as you intend
2) select the entire data range including the column labels
3) from the menu select Data | Subtotals...
4)
What's a pivot table? Pointers to introductory tutorials will be
appreciated.
Thanks.
Original Message
Subject: Re: [libreoffice-users] Calc question
Date: Fri, 24 Jan 2014 07:50:14 -0500
From: Carl Paulsen carlpaul...@comcast.net
Reply-To: cpaul
://www.studiostorti.com
- Messaggio originale -
Da: Pikov Andropov piko...@gmail.com
A: users@global.libreoffice.org
Inviato: Venerdì, 24 gennaio 2014 17:53:09
Oggetto: Re: Fwd: Re: [libreoffice-users] Calc question
What's a pivot table? Pointers to introductory tutorials
.
Carl
On 1/24/14 11:53 AM, Pikov Andropov wrote:
What's a pivot table? Pointers to introductory tutorials will be
appreciated.
Thanks.
Original Message
Subject:Re: [libreoffice-users] Calc question
Date: Fri, 24 Jan 2014 07:50:14 -0500
From: Carl Paulsen
Jim Trigg / Blaise de Cormeilles has written on 1/23/2014 9:54 PM:
On Thu, January 23, 2014 9:28 pm, Pikov Andropov wrote:
I'm going to use Calc for recording sales during an auction.
When all data has been entered, I will sort on the names of the buyers.
For any given buyer there will be N
On Thu, Jan 23, 2014 at 9:28 PM, Pikov Andropov piko...@gmail.com wrote:
Next to each buyer will be a price. How do I total the amount of a
buyer's purchase on the fly, so-to-speak?
Have labels at the top of each column such as Buyer and Price.
Once you're ready to get your totals by buyer
On Thu, January 23, 2014 9:28 pm, Pikov Andropov wrote:
I'm going to use Calc for recording sales during an auction.
When all data has been entered, I will sort on the names of the buyers.
For any given buyer there will be N entries (where N 1).
Next to each buyer will be a price. How do I
On 10/09/2012 04:44 AM, IGraham wrote:
Hello
A Calc question
I have a grid of cells 7x20, one row for each day of the week, cells may
contain no data today
Daily I update the relevant cells
I want to copy and paste this grid to another sheet in the same book
I select grid and copy, go to
On 2012-10-10 00:54, Jay Lozier wrote:
On 10/09/2012 04:44 AM, IGraham wrote:
Hello
A Calc question
I have a grid of cells 7x20, one row for each day of the week, cells may
contain no data today
Daily I update the relevant cells
I want to copy and paste this grid to another sheet in the same
At 11:54 09/10/2012 -0400, Jay Lozier wrote:
If A1 has a string (Sunday) the try =if(len(a1)0,,). This will
put any empty string in the cell whether the expression evaluates to
true or false.
Indeed it will! In other words, your formula is identical to just
= and does not depend on the
I believe the expresion is a boolean expresion where you compare if the
COUNTIF(F4;K380,F4) is equal to 1.
It means that if the count of cells in the range F4:K380 having the
value matching the contents of F4 is 1 (only 1 such a cell) let the
result is true.
There is a typo in the syntax; it
sön 2011-04-10 klockan 16:52 -0400 skrev Chris Gummo:
The formula that we use is below. We use it in the Data Vailidation section
and not in every cell. I have not been able to get it to work.
=COUNTIF(F4;K380,F4)=1
Thanks
Chris
Sorry for being some kind of an idiot, but what does the
I have tried the formula below with the $ signs and I only get a TRUE or
FALSE answer when I type this into the cell. Maybe I am doing something
wrong which is a very good possibility. We have been using this code since
before I started working here and I am not too strong with formulas like
this.
It seems like a few others here I tried your formula.
the =1 at the end of =COUNTIF(F4;K380,F4)=1 makes it a TRUE/FALSE
evaluation.
I tried to use this as validation for input but it didn't seem to work
without considering a macro.
Could you please explain how this formula is used.
i.e. I assume
This formula =COUNTIF($F$4:$K$380;F4)=1 is actually used in the Data
Validation section in Excel and looks through cells F4 through K380 and does
not allow us to input multiple serial numbers for equipment. For instance,
we scan a serial number in cell F4 and try to scan the same number in cell
F8
I suggest going to the help section and entering data validity in the
search box. This worked for me in OpenOffice.org.
nvsoar
On Mon, Apr 11, 2011 at 12:18 PM, Chris Gummo ch...@reclamere.com wrote:
This formula =COUNTIF($F$4:$K$380;F4)=1 is actually used in the Data
Validation section in
Hi Chris,
Chris Gummo schrieb:
This formula =COUNTIF($F$4:$K$380;F4)=1 is actually used in the Data
Validation section in Excel and looks through cells F4 through K380 and does
not allow us to input multiple serial numbers for equipment. For instance,
we scan a serial number in cell F4 and try
The formula that we use is below. We use it in the Data Vailidation section
and not in every cell. I have not been able to get it to work.
=COUNTIF(F4;K380,F4)=1
Thanks
Chris
On Fri, Apr 8, 2011 at 4:29 PM, Johnny Rosenberg gurus.knu...@gmail.comwrote:
fre 2011-04-08 klockan 15:15 -0400
Hi Chris,
Chris Gummo schrieb:
The formula that we use is below. We use it in the Data Vailidation section
and not in every cell. I have not been able to get it to work.
=COUNTIF(F4;K380,F4)=1
Please have a look at the separators. I guess it should be
=COUNTIF(F4:K380;F4)=1
If you want to
Chris,
More information please: in LibreOffice Calc, Tools Options
LibreOffice Calc Formula ...have you changed Formula Syntax from the
default Calc A1 to Excel A1 (or perhaps Excel R1C1 for references to
other worksheets)?
I'm no spreadsheet expert, but I've found that most of my formula
Aha! It WAS the separator. Regina's answer to Chris Gummo is helpful
to me also. Thank you.
SHOW FORMULAS ONLY SHOWS FORMULAS IN BOTTOM ROW
I have another problem in LibreOffice Calc on Ubuntu 10.10. One can
display all formulas in a worksheet: Calc Tools Options
LibreOffice Calc View
fre 2011-04-08 klockan 15:15 -0400 skrev Chris Gummo:
My company is in the process of moving to LibreOffice from MS Office. We do
inventory of equipment from our customers and in Excel we have a formula
that does not allow us to scan in duplicate serial numbers. Does any one
know of a way to
Hi,
Le 09/03/2011 08:26, Rhadmirri a écrit :
Then I want to create a summary of about 6 or 7 fields from that worksheet
into another worksheet in the current workbook, apply some
styling/formatting then print it out.
The import/summary print is a job that will be done frequently but at
33 matches
Mail list logo