Bug 247752

Summary:	intranet:kspread:msoffice2003: kspread displays error for formulas across sheets named with special chars
Product:	[Applications] calligracommon	Reporter:	Lassi Nieminen <lassi.ta.nieminen>
Component:	filters	Assignee:	Calligra Bugs <calligra-bugs-null>
Status:	VERIFIED FIXED
Severity:	normal	CC:	swathi.vegesna999
Priority:	NOR	Keywords:	reproducible
Version:	unspecified
Target Milestone:	---
Platform:	Unlisted Binaries
OS:	All
Latest Commit:		Version Fixed In:
Attachments:	testdata to be opened in kspread screenshot of the document in msexcel screenshot of the document in kspread

Description David Faure 2010-08-13 20:38:50 UTC



---- Reported by lassi.ta.nieminen@nokia.com 2010-04-22 14:58:50 +0300 ----

Created an attachment
testdata to be opened in kspread

SOFTWARE VERSION:
  Kubuntu 9.10
  Koffice (svn version 1116292)
  Test document (MSOffice 2003): ms03_intranet_formula_secondsheet.xls

STEPS LEADING TO THE PROBLEM:
  1. Open the attached document in MSOffice.
  2. Open the same document in KOffice.
  3. Check the result of the formula in F14 cell.

    * sheet name is F&C

EXPECTED OUTCOME:
  Kspread should be able to display the formula result 
   correctly in F14 cell.
  see attachment ms03_intranet_formula_across_sheet'_msexcel.PNG

ACTUAL OUTCOME:
  Kspread should be able to display the formula result 
  correctly in F14 cell.
  see attachment ms03_formula_across_sheet_kword.png

FREQUENCY:
  Always



---- Additional Comments From lassi.ta.nieminen@nokia.com 2010-04-22 15:02:35 +0300 ----

Created an attachment
screenshot of the document in msexcel



---- Additional Comments From lassi.ta.nieminen@nokia.com 2010-04-22 15:02:50 +0300 ----

Created an attachment
screenshot of the document in kspread



--- Bug imported by faure@kde.org 2010-08-13 20:38  ---

This bug was previously known as _bug_ 165317.

Imported an attachment (id=50451)
Imported an attachment (id=50452)
Imported an attachment (id=50453)

Comment 1 Marijn Kruisselbrink 2011-08-17 06:57:01 UTC

Git commit 7c6c03f859a50308bda6f78475760c480a5de13b by Marijn Kruisselbrink.
Committed on 17/08/2011 at 08:56.
Pushed by mkruisselbrink into branch 'master'.

enclose sheet names in '' when they contain special chars
BUG: 247752

M  +18   -2    filters/tables/excel/sidewinder/formulas.cpp

http://commits.kde.org/calligra/7c6c03f859a50308bda6f78475760c480a5de13b

Comment 2 swathi 2011-12-08 07:56:10 UTC

Verified in eb82fab9a76582b318902667665df3d8c61a95b6.