51158 – invalid reference

Issue 51158 - invalid reference

Summary: invalid reference

Status:	CONFIRMED

Alias:	None

Product:	Calc
Classification:	Application
Component:	editing (show other issues)
Version:	OOo 1.1.4
Hardware:	PC Linux, all

Importance:	P3 Trivial with 2 votes (vote)
Target Milestone:	---
Assignee:	AOO issues mailing list
QA Contact:

URL:
Keywords:

Depends on:
Blocks:

Reported:	2005-06-23 15:42 UTC by dementiev_vo
Modified:	2017-05-20 11:13 UTC (History)
CC List:	1 user (show)

See Also:
Issue Type:	DEFECT
Latest Confirmation in:	---
Developer Difficulty:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.

Description dementiev_vo 2005-06-23 15:42:15 UTC

There is a problem with references in spreadsheets
Here are the steps needed to reproduce it
1 mkdir /tmp/ÐÐ‘Ð’Ð“Ð”Ð°Ð±Ð²Ð³Ð´ÐÐ‘Ð’Ð“Ð”Ð°Ð±Ð²Ð³Ð´ÐÐ‘Ð’Ð“Ð”Ð°Ð±Ð²Ð³Ð´ÐÐ‘Ð’Ð“Ð”Ð°Ð±Ð²Ð³Ð´
2 Using spreadsheet create two file  1.sxc Ð¸ 2.sxc and save them in the above
created directory
3 Using "=" in the first file create a reference to a cell in another file 
After that in the cell you get 
='file:///tmp/%d0%90%d0%91%d0%92%d0%93%d0%94%d0%b0%d0%b1%d0%b2%d0%b3%d0%b4%d0%90%d0%91%d0%92%d0%93%d0%94%d0%b0%d0%b1%d0%b2%d0%b3%d0%b4%d0%90%d0%91%d0%92%d0%93%d0%94%d0%b0%d0%b1%d0%b2%d0%b3%d0%b4%d0%90%d0%91%d0%92%d0%93%d0%94%d0%b0%d0%b1%d0%b2%d0%b3%d0%b4/2
that ends up in invalid reference and an error 513
If you make the directories name shorter
 /tmp/ÐÐ‘Ð’Ð“Ð”Ð°Ð±Ð²Ð³Ð´ÐÐ‘Ð’Ð“Ð”Ð°Ð±Ð²Ð³Ð´ÐÐ‘Ð’Ð“Ð”Ð°Ð±Ð²Ð³Ð´
then you get 
='file:///tmp/ÐÐ‘Ð’Ð“Ð”Ð°Ð±Ð²Ð³Ð´ÐÐ‘Ð’Ð“Ð”Ð°Ð±Ð²Ð³Ð´ÐÐ‘Ð’Ð“Ð”Ð°Ð±Ð²Ð³Ð´/2.sxc'#$Ð›Ð¸ÑÑ‚1.A1'
and it is fine
This was noticed with cyrillic name of the directory both under windows and linux OS
This is observed from 1.1.3  (maybe earlier) up to 2.0 beta

Comment 1 frank 2005-07-08 11:12:51 UTC

Hi Niklas,

seems to be a problem with the conversion from UTF8 characterset to the one used
in edit engine. Your construction site ?

Earlier target possible ?

Frank

Comment 2 Marcus 2017-05-20 11:13:25 UTC

Reset assigne to the default "issues@openoffice.apache.org".