Yes, some conditional statement (if..., then...) would be basically how
to examine the value of a cell and assign a value (e.g., background
color) to that cell. I would think though there would be a different
problem implementing it.
Jakob, you say you wish to "identify the current date by mar
Hi,
You can use conditional formatting. Option "Cell value is = x." and
today() as value.
Hope this helps.
Jean
Le mercredi 26 mai 2021 à 21:20 +, Jakob Cornelis via gnumeric-list
a écrit :
> I use gnumeric’s calendar template for an events and appointments
> calendar. One feature that would
I use gnumeric’s calendar template for an events and appointments calendar.
One feature that would very useful would be to automatically identify the
current date by marking the relevant cell(s). This could be by background
colour (which would be my preference), or bolding the day box, or something
On Sun, May 23, 2021 at 12:42:29PM -0600, Andreas J. Guelzow wrote:
> Hi,
>
> On 2021-05-22 7:26 p.m., Steven D'Aprano wrote:
> >
> >input0.24997
>
> You are playing at the edge of the maximum mantissa length. Did you ever
> try using that number in LibreOffice or Excel?
h, but today we have a wide installed base of 'IEEE machines', and i'm not searching for 'specialised computation', but for gnumeric to avoid fails and keep it's position as the spreadsheet with the best mathematical precision / correctness, the more of that works th
Hi,
On 2021-05-22 7:26 p.m., Steven D'Aprano wrote:
input 0.24997
You are playing at the edge of the maximum mantissa length. Did you ever
try using that number in LibreOffice or Excel?
Andreas
___
gnumeric-list mailing list
g
Here is a summary of the results from rounddown. Cells are set to
display 17 decimal places.
input 0.24997
digits rounddown expected
1 0.20001 0.20001
2 0.25000 0.23999
3 0.250
Hi,
Do you prefer to be called "nullzwei" or "b"?
I think that your issue is that you believe that roundup and rounddown
do not behave correctly, if that correct?
You have the value:
0.24997
and rounddown(0.24997, 16) returns 0.25 exactly, which is
larger than the ori
hello list,
this is a follow up to a question mailed some days ago,
i have some problems with rounding in gnumeric, tried to make a sheet which shows them in detail, see attachement,
in short: roundup and rounddown act irregularly with some values, i'd consider it important to fix that as
,16)' go to the smaller value ~0.24994?
that's clueless to me ...
regards,
b.
Gesendet: Mittwoch, 19. Mai 2021 um 07:44 Uhr
Von: "aguelzow"
An: newbie...@gmx.de, gnumeric-list@gnome.org
Betreff: RE: follow up - newbie questions, sum over range, rounding of
2:29 (GMT-07:00) To:
gnumeric-list@gnome.org Subject: follow up - newbie questions, sum over range,
rounding of special problematic values
hi @all, i'm new here, pls. excuse if i am not well adapted to the manners,
(asked something some time ago, got answer from a 'private email'
hi @all, i'm new here, pls. excuse if i am not well adapted to the manners,
(asked something some time ago, got answer from a 'private email', but none to follow up questions, thus try to write to the list again, sorry if wrong,
>> 1. gnumeric produces much better sums over ranges than other
1. We use an extension of Kahan summation, see
https://gitlab.gnome.org/GNOME/goffice/-/blob/master/goffice/math/go-accumulator.c
This is done for sum(...), not for a+b
2. We don't even attempt to be smart here. It's pointless as the
partial sums often sit in their own cells and must be displ
hi @all, i'm new here, pls. excuse if i am not well adapted to the manners
i'm studying how to get correct results for floating point calculations, and am curious about three points:
1. gnumeric produces much better sums over ranges than other spreadsheets which i have seen (LO calc and MS exc
Dave,
I'd do this in two steps.
1) In column C calculate the hour value for each reading. In cell C2
enter =DATE(YEAR($A2),MONTH($A2),DAY($A2))+TIME(HOUR($A2),0,0) and
copy it down the column.
2) In column D sum all the readings that match the hour value for the
current reading. Enter this in ce
I have some spreadsheets with about 30K rows each. In column A is a
time and date like this - 2017-11-01 00:01:16 UTC. The time increments
monotonically for a month then that's all the rows.
I'd like to sum the readings for each hour, The number of rows per hour
varies a bit with uneven intervals.
t, over time, it must have been
> forgotten. If thiss is anything to go by, it was probably forgotten with
> some rlief. It does seem to be a very complicated and un-intuitive way to go
> about things. If it had been a manually drawn graph, the setting up would
> have taken just a few min
as far as I can see does
> not exist in this version
>
>
>
> --
> View this message in context:
> http://gnome-apps.13852.n7.nabble.com/A-plea-from-a-semi-newbie-tp66352p66361.html
> Sent from the GnuMeric mailing list archive at Nabble.com.
> __
52.n7.nabble.com/A-plea-from-a-semi-newbie-tp66352p66361.html
Sent from the GnuMeric mailing list archive at Nabble.com.
___
gnumeric-list mailing list
gnumeric-list@gnome.org
https://mail.gnome.org/mailman/listinfo/gnumeric-list
few minutes.
--
View this message in context:
http://gnome-apps.13852.n7.nabble.com/A-plea-from-a-semi-newbie-tp66352p66365.html
Sent from the GnuMeric mailing list archive at Nabble.com.
___
gnumeric-list mailing list
gnumeric-list@gnome.org
https://mail.gnome.org/mailman/listinfo/gnumeric-list
temperature range. Since this data had to be entered
> manually, it was the greater chore. So the left hand X axis indicator
> registered the temperature, and another, to the right indicated rainfall.
>
>
>
> --
> View this message in context:
> http://gnome-apps.13852.n7.n
h the temperature range. Since this data had to be entered
manually, it was the greater chore. So the left hand X axis indicator
registered the temperature, and another, to the right indicated rainfall.
--
View this message in context:
http://gnome-apps.13852.n7.nabble.com/A-plea-from-a-semi-n
;
>
> --
> View this message in context:
> http://gnome-apps.13852.n7.nabble.com/A-plea-from-a-semi-newbie-tp66352.html
> Sent from the GnuMeric mailing list archive at Nabble.com.
> ___
> gnumeric-list mailing list
&g
e and time), to form the X axis and column C (temperature) to form the
Y axis. Any ideas, please?
--
View this message in context:
http://gnome-apps.13852.n7.nabble.com/A-plea-from-a-semi-newbie-tp66352.html
Sent from the GnuMeric mailing list archive at
> Haines Brown wrote:
> > I have a worksheet that has data A2:N1178, and I want to filter it to
> > create a new worksheet that has select columns from the original as
> > well as select rows based on a filter.
> >
> > My first question is whether I necessarily must use an advanced
> > filter. The
Haines Brown wrote:
I have a worksheet that has data A2:N1178, and I want to filter it to
create a new worksheet that has select columns from the original as
well as select rows based on a filter.
My first question is whether I necessarily must use an advanced
filter. The autofilter seems to hav
I have a worksheet that has data A2:N1178, and I want to filter it to
create a new worksheet that has select columns from the original as
well as select rows based on a filter.
My first question is whether I necessarily must use an advanced
filter. The autofilter seems to have a maximum capacity
The specific input regarding a suitable script very much
appreciated. Thank you. Indeed, it gives me a base from which to
start.
Haines
___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list
On Tue, Mar 01, 2005 at 02:51:24PM -0500, Haines Brown wrote:
>X-Original-To: [EMAIL PROTECTED]
>From: "Andreas J. Guelzow" <[EMAIL PROTECTED]>
>Cc: Gnumeric Dev List
>Organization: Taliesin Software
>Date: Sun, 27 Feb 2005 09:14:19 -0700
>X-Virus-Scanned: by amavisd-new-20
On Tue, 2005-03-01 at 14:51 -0500, Haines Brown wrote:
>X-Original-To: [EMAIL PROTECTED]
>From: "Andreas J. Guelzow" <[EMAIL PROTECTED]>
>Cc: Gnumeric Dev List
>Organization: Taliesin Software
>Date: Sun, 27 Feb 2005 09:14:19 -0700
>X-Virus-Scanned: by amavisd-new-20030616-
X-Original-To: [EMAIL PROTECTED]
From: "Andreas J. Guelzow" <[EMAIL PROTECTED]>
Cc: Gnumeric Dev List
Organization: Taliesin Software
Date: Sun, 27 Feb 2005 09:14:19 -0700
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at hartford-hwp.com
X-Spam-Status: No, hits=0.0 tag
On Sun, 2005-02-27 at 10:11 -0500, Haines Brown wrote:
> > > I'm told that gnumeric-->TeX is the conventional way of doing labels,
> > > but I'm uncertain how to go about that. Can anyone point me to a
> > > source of information or offer a little guidance?
>
> > Hi Haines,
> >The sim
On Sun, 27 Feb 2005, Haines Brown wrote:
> Date: Sun, 27 Feb 2005 10:11:57 -0500 (EST)
> From: Haines Brown <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: gnumeric-list@gnome.org
> Subject: Re: A newbie asks about printing labels
>
> > > I'm told that gnu
rything else in LaTeX.)
> Can anyone point me to a
> source of information or offer a little guidance?
>
> And a newbie question about the suitability of my organization of data
> in gnumeric for printing labels. I have put addresses in three
> columns: a) a column, usually empty,
> > I'm told that gnumeric-->TeX is the conventional way of doing labels,
> > but I'm uncertain how to go about that. Can anyone point me to a
> > source of information or offer a little guidance?
> Hi Haines,
>The simplest is to export your gnumeric data file to a csv then
> use AbiW
abels from it. I don't use a word processor, but LaTeX (with
> emacs under Debian sarge).
>
> I'm told that gnumeric-->TeX is the conventional way of doing labels,
> but I'm uncertain how to go about that. Can anyone point me to a
> source of information or offer a litt
vert and your potential convertion
script it can easy be automated.
> And a newbie question about the suitability of my organization of data
> in gnumeric for printing labels. I have put addresses in three
> columns: a) a column, usually empty, but available for cases where
> there might be
word processor, but LaTeX (with
emacs under Debian sarge).
I'm told that gnumeric-->TeX is the conventional way of doing labels,
but I'm uncertain how to go about that. Can anyone point me to a
source of information or offer a little guidance?
And a newbie question about the suitabil
38 matches
Mail list logo