Ubuntu
openoffice.org package

[upstream] [hardy] Vertical Lookup fails if searched string contains parenthesis

Bug #207016 reported by Sébastien Bordenave
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenOffice
New
Undecided
Unassigned
openoffice.org (Ubuntu)
Triaged
Low
Unassigned

Bug Description

Vertical Lookup fails if searched string contains parenthesis, the same file in xls format works in excel

Revision history for this message
Sébastien Bordenave (sebastien-bordenave) wrote :

I am using Gutsy.
Same problem with openoffice 2.3 in windows xp environment.

Revision history for this message
Chris Cheney (ccheney) wrote :

Please attach example file that exhibits this problem.

Thanks,

Chris Cheney

Changed in openoffice.org:
status: New → Incomplete
Revision history for this message
Sébastien Bordenave (sebastien-bordenave) wrote :
  • test.ods Edit (10.0 KiB, application/vnd.oasis.opendocument.spreadsheet)

Here is an exemple :
I chose a value in the 2nd column of the 1st sheet list (the list comes from the values of the 2nd sheet)
On the 3rd sheet i use vertical lookup to get the corresponding "code" that goes with the chosen 2nd sheet value.
It gives an error if the searched value contains parenthesis.

Chris Cheney (ccheney)
Changed in openoffice.org:
status: Incomplete → New
Revision history for this message
Sébastien Bordenave (sebastien-bordenave) wrote :

Hi,
Same bahaviour with openoffice 2.4 (Ooo deb version).

Same behaviour with other separators as well : [test] and \test\ fail but {test} or #test# don't.

Revision history for this message
Chris Cheney (ccheney) wrote :

Also seen in upstream's openoffice.org 3.0.0m24.

Changed in openoffice.org:
importance: Undecided → Low
status: New → Triaged
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Bug attachments

Remote bug watches

Bug watches keep track of this bug in other bug trackers.