search

massbays-tech / MassWateR

R package for working with Massachusetts surface water quality data
https://massbays-tech.github.io/MassWateR
Creative Commons Zero v1.0 Universal
11 stars 3 forks source link

QC Report Keep with Next setting #47

Closed ben-wetherill closed 1 year ago

ben-wetherill commented 1 year ago

There is a setting in Word Paragraph - Line and Page Breaks called "Keep with next". That is turned on for many things in the QC report, which is often good, but it caused issues when I started to move things around. It forced the tables to be on a single page and created large blank pages at the beginning of the tables. I had to turn it off to format my report. I think we should turn it off inside the tables (i.e. inside the frequency and accuracy summary tables and inside the raw data tables).

fawda123 commented 1 year ago

I'll see what I can do, but I'm not optimistic as this is probably a Word setting that can't be controlled from within R.

ben-wetherill commented 1 year ago

It looks to me like the Keep with next setting is unchanged. It seems to still be defaulting to One everywhere in the QC Report.

fawda123 commented 1 year ago

Okay, you'll have to show me on our next call so I can more clearly understand the issue. I'm more optimistic this can be fixed, but will need to see the issue on your end.

ben-wetherill commented 1 year ago

I see you have already fixed the sequence of tables that we talked about yesterday. That looks great!

Here are the files for troubleshooting the Keep With Next issue. It works the same on both of my computers. The file "QCReport" is how it comes out, with Keep with Next on. The file "QCReport-KWNfixed" is how we would like it to come out.

OARS WQXMeta.xlsx OARS DQOFreqComp.xlsx OARS_QCReport.docx OARS MassWateR load 2022.xlsx OARS_QCReport-KWNfixed.docx OARS DQOAccuracy.xlsx OARS Sites.xlsx

ben-wetherill commented 1 year ago

Now the QC Report looks good. I reinstalled the package directly from Github, and I think Marcus made some updates to the template.