bugPSPP - Bugs: bug #63443, var names are not imported right...

 
 

bug #63443: var names are not imported right from ods | make numering vars as strings - no auto way to change them in bulk.

Submitter:  elias tsolis <estatistics>
Submitted:  Tue 29 Nov 2022 04:01:34 PM UTC
   
 
Category:  System/Portable File I/O Severity:  5 - Average
Status:  None Assigned to:  None
Open/Closed:  Open Release:  None
Effort:  0.00
* Mandatory Fields

Add a New Comment Rich Markup
   

Sun 25 Feb 2024 07:50:23 PM UTC, comment #5: 

That makes sense. The tests always run with LANG=C.

I was working on this bug, but it sent me down a deep, unpleasant rabbit hole in XML parsing libraries and I didn't want to deal with it.  I'll definitely check back again later.

Ben Pfaff <blp>
Group administrator
Sun 25 Feb 2024 07:44:39 PM UTC, comment #4: 

comment #3:

> > Can this bug be closed now?
>
> No, b) isn't fixed and I'm working on it.


I think I have the same issue. I cannot even pass test for bug #61078 (see ./tests/data/spreadsheet-test.at file). I've got this as a result of a "list" command:

-----
Table: Data List
s2,s3,s4,s5,s6,s7,s6_A,s7_A,s8,s9
"31,00","5,00","1,00","1,00","4,00","5,00","4,00","5,00","5,00","4,00"
"38,00","1,00",",00","2,00","5,00","5,00","4,00","4,00","5,00","4,00"
"24,00","1,00",",00","3,00","5,00","5,00","4,00","4,00","5,00","3,00"
"49,00","5,00","2,00","3,00","4,00","5,00","4,00","5,00","5,00","5,00"
"30,00","1,00",",00","2,00","5,00","5,00","5,00","5,00","5,00","5,00"
"33,00","5,00","2,00","2,00","5,00","5,00","5,00","5,00","5,00","5,00"
"32,00","1,00","23,00","2,00","4,00","5,00","3,00","4,00","4,00","3,00"
-----

However I found that forcing LANG=C or LC_NUMERIC=C fixes that.

For the record here are my LC vars:

-----
declare -x LANG="ru_RU.UTF-8"
declare -x LC_MEASUREMENT="ru_RU.UTF-8"
declare -x LC_MONETARY="ru_RU.UTF-8"
declare -x LC_NUMERIC="ru_RU.UTF-8"
declare -x LC_PAPER="ru_RU.UTF-8"
declare -x LC_TIME="ru_RU.UTF-8"
-----

I guess it's the same story with other non-English locales.

Peter Lemenkov <peter_lemenkov>
Wed 21 Jun 2023 05:07:40 AM UTC, comment #3: 


> Can this bug be closed now?


No, b) isn't fixed and I'm working on it.

Ben Pfaff <blp>
Group administrator
Wed 21 Jun 2023 04:41:22 AM UTC, comment #2: 

Can this bug be closed now?

John Darrington <jmd>
Group administrator
Tue 30 May 2023 12:51:00 AM UTC, comment #1: 

I fixed the problem with the names being cut off just now with commit 6462038a0664 ("ods-reader: Support more than a single piece of text in a cell.").

Ben Pfaff <blp>
Group administrator
Tue 29 Nov 2022 04:01:34 PM UTC, original submission:  

var names are not imported right from ods | make numering vars as strings - no auto way to change them in bulk.


I imported the following ods file by running:

GET DATA /TYPE=ODS
   /FILE="/pspp_bug.ods"
   /SHEET=INDEX 1
   /CELLRANGE=FULL
   /READNAMES=on.

Then:
a) Some variable names are not imported right (their names are severily cut, even thought they do not exceed length of letter word),
  
b) Many vars are imported as string while they are clearly numerics

c) No auto way to change these string vars back to numeric (as well to define all decimals to "2")


elias tsolis <estatistics>

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach Files:
   
   
Comment:
   

Attached Files
file #54037:  pspp_bug.ods added by estatistics (27KiB - application/vnd.oasis.opendocument.spreadsheet)

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by peter_lemenkov (Posted a comment)
  • -email is unavailable- added by jmd (Posted a comment)
  • -email is unavailable- added by blp (Posted a comment)
  • -email is unavailable- added by estatistics (Submitted the item)
  •  

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

    Only logged-in users can vote.

     

    Follow 2 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2023-05-30 blp CategorySyntax Parser System/Portable File I/O
    2022-11-29 estatistics Attached File- Added pspp_bug.ods, #54037

    Back to the top

    Powered by Savane 3.13-02a9.
    Corresponding source code