Bug 137752 - function datevalue of a cell shows date, not value of date

Bug 137752 - function datevalue of a cell shows date, not value of date


Summary:	function datevalue of a cell shows date, not value of date

Product:	calligratables
Component:	general
Status:	RESOLVED
Resolution:	FIXED
Target:	---

Version:	unspecified
Priority:	NOR
Severity:	normal

Votes:

Version Fixed In:

Description From Andreas von Rueden web de 2006-11-23 01:02:49

Version:            (using KDE KDE 3.5.5)
Installed from:    SuSE RPMs
OS:                Linux

The function datevalue, using a cell reference, does not show the datevalue 
but instead the date itself. 
Example:

A1 is 2006-03-14 
A2 is =datevalue(A1)

A2 should now show 38790, but it shows 2006-03-04. If using =datevalue("2006-03-14") the correct value is shown.

cu

Andreas

------- Comment #1 From Inge Wallin 2006-11-24 22:42:39 -------

Which version of kspread?

------- Comment #2 From Andreas von Rueden web de 2006-11-24 23:34:22 -------

kspread 1.5.1 (KDE 3.5.5 "release 19.1" openSUSE)

------- Comment #3 From Tomas Mecir 2006-11-25 09:43:03 -------

Please try with 1.6, there were many fixes in this regard.

------- Comment #4 From Andreas von Rueden web de 2006-12-01 00:23:23 -------

tried with 1.6.1, same problem

------- Comment #5 From Sebastian Sauer 2006-12-03 12:06:05 -------

Fix got committed to the 1.6-branch (r610048) and trunk (610049). We behave now
like OOo Calc does (accepting only text as input). A lot of thanks for the
feedback, Andreas!

------- Comment #6 From Andreas von Rueden web de 2007-06-28 21:22:59 -------

Tried it with 1.6.3 (KDE 3.5.5 "release 19.1" openSUSE), same problem.

------- Comment #7 From Stefan Nikolaus 2007-08-18 11:24:56 -------

Fixed in the upcoming 2.x series.

Platform:	openSUSE RPMs
OS:	Linux
Keywords:
URL:

People

Reporter:	Andreas von Rueden web de
Assigned To:	Calligra Tables (KSpread) Bugs

Related actions

View Bug Activity

Format For Printing

Clone This Bug

Search for Duplicates

Note

You need to log in before you can comment on or make changes to this bug.

Attachments
Add an attachment (proposed patch, testcase, etc.)

Depends on:
Blocks:
	Show dependency tree - Show dependency graph

Actions

Reports

My Account