Issue 27080 - sqlite query designer calculation treated as text
Summary: sqlite query designer calculation treated as text
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: marc.neumann
QA Contact: issues@sc
URL:
Keywords:
Depends on: 27099
Blocks:
  Show dependency tree
 
Reported: 2004-03-29 15:26 UTC by kelvine
Modified: 2004-04-15 07:31 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

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

Note You need to log in before you can comment on or make changes to this issue.
Description kelvine 2004-03-29 15:26:53 UTC 
Hi,

Using SQLite as a data source with the ODBC driver, I create a column which 
multiplies a column which contains a number by 2.

The result in the query looks fine.

When the query is dragged onto the spreadsheet all the columns are correct 
except the calculated column. This column becomes a text column with the 
single quote before the number.

It could be something that I am doing wrong as I just started experimenting 
with sqlite. 

I just thought I should let you know.

Issue 27072 contains an sqlite file should you wish to test this.

Kevlin
Comment 1 frank 2004-03-31 10:38:53 UTC 
Hi Marc,

as discussed please have a look at this one too. It's related to Issue 27072.

Frank
Comment 2 marc.neumann 2004-04-05 15:51:27 UTC 
Hi,

I can't use sqllite anyway, because it crash all the time. So I onyl can test
this if issue 27099 is fixed.

Bye Marc
Comment 3 kelvine 2004-04-15 05:29:53 UTC 
Hi,

I have just retested this with the new ODBC driver as announced in the dba 
list by Alex Thurgood. 

This problem no longer exists for me.

Please close.

By the way the ability to change the status for an issue by the originator 
appears to have been removed. Is there still a way for me to indicate the 
issue can be closed. I previously used to add WORKSFORME when an issue had 
been fixed as a result of say a new release.

Kelvin
Comment 4 frank 2004-04-15 07:30:51 UTC 
Hi,

so I close this one as WFM.

Regarding the changing of Issues by the reporter, please use the query
functionality, as far as I remember an Issue regarding such problems exist.

Frank
Comment 5 frank 2004-04-15 07:31:27 UTC 
closed wfm on submitters request