Formula names and accents or other signs

l10n
#1

Hi all,

Following-up on a issue that was open because accents in Formula names
in some languages, would it be problematic for your language if we set
as a rule to not put any sign in Formula names but the dot (dot) as in
en_US?
Would that be too difficult because there is no corresponding meaning
without? For FR for example, we decided to remove them but that doesn't
change the meaning of the word and it's often that capitals are not
accentuated, so people are already used to read them.
Thanks for your feedback
Cheers
Sophie

#2

In our locale, we don't localize formula names anyway, so it's not an issue.

If accents are a problem how about non-Latin scripts like Chinese?

Michael

Sgrìobh Sophie na leanas 29/09/2016 aig 16:53:

#3

Hello Sophie

I have discussed with the pt-BR community and it is a sound *go* to
remove accents in functions names. We have names with more than one dot
as =É.NÃO.DISP() that must be transformed as =E.NAO.DISP(), thus a
script that turns accented characters to its non-accented character is
enough, leaving dots where they are.

Questions: will the script change

1) the names of the function in the whole Calc UI (not only in the
formula/source/core/resource.po file)?

and

2) the help files as well?

Finally, is it going to be carried in the next release (5.3) or in the
forthcoming 5.2.3 update?

Kind regards

Olivier

#4

Hi Olivier,

Hello Sophie

I have discussed with the pt-BR community and it is a sound *go* to
remove accents in functions names. We have names with more than one dot
as =É.NÃO.DISP() that must be transformed as =E.NAO.DISP(), thus a
script that turns accented characters to its non-accented character is
enough, leaving dots where they are.

Questions: will the script change

1) the names of the function in the whole Calc UI (not only in the
formula/source/core/resource.po file)?

and

2) the help files as well?

Finally, is it going to be carried in the next release (5.3) or in the
forthcoming 5.2.3 update?

Thanks for your feedback. For the moment, there is no script, I was only
discussing the possibility to have the "no signs else than dot" as a
rule or not, it appears that some languages have to keep accents (which
is not so surprising :). But if you want to write a script you're welcome :slight_smile:

Cheers
Sophie

#5

Hi!

Sophie kirjoitti 2016-09-29 18:53:

Following-up on a issue that was open because accents in Formula names
in some languages, would it be problematic for your language if we set
as a rule to not put any sign in Formula names but the dot (dot) as in
en_US?

I'm basically fine with removing other separator characters. However for
Finnish this needs to be a manual change (not scripted) because we have
one case where underscore character is used so that there are
two versions of the same function: another with dot and another
with underscore: HYPERGEOM_JAKAUMA and HYPERGEOM.JAKAUMA. This messy
situation (caused by trying to be compatible with translated names
in some old version of Excel) needs to be dealt with first.

Would that be too difficult because there is no corresponding meaning
without? For FR for example, we decided to remove them but that doesn't
change the meaning of the word and it's often that capitals are not
accentuated, so people are already used to read them.

Accented characters Ä and Ö should be allowed for Finnish. They are
also used in formula names in Finnish version of Excel. I fear that
removing them would simply be considered a regression by most users.

Thanks for asking feedback!

Harri

#6

...

Thanks for your feedback. For the moment, there is no script, I was only
discussing the possibility to have the "no signs else than dot" as a
rule or not, it appears that some languages have to keep accents (which
is not so surprising :). But if you want to write a script you're

welcome :slight_smile:

In Esperanto (EO) the accents are essential. Missing them out often
totally changes the meaning, e.g.
celo = aim, purpose; ĉelo = cell
salti = to jump; ŝalti = to switch

Regards
Donald