search

ODM2 / YODA-File

The YAML Observation Data Archive & exchange (YODA) File Format
BSD 3-Clause "New" or "Revised" License
4 stars 0 forks source link

Remove coding for protection in tables #58

Open SRGDamia1 opened 8 years ago

SRGDamia1 commented 8 years ago

In order to make adding lines to tables work while the tables were protected, I added several extra macros (see #18). Because we are no longer using excel itself to generate the YAML, there are many fewer formulas in the workbook. This may mean it's safe to leave the workbook unprotected ( #50 ). If we're going to do that, all of this code should be removed. It doesn't work perfectly anyway, and it crashes frequently.

This means removing the class module CFillProtectedLO and the private subs (and everything) in the "this workbook" object.

horsburgh commented 8 years ago

Now that we have simplified, I think we should unprotect things. I think 0.3.2 of the Time Series template is unprotected now. As I was testing it, I think it was adding additional lines to the table OK, but I'm not sure all of the formatting was working correctly - particularly the bold border around the table.

@SRGDamia1 - You may have had that all figured out in your original versions and I may have messed it up when I did my updates.

SRGDamia1 commented 8 years ago

I think I had all of the other formatting fixed, but I don't remember specifically about the borders. I can look into it.