83243 – FORMATTING: can not recognize cell format automatically. Worse and worse. : ( I´m thinking back to MS office.

Bug 83243 - FORMATTING: can not recognize cell format automatically. Worse and worse. : ( I´m thinking back to MS office.

Summary: FORMATTING: can not recognize cell format automatically. Worse and worse. : (...

Status:	RESOLVED WORKSFORME

Alias:	None

Product:	LibreOffice
Classification:	Unclassified
Component:	Calc (show other bugs)
Version: (earliest affected)	4.3.1.1 rc
Hardware:	Other Windows (All)

Importance:	medium normal
Assignee:	Not Assigned

URL:
Whiteboard:	BSA
Keywords:

Depends on:
Blocks:

Reported:	2014-08-29 12:05 UTC by bonbon
Modified:	2014-08-30 09:09 UTC (History)
CC List:	2 users (show)

See Also:
Crash report or crash signature:

Attachments
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 bonbon 2014-08-29 12:05:31 UTC

Problem description: cells with functions can not be calculated correctly.

Cell A1:=LEFT(Z12;2)................................value is 03
Cell B1:=VLOOKUP(RIGHT(Z12;3);$AG$12:$AH$23;2;).....value is 01

so,in Cell C1:=IF(B1<A1;"yes";"no")

Then, in cell C1 shows "no". it shoud be "yes".

I´m crying now, my god. We are forced to use MS office????
Operating System: Windows 8
Version: 4.3.1.1 rc

Comment 1 bonbon 2014-08-29 12:07:04 UTC

Version 4.3.1.2

Comment 2 Mikko Ahlroth 2014-08-29 13:09:48 UTC

Cannot confirm on LO 4.2.4.2, Ubuntu 14.04.

What values do you have in Z12, AG12 and AH23? They are required to really test your situation. Even better if you can attach the document you're having problems with.

Also, no need to be so dramatic. All software has bugs.

Comment 3 tommy27 2014-08-29 14:08:00 UTC

moreover the 4.3.1.2 release is still not ready for production use.
it's better to stick to LibO 4.2.6.2 

@Kevin 
can you retest your bug report with that more stable version?

Comment 4 bonbon 2014-08-29 17:00:26 UTC

I JUST CLOSE IT AND OPEN IT AGAIN, NOW IT´S OK. I CAN´T FIGURE IT OUT. 
I UNDERSTAND SOFTWARES HAVE BUGS, I LIKE LO VERY MUCH, BUT I DO NOT AGREE ANY BASIC ERROR SHOULD EXIST IN THIS GREAT SOFTWARE.

Comment 5 Adolfo Jayme Barrientos 2014-08-30 09:09:14 UTC

Thanks for your feedback, Kevin. In case you are able to reproduce a bug consistently, please provide the steps we should follow to reproduce and test it ourselves. We’ll be glad to help you out.