Bug 247752 - intranet:kspread:msoffice2003: kspread displays error for formulas across sheets named with special chars
Summary: intranet:kspread:msoffice2003: kspread displays error for formulas across she...
Status: VERIFIED FIXED
Alias: None
Product: calligracommon
Classification: Applications
Component: filters (show other bugs)
Version: unspecified
Platform: Unlisted Binaries All
: NOR normal
Target Milestone: ---
Assignee: Calligra Bugs
URL:
Keywords: reproducible
Depends on:
Blocks:
 
Reported: 2010-04-22 13:58 UTC by Lassi Nieminen
Modified: 2011-12-08 07:56 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments
testdata to be opened in kspread (13.50 KB, application/vnd.ms-excel)
2010-04-22 13:58 UTC, Lassi Nieminen
Details
screenshot of the document in msexcel (98.53 KB, image/png)
2010-04-22 14:02 UTC, Lassi Nieminen
Details
screenshot of the document in kspread (197.19 KB, image/png)
2010-04-22 14:02 UTC, Lassi Nieminen
Details

Note You need to log in before you can comment on or make changes to this bug.
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.