bugPSPP - Bugs: bug #61110, wrong copy of numbers from ods to...


bug #61110: wrong copy of numbers from ods to pspp

Submitter:  elias tsolis <estatistics>
Submitted:  Sat 04 Sep 2021 02:14:19 PM UTC
Category:  Sheet Severity:  5 - Average
Status:  Cannot Reproduce Assigned to:  None
Open/Closed:  Open Release:  None
Effort:  0.00
* Mandatory Fields

Add a New Comment Rich Markup

Thu 06 Jan 2022 10:32:35 PM UTC, comment #1: 

I could not reproduce this on MacOS with 1.5.3. Your ods sheet has the decimal point but my german locale has the ",". If i copy a number like "21.44" then this results in an empty cell in pspp. When I create a new ods sheet with "," and then copy a number like "21,44", then it works. Pasting into pspp has two modes.

a) Just select a cell with one click. Then it works
b) Double click a cell -> This enters the edit mode of the cell and you can type something. If you paste now, then it pastes the number as a string with a trailing space. This results also in an empty pspp cell if you do not remove the trailing space.

c) It even works with copy paste of a whole range of cells e.g. copy 2 x 2 cell range in ods resuts in a correct paste in pspp.

Could you check if the decimal point is the same in pspp and libreoffice?

Friedrich Beckmann <beckmanf>
Group Member
Sat 04 Sep 2021 02:14:19 PM UTC, original submission:  

Steps to reproduce:

1) Create an empty data sheet in pspp in gui.
2) Create the named vars in pspp with empty data
3) Try to copy ods values into pspp

4) Even numbers with decimals are copied without decimals
(if you succeed to copy any number at all).

Elias Tsolis

elias tsolis <estatistics>


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

Attach Files:

Attached Files
file #51865:  data_bug.ods added by estatistics (14KiB - application/vnd.oasis.opendocument.spreadsheet - pspp SEVERE copy bug)


Depends on the following items: None found

Items that depend on this one: None found


Carbon-Copy List
  • -email is unavailable- added by beckmanf (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
    2022-01-06 beckmanf StatusNone Cannot Reproduce
    2021-09-04 estatistics Attached File- Added data_bug.ods, #51865

    Back to the top

    Powered by Savane 3.13-9c15.
    Corresponding source code