---- Reported by lassi.ta.nieminen@nokia.com 2010-03-12 08:09:19 +0200 ---- Created an attachment Test data to be opened in kspread Test data cretaed in MSexcel 2007 SOFTWARE VERSION: Kubuntu 9.04 Koffice (svn version 1100620) Test document (MS excel 2007): me07_blank_personal_monthly_budget HARDWARE VERSION: PRECONDITIONS: STEPS LEADING TO PROBLEM: 1. Open the attached document in MS excel 2007. 2. Open the same document in KSpread. 3. Observe that table format is not retained in kspread for blank personal monthly budget file, in difference column #VALUE error is diaplayed.There are some symbols(triangle, cirlce) in difference column, those symbols are also not getting displayed. EXPECTED OUTCOME: Blank personal monthly budget template should be retained correctly ACTUAL OUTCOME: table format is not retained and symbols are also not retained in kspread for blank personal monthly budget template file FREQUENCY OF OCCURRENCE: always ---- Additional Comments From lassi.ta.nieminen@nokia.com 2010-03-12 08:10:00 +0200 ---- Created an attachment screen shot when viewed in kspread ---- Additional Comments From lassi.ta.nieminen@nokia.com 2010-03-12 08:10:48 +0200 ---- Created an attachment Screen shot when viewed in msoffice ---- Additional Comments From lassi.ta.nieminen@nokia.com 2010-04-01 16:18:59 +0300 ---- assign to me for further investigation --- Bug imported by faure@kde.org 2010-05-28 03:29 --- This bug was previously known as _bug_ 160431. Imported an attachment (id=46987) Imported an attachment (id=46988) Imported an attachment (id=46989) Unknown bug field "example" encountered while moving bug <example>2010-04-01 16:18:59</example>
Problem seems to be that in C22 Excel2007 has; =SUBTOTAL(109,[Projected Cost]) and kspread turns this into; =SUBTOTAL(109;Projected;Cost)
The [Projected Cost] is actually defined in sheet1.xml as; <c r="C11" s="20" t="s"><v>0</v></c> and referenzes in the sheet1.xml.rel via; <Relationship Id="rId2" Target="../tables/table1.xml" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/table"/> the table1.xml which defines a auto-filter via; <autoFilter ref="B11:E21"/> So, that means we can either work around or (better) implement auto-filters before (see bug #239526 and bug #239207 and bug #239209 ).
Dear Bug Submitter, This bug has been stagnant for a long time. Could you help us out and re-test if the bug is valid in the latest version? I am setting the status to NEEDSINFO pending your response, please change the Status back to REPORTED when you respond. Thank you for helping us make KDE software even better for everyone!
Dear Bug Submitter, This is a reminder that this bug has been stagnant for a long time. Could you help us out and re-test if the bug is valid in the latest version? This bug will be moved back to REPORTED Status for manual review later, which may take a while. If you are able to, please lend us a hand. Thank you for helping us make KDE software even better for everyone!
Thank you for reporting this issue in KDE software. As it has been a while since this issue was reported, can we please ask you to see if you can reproduce the issue with a recent software version? If you can reproduce the issue, please change the status to "REPORTED" when replying. Thank you!
Dear Bug Submitter, This bug has been in NEEDSINFO status with no change for at least 15 days. Please provide the requested information as soon as possible and set the bug status as REPORTED. Due to regular bug tracker maintenance, if the bug is still in NEEDSINFO status with no change in 30 days the bug will be closed as RESOLVED > WORKSFORME due to lack of needed information. For more information about our bug triaging procedures please read the wiki located here: https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging If you have already provided the requested information, please mark the bug as REPORTED so that the KDE team knows that the bug is ready to be confirmed. Thank you for helping us make KDE software even better for everyone!
This bug has been in NEEDSINFO status with no change for at least 30 days. The bug is now closed as RESOLVED > WORKSFORME due to lack of needed information. For more information about our bug triaging procedures please read the wiki located here: https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging Thank you for helping us make KDE software even better for everyone!