Fill empty cells with a particular value

[adamrp]

Improvement Description
The particular value might be user-defined, or pre-defined (e.g., NaN)

[jairideout]

👍 this would be really handy for e.g., QIIME, which doesn't support empty cells.

[jairideout]

This can be accomplished by using the search-and-replace functionality built into Google Sheets. Turn on regex mode and enter ^$, then hit "replace all" to replace all empty cells with a particular value. You can also restrict the search-and-replace by selecting only a portion of the sheet.

@adamrp does this work for your use case? If so I'll close the issue.

[adamrp]

Works for me! I would suggest putting the workaround (if it can be called
that) in the keemei documentation, even if it is already in the google docs
documentation, so that users know about it, since I do think that this will
be a common task for keemei users

On Wed, Apr 1, 2015 at 6:13 PM, Jai Ram Rideout [email protected]
wrote:

This can be accomplished by using the search-and-replace functionality
built into Google Sheets. Turn on regex mode and enter ^$, then hit
"replace all" to replace all empty cells with a particular value. You can
also restrict the search-and-replace by selecting only a portion of the
sheet.

@adamrp https://github.com/adamrp does this work for your use case? If
so I'll close the issue.

—
Reply to this email directly or view it on GitHub
https://github.com/jairideout/Keemei/issues/35#issuecomment-88672340.

[jairideout]

Good idea! I'll add some instructions to the docs.

[adamrp]

Thanks, Jai, I think this can be closed!

On Thu, Apr 2, 2015 at 8:53 AM, Jai Ram Rideout [email protected]
wrote:

Good idea! I'll add some instructions to the docs.

—
Reply to this email directly or view it on GitHub
https://github.com/jairideout/Keemei/issues/35#issuecomment-88935238.

[jairideout]

I'm going to leave it open for now until I can add the instructions to the documentation.