I see the same effect when the column is too narrow to display the formula.
Display is
If the column width is increased so the entire formula can be displayed,
then the formula will be displayed.
The fact that the formula does not display over adjacent empty cells, like
text does, I would th
Hi
Using LO 7.2, in scalc I selected
Tools-->Options-->Scalc-->View--Display_Formulas
Which I activated
However then the formula in that colum are displayed as ### (before turning
this option on, the result was displayed)
Is this a BUG or a feature.
If it is a feature I fail to see its be
Den sön 30 maj 2021 kl 18:05 skrev Hylton Conacher (ZR1HPC) <
hyl...@conacher.co.za>:
> On 2021/05/29 23:36, Johnny Rosenberg wrote:
> > Den lör 29 maj 2021 kl 21:58 skrev Hylton Conacher (ZR1HPC) <
> > hyl...@conacher.co.za>:
> >
> >> Hi Johnny,
> >>
> >> On 2021/05/28 23:44, Johnny Rosenberg wro
Bravo Remy,
On 2021/05/29 20:29, Remy Gauthier wrote:
Hello,
I created something that ressembles what Johnny created, and I
understand your data is formatted like so:
Data1 Data2 blank Data3 Data4 blank Data5 Data6
You want Data6 to be the maximum of Data2 and Data4 (and possibly more
colu
On 2021/05/29 23:36, Johnny Rosenberg wrote:
Den lör 29 maj 2021 kl 21:58 skrev Hylton Conacher (ZR1HPC) <
hyl...@conacher.co.za>:
Hi Johnny,
On 2021/05/28 23:44, Johnny Rosenberg wrote:
Den fre 28 maj 2021 kl 22:49 skrev Hylton Conacher (ZR1HPC) <
hyl...@conacher.co.za>:
Hi,
I have LO 7.0
Hello,
I created something that ressembles what Johnny created, and I
understand your data is formatted like so:
Data1 Data2 blank Data3 Data4 blank Data5 Data6
You want Data6 to be the maximum of Data2 and Data4 (and possibly more
columns as well), and you want to have Data5 equal to the date on w
Den lör 29 maj 2021 kl 21:58 skrev Hylton Conacher (ZR1HPC) <
hyl...@conacher.co.za>:
> Hi Johnny,
>
> On 2021/05/28 23:44, Johnny Rosenberg wrote:
> > Den fre 28 maj 2021 kl 22:49 skrev Hylton Conacher (ZR1HPC) <
> > hyl...@conacher.co.za>:
> >
> >> Hi,
> >>
> >> I have LO 7.0.6.2 and am battling
Hi Johnny,
On 2021/05/28 23:44, Johnny Rosenberg wrote:
Den fre 28 maj 2021 kl 22:49 skrev Hylton Conacher (ZR1HPC) <
hyl...@conacher.co.za>:
Hi,
I have LO 7.0.6.2 and am battling with understanding which formula to
use as well as the syntax for that formula.
I am aware of the availability o
Den fre 28 maj 2021 kl 22:49 skrev Hylton Conacher (ZR1HPC) <
hyl...@conacher.co.za>:
> Hi,
>
> I have LO 7.0.6.2 and am battling with understanding which formula to
> use as well as the syntax for that formula.
>
> I am aware of the availability of vlookup, hlookup, Index/Match formula
> and have
Hi,
I have LO 7.0.6.2 and am battling with understanding which formula to
use as well as the syntax for that formula.
I am aware of the availability of vlookup, hlookup, Index/Match formula
and have settled I think on the right one i.e. Index/Match
Below is a portion of my spreadsheet that
Gordon, perhaps you could add your comment to the bug report, the
developers might appreciate the input / feedback. I also prefer the second
choice and like your idea of a similar option for tool tips.
On Mon, Aug 15, 2016 at 12:10 AM, gordon cooper
wrote:
> I like your second suggested option
I like your second suggested option Bruce, i.e. None : Standard : Extended.
It would be a good option for all tooltips.
Gordon.
On 15/08/16 13:04, Bruce Hohl wrote:
My search for a way to control the formula tips also was unsuccessful so I
added the following enhancement requests:
https://bug
My search for a way to control the formula tips also was unsuccessful so I
added the following enhancement requests:
https://bugs.documentfoundation.org/show_bug.cgi?id=101512
On Sun, Aug 14, 2016 at 7:00 PM, Remy Gauthier
wrote:
> Hello,
>
> No, I do not know of any way to turn the formula tool
Hello,
No, I do not know of any way to turn the formula tool tips off. I even
had a look at the advanced settings (Tools... Options... LibreOffice...
Advanced... Advanced Settings) and I could not find anything.
Rgds,
Rémy Gauthier.
Le samedi 13 août 2016 à 15:42 -0400, Bruce Hohl a écrit :
> >
Does anyone know if it is possible to turn off the formula tool tips in
Calc?
--
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/Netique
At 19:42 19/12/2015 +0200, Hylton Conacher wrote:
Running :O 5.0.3.2 on IMac and have seen there
is a 5.0.4 update, however, perhaps my issue does not require an update.
Anyway, the formula involves COUNTIF with the
search range on another sheet and the search
criteria in a cell adjacent to t
-Original Message-
From: "Hylton Conacher (ZR1HPC)"
To: LibreOffice Users
Sent: Sat, 19 Dec 2015 9:44
Subject: [libreoffice-users] Calc formula syntax assistance
Hi,
Running :O 5.0.3.2 on IMac and have seen there is a 5.0.4 update,
however, perhaps my issue does not
Hi,
Running :O 5.0.3.2 on IMac and have seen there is a 5.0.4 update,
however, perhaps my issue does not require an update.
Anyway, the formula involves COUNTIF with the search range on another
sheet and the search criteria in a cell adjacent to the countif formula.
=COUNTIF(Data.$C$4:C$492
And this one should be sent in plain text: This could be a Calc quirk
or the correct expected behaviour, I'm not a power user, and this is not
drama for me either.
With a spreadsheet A1=1, B1=2, C1="=A1+B1"
_
_Example 1) In Excel 2003, where "|" is the cursor position in the
formula "=A1+B|1
This could be a Calc quirk or the correct expected behaviour, I'm
not a power user, and this is not drama for me either. With a spreadsheet
A1=1, B1=2, C1="=A1+B1"Example 1) In Excel 2003, where "|" is the cursor
position in
the formula "=A1+B|1", click on any other other cell and the cur
Brian Barker wrote:
> At 10:28 11/03/2015 +1300, David Love wrote:
> > What I want, in simple terms, is to determine the average number of
> > steps I am taking every week. Hopefully, this explanation will answer
> > the questions reaided.
>
> Not really!
>
> I think you've confirmed that the 1
At 10:28 11/03/2015 +1300, David Love wrote:
What I want, in simple terms, is to determine the average number of
steps I am taking every week. Hopefully, this explanation will
answer the questions reaided.
Not really!
I think you've confirmed that the 1 figure is irrelevant in the
calcul
At 19:27 10/03/2015 +0100, Johnny Rosenberg wrote:
Another idea would probably be to first enter
the first formula on the seventh row, then the
following formulas could check if the seventh
cell above is a formula
For instance, the first
formula in C7, than in C8:
=if(isformula(C1);average(B
David Love wrote:
> Using LinuxMint v17.1 Rebecca with MATE DE and LibreOffic v4.2.7.2 Build
> ID 420M0(Build2)
>
> I have a three column spreadsheet.
>
> Column A. Date - The dates are consecutive
>
> Column B. Production - The Production has a daily target of 10,000 units
> and each producti
Sorry, I accidently sent my reply to the very wrong place…
-- Forwarded message --
From: Johnny Rosenberg
Date: 2015-03-10 19:26 GMT+01:00
Subject: Re: [libreoffice-users] Calc formula ...
To: cpaul...@alumni.middlebury.edu
Another idea would probably be to first enter the
Wow, excellent suggestions Brian. Your ideas are always spot on. Thanks.
Carl
On 3/10/15 4:08 AM, Brian Barker wrote:
At 19:20 10/03/2015 +1300, David Love wrote:
I have a three column spreadsheet.
Column A. Date - The dates are consecutive
Column B. Production - The Production has a daily ta
Ok. OP has stated "each production period is of seven days" so answers
my first question.
On 2015-03-10 19:20, David Love wrote:
Using LinuxMint v17.1 Rebecca with MATE DE and LibreOffic v4.2.7.2 Build
ID 420M0(Build2)
I have a three column spreadsheet.
Column A. Date - The dates are consecuti
At 19:20 10/03/2015 +1300, David Love wrote:
I have a three column spreadsheet.
Column A. Date - The dates are consecutive
Column B. Production - The Production has a daily target of 10,000
units and each production period is of seven days.
Column C. a formula every seventh cell.
Is it possibl
Hi.
Yes it is. May some clarification though.
Is it the prior 7 days like a rolling average or the days say Monday to
Sunday, every Sunday.
Are you only averaging days where production exceeds 1, so in your
1st example day 1 is the only day exceeding 1 so the average=1
and in your s
Using LinuxMint v17.1 Rebecca with MATE DE and LibreOffic v4.2.7.2 Build
ID 420M0(Build2)
I have a three column spreadsheet.
Column A. Date - The dates are consecutive
Column B. Production - The Production has a daily target of 10,000 units
and each production period is of seven days.
Column C.
W dniu 2013-11-16 20:35, Brian Barker pisze:
o Type zero in an empty cell.
o Copy the zero.
o Select the (partially filled) cell range you wish to treat.
o Go to Edit | Paste Special... (or right-click | Paste Special... or
Ctrl+Shift+V).
o In the Paste Special dialogue, under Operations, select
W dniu 2013-11-16 17:54, Paul pisze:
Sure. Select the cell range you want to do the substitution on
(otherwise it will do find and replace on the whole sheet!), and go to
"Find & Replace". In the dialog, make sure the "Current selection
only" option under "Other Options" is checked. Leave the "Se
At 15:02 16/11/2013 +0100, Gordom Noname wrote:
Some columns in my spreadsheet are filed with data only partly (some
cells are blank). I need to put "0" value in this empty rows. [...]
But I was wondering if this task can be accomplished without adding
(even temporarily) additional column.
o
Hi Gordom,
On Sat, 16 Nov 2013 15:02:09 +0100
gordom wrote:
> Hallo everyone.
> Some columns in my spreadsheet are filed with data only partly (some
> cells are blank). I need to put "0" value in this empty rows. Of
> course I can add an extra column and use a formula like this one for
> examp
Hallo everyone.
Some columns in my spreadsheet are filed with data only partly (some
cells are blank). I need to put "0" value in this empty rows. Of course
I can add an extra column and use a formula like this one for example
=IF(ISBLANK(cell_address);"0";cell_address)
It works perfectly fine.
, the correct
answer is November 22, 2012.)
- Dennis
-Original Message-
From: . [mailto:l...@ebookring.net]
Sent: Monday, December 03, 2012 02:59
To:users@global.libreoffice.orgSubject: [libreoffice-users] Calc formula for US
Thanksgiving date
I need a formula for Calc to determine t
2012/12/3 Brian Barker :
> At 05:58 03/12/2012 -0500, Dottie Noname wrote:
>>
>> I need a formula for Calc to determine the US Thanksgiving date for a
>> given year.
>
>
> I could have answered this sooner but resisted at first because of the
> unfriendly - frankly selfish - habit of suppressing an
At 05:58 03/12/2012 -0500, Dottie Noname wrote:
I need a formula for Calc to determine the US Thanksgiving date for
a given year.
I could have answered this sooner but resisted at first because of
the unfriendly - frankly selfish - habit of suppressing any
name. How is anyone to refer to you
)
>
> - Dennis
>
> -Original Message-
> From: . [mailto:l...@ebookring.net]
> Sent: Monday, December 03, 2012 02:59
> To: users@global.libreoffice.org
> Subject: [libreoffice-users] Calc formula for US Thanksgiving date
>
> I need a formula for Calc to determine the US Thanks
2012.)
- Dennis
-Original Message-
From: . [mailto:l...@ebookring.net]
Sent: Monday, December 03, 2012 02:59
To: users@global.libreoffice.org
Subject: [libreoffice-users] Calc formula for US Thanksgiving date
I need a formula for Calc to determine the US Thanksgiving date for a
given year.
T
I need a formula for Calc to determine the US Thanksgiving date for a
given year.
Thanks
--
www.eBookRing.net
The designer and maker of the original eBookRing
The perfect stand for eReaders, iPads, iPhones, tablet computers and other
electronic devices.
Patent Pending
--
For unsubscribe in
Hi,
Michael D. Setzer II schrieb:
If I understand what you are trying to do.
I put this data in Column A and Column B.
COLACOLB
A 7
G 87
T 1
A 1
G 6
T 7
A 43
G 3
T 2
I put the criteria in G1 and G2
COLA
A
Then used the formula to get the value.
=DMIN(A1:B10,"COLB",G1:G2
ibreoffice-users] Calc Formula Help
Send reply to: users@global.libreoffice.org
> So I have two columns of data, column A which has a single character (A, G,
> or T) and column B which has a number. I am trying to determine the minimum
> value in B that corresponds to an "A&qu
To: users@global.libreoffice.org
Sent: Fri, 2 September, 2011 12:05:54
Subject: [libreoffice-users] Calc Formula Help
So I have two columns of data, column A which has a single character (A, G,
or T) and column B which has a number. I am trying to determine the minimum
value in B that corresponds to
So I have two columns of data, column A which has a single character (A, G,
or T) and column B which has a number. I am trying to determine the minimum
value in B that corresponds to an "A" in column A.
This is the forumla I came up with after looking at tutorials and reading
the documentation:
=
45 matches
Mail list logo