Issue 83824 - Catalan Calc does not distinguess between ADDRESS and MATCH formulas
Summary: Catalan Calc does not distinguess between ADDRESS and MATCH formulas
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2007-11-21 19:08 UTC by jordimas
Modified: 2013-08-07 15:13 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

Shows bug (30.19 KB, text/plain)
2008-02-02 12:46 UTC, jordimas
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description jordimas 2007-11-21 19:08:44 UTC

There is a problem in the formula translation in the Catalan version.

Catalan Calc uses the same translation for ADDRESS and MATCH formulas that makes
them impossible to use.

In the original translation that we send 'ADDRESS' was translated to 'ADREÇA'

See original PO:

#: compiler.src#RID_SC_FUNCTION_NAMES.SC_OPCODE_ADDRESS.string.text
msgid "ADDRESS"
msgstr "ADREÇA"

#: compiler.src#RID_SC_FUNCTION_NAMES.SC_OPCODE_MATCH.string.text
msgid "MATCH"

We are afraid that some of the tools involved in the conversion of translations
do not support 'Ç' as character or as part of the formula names.

This can be reproduced with any 2.x build.

The quickest way of fixing this is replacing "COINCIDEIX" by "ADREÇA" in as
translation for 'ADDRESS'


Comment 1 rafaella.braconi 2007-11-22 09:10:05 UTC
Comment 2 pavel 2007-11-22 09:23:27 UTC
Hmm, interesting.

#i73559# contained the correct GSI file, but the difference in the cws was about:


in the localize.sdf file.

I have now verified, that if I merge the correct line with the string ADREÇA, that strings ends up in the 
localize.sdf file.

So: what happened?

Ivo: can you please check what is in the database?

It should be enough to submit the new GSI file next tim,e but please check the merged string.
Comment 3 rafaella.braconi 2007-12-06 09:18:03 UTC
Comment 4 ivo.hinkelmann 2007-12-20 13:01:59 UTC
changed in the database, vg please fix in the next l10n build
Comment 5 jordimas 2007-12-24 12:46:02 UTC

The information in Pootle was correct. The problem is that the formula name got
lost/broken during the creation of the SDF file that we sent for 2.3.

Then in 2.4 the problem is going to be fixed since you create the files from Pootle.

What I think is important is that we make this fix in the 2.3 branch.

Thanks. Jordi,
Comment 6 vg 2008-01-04 18:06:52 UTC
fixed in CWS localisation27
Comment 7 petr.dudacek 2008-01-09 10:31:10 UTC
Hi Jordi,
can you please check whether this issue is fixed in the localisation27 cws build?

If it is, set it as verified, otherwise reopen it.

Comment 8 jordimas 2008-02-02 12:44:02 UTC
I can confirm that this error still exists in the latest build OpenOffice 2.4 build:

Comment 9 jordimas 2008-02-02 12:46:54 UTC
Created attachment 51324 [details]
Shows bug
Comment 10 vg 2008-02-04 10:28:46 UTC
reassign for the next round...
Comment 11 jordimas 2008-02-04 20:18:24 UTC
This is an important issue with direct impact on the user (since two formulas
have the same name). 

I strongly believe that this should be fixed in the 2.4x series

Comment 12 pavel 2008-02-23 19:19:01 UTC

Comment 13 Martin Hollmichel 2008-09-26 10:31:10 UTC
is there any update yet ?
Comment 14 Martin Hollmichel 2009-04-24 09:09:14 UTC
Comment 15 thorsten.ziehm 2009-05-18 13:31:57 UTC
Hi Jordi, can you check this issue in OOo 3.1. If it is fixed, please close the
issue. If it is still open, please work with ihi how you can get it fixed for
the next release. I change the target to 3.x until than to get all issues from
the 3.1 target, because OOo 3.1 is released since some days.
Comment 16 Rob Weir 2013-07-30 02:41:09 UTC
Reset assignee on issues not touched by assignee in more than 1000 days.