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

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


-- 
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