openmolecules.org

 
Home » DataWarrior » Functionality » LLE column doesn't update with new compound data
LLE column doesn't update with new compound data [message #92] Wed, 12 August 2015 02:46 Go to next message
mvamos is currently offline  mvamos
Messages: 24
Registered: January 2015
Location: US
Junior Member
The LLE calculation column didn't update for me when I added new data. I merged in new IC50 data on which the LLE calculation is based. The structures for the compounds were already present and I merged the .csv file containing the IC50 data.

If I go again through Chemistry>Add Compound Properties>LE & Tox>LLE to add a new column (now appended with a 2 at the end because it's a duplicate of the previous), the values for the new data populate correctly.

In the attached photo, you can see the original LLE column on the left, and the 2nd LLE on the right.

Perhaps this is a small bug?
  • Attachment: Untitled.png
    (Size: 16.41KB, Downloaded 947 times)
Re: LLE column doesn't update with new compound data [message #95 is a reply to message #92] Fri, 14 August 2015 07:41 Go to previous messageGo to next message
thomas is currently offline  thomas
Messages: 646
Registered: June 2014
Senior Member
this is the expected behaviour. The LLE calculation is a one time matter. There is no mechanism that would update LLE values when the original IC50 is updated or when new IC50 values are appended. After appending new rows you could remove the then incomplete LLE column and calculate a new one. If you do this often, you could create a macro for that. Regards, Thomas
Re: LLE column doesn't update with new compound data [message #276 is a reply to message #95] Tue, 30 May 2017 01:49 Go to previous messageGo to next message
Christoph is currently offline  Christoph
Messages: 9
Registered: May 2017
Junior Member
Hi everyone,

I had similar issues. I added more molecules and was wondering why the SMILES-structure column doesn't automatically update and add the SMILES for my new molecule. It would be nice to have an "update" option for the columns which DataWarrior once filled in.

Only a suggestion... Smile

Best wishes,
Christoph
Re: LLE column doesn't update with new compound data [message #282 is a reply to message #276] Fri, 02 June 2017 22:41 Go to previous messageGo to next message
thomas is currently offline  thomas
Messages: 646
Registered: June 2014
Senior Member
Hi Christoph,

DataWarrior has no mechanism to automatically update cell content that was originally derived from other cell content. If I started that, this could get easily very complex and chaotic, because editing a structure might then change computed properties, which in turn could trigger changes on derived columns. SAR tables, chemical space plots, SOMs, custering results, ..., would all require an automatic update after adding or changing some rows. To be consistent I would need to update everything and not just SMILES columns. DataWarrior would then be another program. For some time I thought about giving individual columns an 'automatic update' status, but even that would have lots of consequences. Finally, I dropped the idea. Again I suggest to create a small macro deleting the SMILES column and re-creating it.

Hope you can live without it.

Best wishes, Thomas
Re: LLE column doesn't update with new compound data [message #286 is a reply to message #282] Mon, 05 June 2017 17:18 Go to previous message
Christoph is currently offline  Christoph
Messages: 9
Registered: May 2017
Junior Member
Hi Thomas,

Thank you very much for letting us know more about the background.

Since there is a workaround on this issue I can live with the current version of course.

Because it would however be a very nice feature if all 'derived' columns could be updated automatically, maybe this idea would be something for the list of features for the next major version of the program at some time in the future.

Best wishes,
Christoph

Previous Topic: Rendering structures from SMILES
Next Topic: Option to freeze columns and rows.
Goto Forum:
  


Current Time: Thu Mar 28 18:24:32 CET 2024

Total time taken to generate the page: 0.08270 seconds