Re: [libreoffice-users] Bug report in calc, V.7.4

On 1/9/22 17:51, Harvey Nimmo wrote:
> On Thu, 2022-09-01 at 17:39 +1000, Stephen Morris wrote:
> > On 29/8/22 09:21, Regina Henschel wrote:
> > > Hi Matthias,
> > >
> > > Matthias Lammer schrieb am 29.08.2022 um 00:24:
> > > > Dear LibreOffice team,
> > > >
> > > > I want to file a very severe bug as follows:
> > > >
> > > > I create a simple function in Basic:
> > > >
> > > > Function myAdd(x, y, z)
> > > >     myAdd = x + y + z
> > > > End Function
> > > >
> > > > Then I can call it as usual with =myAdd(...). Next, I want to
> > > > update
> > > > myAdd to subtract the values, I end up with:
> > > >
> > > > Function myAdd(x, y, z)
> > > >     myAdd = x - y - z
> > > > End Function
> > > >
> > > > I save my changes and press F9 for recalculation
> > > That will not work. Neither any of the cells referenced as
> > > parameter
> > > nor the formula in the cell has changed. So F9 will not detect any
> > > change.
> > >
> > >   but Calc still gives me
> > > > the value for the adding up the 3 values.
> > > You need to use a 'Recalculate Hard' in this case, that is
> > > Strg+Shift+F9.
> > Just a silly question, which key is Strg?
> >
> > regards,
> > Steve
> >
> > > Kind regards,
> > > Regina
> Strg is the German abbreviation for 'Steuerung', i.e. Control, Ctrl, on
> the English keyboard.
> Harvey
Thankyou.

regards,
Steve

>


--
To unsubscribe e-mail to: users+unsubscribe@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: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy