Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index


Hi,

I was pointed to a possible bug with Calc function LEFT() when entering an array for the text 
argument. In some cases it worked, in other it didn't. I created bug 89358 with an attachment 
showing the behaviour.

I found out it is because when ScInterpreter::GetString() is called  when the stack value is an 
array (svDoubleRef), the string is taken from the array dependent on the relative position of the 
formula (ScInterpreter::DoubleRefToPosSingleRef()).

As ScInterpreter::GetString() is used in all Calc functions accepting text arguments, I don't know 
if there cases where this formula-position-dependent cell picking from arrays is useful. Therefor, 
changing that code may produce unwanted results elsewhere.

Does anyone know of cases where this formula-position-dependent stuff is needed?
I would like to change the code so that -if no formula-position-dependent stuff is needed - the top 
left cell of the range is used.

The specific code has been there since September 2000 at least.

Winfried



Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.