Issue 83824

Summary:

Catalan Calc does not distinguess between ADDRESS and MATCH formulas

Product:

Calc

Reporter:

jordimas <jmas>

Component:

editing

Assignee:

AOO issues mailing list <issues>

Status:

CONFIRMED ---

QA Contact:

Severity:

Trivial

Priority:

CC:

issues, ivo.hinkelmann, petr.dudacek

Version:

OOo 2.3

Target Milestone:

---

Hardware:

All

OS:

All

Issue Type:

ENHANCEMENT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
Shows bug	none

Description jordimas 2007-11-21 19:08:44 UTC

Hello,

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'
and 'MATCH' to 'COINCIDEIX'.

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"
msgstr "COINCIDEIX"

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 OpenOffice.org 2.x build.

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

Thanks,

Jordi,

Comment 1 rafaella.braconi 2007-11-22 09:10:05 UTC

retargetting

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:

- CONCIDEIX
+ CONICIDEX

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

reassigning

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

Hello,

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.

Thanks,
Petr

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:

http://ooo.services.openoffice.org/pub/OpenOffice.org/cws/upload/localization/localisation27/windows/

Jordi,

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

Jordi,

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

Petr?

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

reassign

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.