Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

I'm sorry if the correct way of doing things offends you.

aus+uk / uk.comp.homebuilt / OT: Excel weirdness

SubjectAuthor
* OT: Excel weirdnessPhilip Herlihy
+- Re: OT: Excel weirdness [Found it]Philip Herlihy
`* Re: OT: Excel weirdnessAndy Burns
 `* Re: OT: Excel weirdnessPhilip Herlihy
  `- Re: OT: Excel weirdnessPhilip Herlihy

1
OT: Excel weirdness

<MPG.3ed4494c31ee6e22989a63@news.eternal-september.org>

  copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=3528&group=uk.comp.homebuilt#3528

  copy link   Newsgroups: uk.comp.homebuilt
Path: i2pn2.org!i2pn.org!eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: PhillipH...@SlashDevNull.invalid (Philip Herlihy)
Newsgroups: uk.comp.homebuilt
Subject: OT: Excel weirdness
Date: Sun, 21 May 2023 16:29:50 +0100
Organization: A noiseless patient Spider
Lines: 13
Message-ID: <MPG.3ed4494c31ee6e22989a63@news.eternal-september.org>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Injection-Info: dont-email.me; posting-host="b4507d2ebd750127288b463e5f544cc4";
logging-data="1727883"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/nBvy+juqVbR8TRBdwoqmJCKQTervoMJY="
User-Agent: MicroPlanet-Gravity/3.0.10 (GRC)
Cancel-Lock: sha1:xNuS/x5VI7JYmz4ibALCiJTkvKQ=
 by: Philip Herlihy - Sun, 21 May 2023 15:29 UTC

(I haven't found a good Excel group, and I know no more knowledgeable group
than this one!)

I have a friend whose surname is "Alway". As I'm putting together a mailing
list, I found myself typing that into Excel. It corrects it to "Always" -
whatever I do; there is no pop-up options dialogue. In the end, I typed =LEFT
("Always", 5), copied that, and then pasted values. Is this just a bug?
(Excel 2013)

--

Phil, London

Re: OT: Excel weirdness [Found it]

<MPG.3ed44be637a617d1989a64@news.eternal-september.org>

  copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=3529&group=uk.comp.homebuilt#3529

  copy link   Newsgroups: uk.comp.homebuilt
Path: i2pn2.org!i2pn.org!eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: PhillipH...@SlashDevNull.invalid (Philip Herlihy)
Newsgroups: uk.comp.homebuilt
Subject: Re: OT: Excel weirdness [Found it]
Date: Sun, 21 May 2023 16:41:01 +0100
Organization: A noiseless patient Spider
Lines: 21
Message-ID: <MPG.3ed44be637a617d1989a64@news.eternal-september.org>
References: <MPG.3ed4494c31ee6e22989a63@news.eternal-september.org>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Injection-Info: dont-email.me; posting-host="b4507d2ebd750127288b463e5f544cc4";
logging-data="1727883"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19Y/oQFhpe1MVB6LcMSNlcbQz6HyTWRtjw="
User-Agent: MicroPlanet-Gravity/3.0.10 (GRC)
Cancel-Lock: sha1:l+9llKzkmEI163Pvrq59rGE1MP4=
 by: Philip Herlihy - Sun, 21 May 2023 15:41 UTC

In article <MPG.3ed4494c31ee6e22989a63@news.eternal-september.org>, Philip
Herlihy wrote...
>
> (I haven't found a good Excel group, and I know no more knowledgeable group
> than this one!)
>
> I have a friend whose surname is "Alway". As I'm putting together a mailing
> list, I found myself typing that into Excel. It corrects it to "Always" -
> whatever I do; there is no pop-up options dialogue. In the end, I typed =LEFT
> ("Always", 5), copied that, and then pasted values. Is this just a bug?
> (Excel 2013)

The Autocorrect options contain a (long) list of what are supposedly common
mis-spellings, and it's in there. What I found surprising is that it corrects
it even when typing a string parameter to a function (as in the above example).

Sorry for the distraction - carry on, troops...

--

Phil, London

Re: OT: Excel weirdness

<kcv33sFn7q3U1@mid.individual.net>

  copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=3530&group=uk.comp.homebuilt#3530

  copy link   Newsgroups: uk.comp.homebuilt
Path: i2pn2.org!i2pn.org!usenet.goja.nl.eu.org!3.eu.feeder.erje.net!feeder.erje.net!news-2.dfn.de!news.dfn.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: use...@andyburns.uk (Andy Burns)
Newsgroups: uk.comp.homebuilt
Subject: Re: OT: Excel weirdness
Date: Sun, 21 May 2023 18:35:58 +0100
Lines: 8
Message-ID: <kcv33sFn7q3U1@mid.individual.net>
References: <MPG.3ed4494c31ee6e22989a63@news.eternal-september.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: individual.net gxRrYQhxiAY9tJCcyvwwXA1hDvnKlTQ3lsYZZZmvZPFiJdBZDr
Cancel-Lock: sha1:452koj9nO/9smYglNMNjPd+ZE4c=
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101
Thunderbird/102.11.0
Content-Language: en-GB
In-Reply-To: <MPG.3ed4494c31ee6e22989a63@news.eternal-september.org>
 by: Andy Burns - Sun, 21 May 2023 17:35 UTC

Philip Herlihy wrote:

> I have a friend whose surname is "Alway". As I'm putting together a mailing
> list, I found myself typing that into Excel. It corrects it to "Always" -

What if you prefix with a single quote to make it a string literal e.g.
'Alway

Re: OT: Excel weirdness

<MPG.3ed58a399ed3f9a5989a66@news.eternal-september.org>

  copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=3531&group=uk.comp.homebuilt#3531

  copy link   Newsgroups: uk.comp.homebuilt
Path: i2pn2.org!i2pn.org!eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: PhillipH...@SlashDevNull.invalid (Philip Herlihy)
Newsgroups: uk.comp.homebuilt
Subject: Re: OT: Excel weirdness
Date: Mon, 22 May 2023 15:19:15 +0100
Organization: A noiseless patient Spider
Lines: 17
Message-ID: <MPG.3ed58a399ed3f9a5989a66@news.eternal-september.org>
References: <MPG.3ed4494c31ee6e22989a63@news.eternal-september.org> <kcv33sFn7q3U1@mid.individual.net>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Injection-Info: dont-email.me; posting-host="641ef65fd885066985ff63c6ff28f80a";
logging-data="2310705"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX197txQh6a8t1KAWGvkQVObCUqc4jf7tqfw="
User-Agent: MicroPlanet-Gravity/3.0.10 (GRC)
Cancel-Lock: sha1:uiMw917H+HNU9iX+SNa/ZdKrSSM=
 by: Philip Herlihy - Mon, 22 May 2023 14:19 UTC

In article <kcv33sFn7q3U1@mid.individual.net>, Andy Burns wrote...
>
> Philip Herlihy wrote:
>
> > I have a friend whose surname is "Alway". As I'm putting together a mailing
> > list, I found myself typing that into Excel. It corrects it to "Always" -
>
> What if you prefix with a single quote to make it a string literal e.g.
> 'Alway

Oddly, that seemed to work the first time I tried it, but subsequently didn't.
Can't explain that. The =LEFT() option did work, although it tried to correct
the string parameter (but accepted the edit).

--

Phil, London

Re: OT: Excel weirdness

<MPG.3ed58b076dfd72ae989a67@news.eternal-september.org>

  copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=3533&group=uk.comp.homebuilt#3533

  copy link   Newsgroups: uk.comp.homebuilt
Path: i2pn2.org!i2pn.org!eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: PhillipH...@SlashDevNull.invalid (Philip Herlihy)
Newsgroups: uk.comp.homebuilt
Subject: Re: OT: Excel weirdness
Date: Tue, 23 May 2023 11:51:10 +0100
Organization: A noiseless patient Spider
Lines: 28
Message-ID: <MPG.3ed58b076dfd72ae989a67@news.eternal-september.org>
References: <MPG.3ed4494c31ee6e22989a63@news.eternal-september.org> <kcv33sFn7q3U1@mid.individual.net> <MPG.3ed58a399ed3f9a5989a66@news.eternal-september.org>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Injection-Info: dont-email.me; posting-host="bc0ac013b5616d65cff6e03f080ca705";
logging-data="2663737"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/31iKtTVU/MBFQPyzoZYKbkejLCygX5+Q="
User-Agent: MicroPlanet-Gravity/3.0.10 (GRC)
Cancel-Lock: sha1:ywCie65zbLJ+sqRJnFySeUreZVE=
 by: Philip Herlihy - Tue, 23 May 2023 10:51 UTC

In article <MPG.3ed58a399ed3f9a5989a66@news.eternal-september.org>, Philip
Herlihy wrote...
>
> In article <kcv33sFn7q3U1@mid.individual.net>, Andy Burns wrote...
> >
> > Philip Herlihy wrote:
> >
> > > I have a friend whose surname is "Alway". As I'm putting together a mailing
> > > list, I found myself typing that into Excel. It corrects it to "Always" -
> >
> > What if you prefix with a single quote to make it a string literal e.g.
> > 'Alway
>
> Oddly, that seemed to work the first time I tried it, but subsequently didn't.
> Can't explain that. The =LEFT() option did work, although it tried to correct
> the string parameter (but accepted the edit).

Correction: it was resolute in autocorrecting the string parameter! But when
I copied and pasted the value of =LEFT("Always", 5) the destination cell
finally received the desired string. Doubtless if I ever tinker with that cell
it'll do the same again, unless I delete that standard autocorrection.

My mistake, of course, was to think that the absence of an options pop-up meant
that autocorrect wasn't in play.

--

Phil, London

1
server_pubkey.txt

rocksolid light 0.9.81
clearnet tor