View Issue Details

IDProjectCategoryView StatusLast Update
0003015General[All Projects] Bugpublic2017-04-02 20:35
Reporterr-frankAssigned To 
Status newResolutionopen 
PlatformOSWindowsOS Version7 64-bit
Product Version0.16 
Target VersionFixed in Version 
Summary0003015: 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.



2017-03-21 12:29

manager   ~0008866

CC @eivindkvedalen


2017-03-21 20:59

reporter   ~0008867

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.


2017-03-21 21:41

reporter   ~0008868

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


The same situation.


2017-03-21 21:58

reporter   ~0008869

Oops. My script works fine. Sry.


2017-04-02 20:35

reporter   ~0008870

Made a pullrequest to fix the issue:
2017-04-21 12:04kkremitzkiNew Issue

Issue History

Date Modified Username Field Change
2017-04-21 12:04 kkremitzki New Issue
2017-04-21 12:04 kkremitzki Note Added: 0008866
2017-04-21 12:04 kkremitzki Note Added: 0008867
2017-04-21 12:04 kkremitzki Note Added: 0008868
2017-04-21 12:04 kkremitzki Note Added: 0008869
2017-04-21 12:04 kkremitzki Note Added: 0008870