Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

excel cell names/alias are identified as loops #130

Open
dberardo-com opened this issue Feb 25, 2024 · 1 comment
Open

excel cell names/alias are identified as loops #130

dberardo-com opened this issue Feb 25, 2024 · 1 comment

Comments

@dberardo-com
Copy link

i am trying to detect and remove all loops from an excel graph, an i am using this code to achieve that:

from formulas.excel.cycle import simple_cycles
list(simple_cycles(xl_model.dsp.dmap.succ))

however, it turns out the all excel cell names are seens as loop. example in this simple sheet i have got one actual loop (C1 <-> B2) and a cell alias on A3:

image

this is the output of the code above:

image

@dberardo-com
Copy link
Author

btw on a related matter: is there any method to remove or update cells in a dsp once it has been loaded ? (in this case i would like to remove the loop for example, by removing one of the 2 cells causing it)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant