Re: New bug, looking for source location for setting Calc formulas

Thanks for looking Eike!

Good to know for sure that it is a bug rather than intended behavior.  I 
will contact a few others that are not on this list and update them.

On 08/30/2013 03:27 PM, Eike Rathke wrote:
> Hi Andrew,
>
> On Friday, 2013-08-30 01:27:05 -0400, Andrew Douglas Pitonyak wrote:
>
> > On 08/29/2013 10:44 PM, Andrew Douglas Pitonyak wrote:
> > > Setting the Formula property on a Calc cell has always expected
> > > English formulas. Use the FormulaLocal property otherwise. The new
> > > behavior is that the Formula property acts the same as
> > > FormulaLocal
> Plus .Formula is influenced by the current work locale (not UI
> language), which it should not.
>
> > > https://bugs.freedesktop.org/show_bug.cgi?id=67836
> I'll take a look.
>
> > > I became aware of this based on a post on the mailing list. Turns
> > > out there was already an open and not verified bug. I have
> > > verified the behavior but would like to chat with the responsible
> > > developer before changing to confirmed and asking the responsible
> > > party to consider backing out their change (as well as can be done
> > > after a release).
> Better fix it..
>
> Finding the range of commits btw that introduced a change in behavior
> can be done with bibisect, see
> https://wiki.documentfoundation.org/Bibisect
>
> > > Alternatively, I can at least document the new
> > > behavior that the two properties are identical so you might as
> > > well deprecate one.
> No, it's a bug.
>
> > Looks like setting the FormulaLocal property is probably handled in
> > sc/source/ui/unoobj/cellsuno.cxx
> > ScCellObj::SetOnePropertyValue
> > this calls SetString_Impl
> With (should be) bEnglish=true for .Formula and bEnglish=false for
> .FormulaLocal
>
> > My head hurts now.
> Understandably ;-)
>
>    Eike

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php