Hi,
When I try to remove the empty row in Param spreadsheet, I get the following error:
Exception (Fri Jun 8 12:29:30 2018): Invalid column specification
Unhandled Base::Exception caught in GUIApplication::notify.
The error message is: Invalid column specification
This is clearly a bug. Simplified from my actual project, thx..
Version 0.17 (appimage release at github)
OS: Manjaro Linux
Spreadsheet problem
Forum rules
Be nice to others! Read the FreeCAD code of conduct!
Be nice to others! Read the FreeCAD code of conduct!
Spreadsheet problem
- Attachments
-
- SpreadsheetBug.fcstd
- (1.67 KiB) Downloaded 43 times
Re: Spreadsheet problem
please add the Help > About FreeCAD > Copy to clipboard
Alone you go faster. Together we go farther
Please mark thread [Solved]
Want to contribute back to FC? Checkout:
'good first issues' | Open TODOs and FIXMEs | How to Help FreeCAD | How to report Bugs
Please mark thread [Solved]
Want to contribute back to FC? Checkout:
'good first issues' | Open TODOs and FIXMEs | How to Help FreeCAD | How to report Bugs
Re: Spreadsheet problem
The problem is the alias "gap2". This alias name can be interpret as a simple cell address. As I do not believe that the FreeCAD-spreadsheet has that many columns. And that may be the problem, that at deleting the row, the spreadsheet tries to look for a cell in the column "gap". Renaming the alias to something without a number as last character solves the problem for me.
The spreadsheet "Gnumeric" does not allow to define an alias name "gap2". The FreeCAD spreadsheet should do the same, or improve the algorithm that checks the alias names.
Ulrich
The spreadsheet "Gnumeric" does not allow to define an alias name "gap2". The FreeCAD spreadsheet should do the same, or improve the algorithm that checks the alias names.
Ulrich
-
- Posts: 602
- Joined: Tue Jan 29, 2013 10:35 pm
Re: Spreadsheet problem
Please register this bug in the bug tracker, and reference this thread.jfcg wrote: ↑Fri Jun 08, 2018 9:31 am Hi,
When I try to remove the empty row in Param spreadsheet, I get the following error:
Exception (Fri Jun 8 12:29:30 2018): Invalid column specification
Unhandled Base::Exception caught in GUIApplication::notify.
The error message is: Invalid column specification
This is clearly a bug. Simplified from my actual project, thx..
Version 0.17 (appimage release at github)
OS: Manjaro Linux
Thanks,
Eivind
Re: Spreadsheet problem
I made a bug report: issue #3506
What will be the solution? Not to allow alias names like "gap2" or hardening the code to remove cells?
Ulrich
What will be the solution? Not to allow alias names like "gap2" or hardening the code to remove cells?
Ulrich
Re: Spreadsheet problem
I think alias names like gap2 or even w3 should be allowed. Maybe a rule like this could help:
- Cell references have to use upper case letters like A7
- Aliases have to use lower case letters
Re: Spreadsheet problem
This seems to be partly in force already, except for the code to remove cells.
This is more a question of compatibility to other spreadsheets. Libreoffice allow gap2, whereas Gnumeric and Excel do not. In Gnumeric and Excel the underline would be needed. As I wrote an importer from Excel, my life will be easyer, if it is not allowed.
Ulrich