View Issue Details

IDProjectCategoryView StatusLast Update
0003013General[All Projects] Bugpublic2017-04-02 20:35
Reporterr-frankAssigned To 
PrioritynormalSeveritymajorReproducibilityalways
Status newResolutionopen 
PlatformOSWindowsOS Version7 64-bit
Product Version0.16 
Target VersionFixed in Version 
Summary0003013: Loading spreadsheet-document ignores rows >AA
DescriptionCreating spreadsheet document with information in rows bigger than AA
will save the information to disk.
But closing the document and re-opening it will ignore the rows >AA upon loading.
Steps To ReproduceSee description
Additional Informationsee discussion thread in german sub-forum
TagsNo tags attached.

Activities

Kunda1

2017-03-21 12:29

manager   ~0008861

CC @eivindkvedalen

ulrich1a

2017-03-21 20:59

reporter   ~0008862

The problem seems to be that the column address "AB" is converted in some places to "BA". This is visible, if an alias is created for a cell in this column range. The yellow color of an alias at "AB1" can be found at the cell "BA1". The same "address-conversion" can be found for aliases in the document.xml in the FreeCAD-document. But I am not a C++-programmer able to find the responsible code for this problem.

gift

2017-03-21 21:41

reporter   ~0008863

abc = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
for i in range(0,26):
    txt = abc[i] * 2
    App.ActiveDocument.Spreadsheet.set(txt+'1', txt)

App.ActiveDocument.recompute()


The same situation.

gift

2017-03-21 21:58

reporter   ~0008864

Oops. My script works fine. Sry.

ulrich1a

2017-04-02 20:35

reporter   ~0008865

Made a pullrequest to fix the issue: https://github.com/FreeCAD/FreeCAD/pull/669
2017-04-21 12:03kkremitzkiNew Issue

Issue History

Date Modified Username Field Change
2017-04-21 12:03 kkremitzki New Issue
2017-04-21 12:03 kkremitzki Note Added: 0008861
2017-04-21 12:03 kkremitzki Note Added: 0008862
2017-04-21 12:03 kkremitzki Note Added: 0008863
2017-04-21 12:03 kkremitzki Note Added: 0008864
2017-04-21 12:03 kkremitzki Note Added: 0008865