Repository navigation
Spaces in Sheet Names cause failures #18
Description
A new comment on the post "Help" is waiting for your approval
https://opensolver.org/help/
Author: Pietro Garmatter (IP address: 2001:1284:f01c:18d0:8da:187d:8b95:3119, 2001:1284:f01c:18d0:8da:187d:8b95:3119)
Email: pietrogarmatter@hotmail.com
URL:
Comment:
I am using OpenSolver with google sheets.
I works very well. However, if the cell name contains spaces, the solver tab doesn't update cell references correctly.
example: my first sheet was called 'ex1 - p1', second 'ex1 - p2' and so on. When trying to update variables, objetive etc for the second sheet, nothing happened. I went back to the first and ran its solver again. It worked OK, because references weren't lost.
Tried updating values from the first sheet (now renamed with the spaces) and it didn't work.
I did, however, manage to use it by renaming sheets from 'ex1 - p1' to 'e1p1'.
Approve it: https://opensolver.org/opensolverwordpress2/wp-admin/comment.php?action=approve&c=546348#wpbody-content
Trash it: https://opensolver.org/opensolverwordpress2/wp-admin/comment.php?action=trash&c=546348#wpbody-content
Spam it: https://opensolver.org/opensolverwordpress2/wp-admin/comment.php?action=spam&c=546348#wpbody-content
Currently 162 comments are waiting for approval. Please visit the moderation panel:
https://opensolver.org/opensolverwordpress2/wp-admin/edit-comments.php?comment_status=moderated#wpbody-content
Activity
LabJared commentedon Nov 20, 2022
This issue is not with spaces in sheet names, specifically the issue comes from where the sheet name contains a segment of the form "x-{}" where:
x is a number, and {} is a string containing a letter, number, underscore or question mark. (Note may apply for other non-alphanumeric characters but the ones listed are the only ones I found through my testing).
Edit: If the tailing string (the section denoted by {}) contains only letters, the solver will still work provided there are no letters before the number denoted by x. Also updating the fact that the space between the x and - is not actually required for the bug to occur.