Bug 59061 - FORMATTING / FORMULA with user defined formatting (prolly imported from Excel) that should result in - now shows -"#\"
Summary: FORMATTING / FORMULA with user defined formatting (prolly imported from Excel...
Status: RESOLVED DUPLICATE of bug 58179
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.0.0.beta2
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2013-01-05 17:25 UTC by Cor Nouws
Modified: 2016-07-12 13:39 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
xls file showing the error (8.50 KB, application/vnd.ms-excel)
2013-01-05 17:25 UTC, Cor Nouws 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Cor Nouws 2013-01-05 17:25:02 UTC 
Created attachment 72551 [details]
xls file showing the error

Spreadsheet with formula
  =C4+E4+G4+I4+K4-SUM(M4:S4)

that sould evaluate to   -  if the result in 0
or to a number, if not.
Worked fine for years, now evaluates in  -"#\"


I'll attach a sample spreadsheet.
Opening that in 3.6.4 gives the expected result.

Saving as ODS (I did it in 4.0 beta2) and then opening that ods file in 3.6.4, gives the wrong result too.
Comment 1 Cor Nouws 2013-01-05 17:25:36 UTC 
obviously a regression
Comment 2 Cor Nouws 2013-01-05 17:49:04 UTC 
Ah, there is a user defined formatting:
  #.##0,00 ;#.##0,00-;" -""#\ ";@
Comment 3 Cor Nouws 2013-01-05 17:52:05 UTC 
(In reply to comment #2)

This is how it looks in 4.0
>   #.##0,00 ;#.##0,00-;" -""#\ ";@

and this is how it looks in 3.6.4
   #.##0,00 ;#.##0,00-;" -"# "";@
Comment 4 Jean-Baptiste Faure 2013-01-06 13:15:19 UTC 
I do not reproduce with Version 4.0.0.0.beta2+ (Build ID: a31f703366b89abcb8cda1321163c596fc8e556) under Ubuntu 12.04 x86-64.
Had same problem in Writer, fixed now.

@Cor: could you test again with a recent daily build ?

Best regards. JBF
Comment 5 Cor Nouws 2013-01-06 17:43:58 UTC 
(In reply to comment #4)

> @Cor: could you test again with a recent daily build ?

No daily builds yet for Linux x86
Will come one of the next days, prolly.

thanks for reporting!
Comment 6 Jean-Baptiste Faure 2013-01-06 20:33:02 UTC 
I think this bug report is a duplicate of bug 58179. If I am right the last daily build available for Linux (2012-12-28) should contains the corresponding fix.

Best regards. JBF
Comment 7 Cor Nouws 2013-01-07 08:36:26 UTC 
yes, indeed there was one more recent daily and it's fixed in there.
thanks, Cor

*** This bug has been marked as a duplicate of bug 58179 ***