https://bugs.freedesktop.org/show_bug.cgi?id=87936

Robinson Tryon (qubit) <qu...@runcibility.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |qu...@runcibility.com

--- Comment #11 from Robinson Tryon (qubit) <qu...@runcibility.com> ---
(In reply to Luuk from comment #9)
> When someone copies/pastes text from anywhere to another place,
> This input should be checked.
> 
> If the receiving application cannot do a correct thing with it, 
> it should not change ANYTHING to the copied text.
> 
> It is up to the user to make sure that the copied/pasted text is correct.
> (and not to an assumption made by some developer!)

Yeah, there's definitely a judgment call going on here; I'm reticent to
impulsively pick one interpretation :-)

(In reply to Luuk from comment #10)
> (In reply to GerardF from comment #8)
> > It is exactly the same as when you wrote ,35 in a cell:
> > Calc add a leading 0 and display 0,35.
> > Here you have commas not preceded by 0 and Calc adds them.

that makes a lot of sense

> This is correct behaviour, but when the text you entered contains 2 (or
> more) commas it should not change the text, and throw an error

That sounds like a plausible strategy. I think I'd also be okay with it adding
explicit separators such as "18,19; 0,19; 0,5" etc.

> When entering '=1,2,3,4,5,6,7,8,9' in a cell without single quotes)
> Calc also 'decides' to change it to : '=1,20,30,40,50,60,7,8,9' which is
> WRONG

In the absence of any set parsing rules, I don't see it as being wrong. I agree
that
1) There should be better documentation about HOW we parse cell input
2) We should be more explicit with the output (i.e. add separators), and
3) In some cases we should give a warning/error

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to