Pergunte aqui

Perfil de EarlEMelton - atividade

2019-03-11 16:45:27 +0200 Medalha recebida  Pergunta famosa (fonte)
2018-12-07 00:35:36 +0200 Medalha recebida  Pergunta famosa (fonte)
2018-12-07 00:35:36 +0200 Medalha recebida  Pergunta notável (fonte)
2016-11-26 12:03:42 +0200 Medalha recebida  Pergunta popular (fonte)
2016-11-19 03:48:48 +0200 Respondeu uma pergunta Need help with conditional, calculating formulas

Mark, All appears to be solved at this time. I was royally screwing things up by only applying your suggestions to the current November sheet. Of course the November sheet drew much of its info from October and so on. Long story short? I applied the format code and your formula to the September, October AND November sheets and everything is just like I want it. So what am I trying to say here? YOU DA MAN!

You are welcome to remove all uploaded WBs and I'll close the question. If I can find how to do so. :-)

2016-11-18 03:54:44 +0200 Medalha recebida  Pergunta notável (fonte)
2016-11-18 01:15:45 +0200 Resposta comentada Need help with conditional, calculating formulas

A thought: Should I have pasted the format statement one at a time in each cell, rather than selecting all the calculated cells and doing so only once? I'm afraid to try anything and mess it up further but can certainly take the time to do them individually if you say that would work better. Just let me know.

2016-11-18 01:10:50 +0200 Respondeu uma pergunta Need help with conditional, calculating formulas

Okay, Mark_T, I see the pencil now so will attach the file. Yes, I copy/pasted your formulas, filled down, then selected all the pertinent cells, went to Format Cells and pasted the format statement. I may not be doing it right as I still see the zeros. When I go back from there to the Format Cells thing again, that format statement has changed!!! Note that I also finished taking out all the sensitive data...I think! :-) Appreciate your help so much. Here 'tis: 07_Properties_2016_NSI.ods

2016-11-18 00:54:45 +0200 Medalha recebida  Entusiasta
2016-11-17 15:54:44 +0200 Resposta comentada Need help with conditional, calculating formulas

Mark_T, Ok, I have the modified file ready to upload but there is no Edit button above on the original post, only Flag, Close, and Delete. Am I going to have to close this one and start a new one again? I can sure do that, but it seems like there ought to be an easier way.

2016-11-17 07:28:00 +0200 Medalha recebida  Pergunta popular (fonte)
2016-11-17 03:01:33 +0200 Resposta comentada Need help with conditional, calculating formulas

Thanks loads! I'll be looking into this more tomorrow or Friday. Can soomebody delete the upload since I goofed and left data in it that I shouldn't have?

2016-11-17 02:59:35 +0200 Pergunta comentada Need help with conditional, calculating formulas

Shoot, I forgot all about those! Was primarily concerned with the main YTD Summary. Thanks for letting me know.

2016-11-16 17:18:29 +0200 Pergunta comentada Need help with conditional, calculating formulas

At least I've learned how to post a problem and attach a file much faster!

2016-11-16 17:08:48 +0200 Perguntou Need help with conditional, calculating formulas

I'm attaching a workbook with which I need help from someone more familiar with somewhat advanced formulas. I can usually hold my own with simpler math functions, but these might be called conditional formulas, for lack of a better term. A textbox on the first of two pages hopefully explains what's needed. All sensitive, identifying information has been removed. If you prefer to just give me the formulas needed and the cell ref into which they need to go, I can copy/paste, then fill down. Many TIA for any help!

Edit: Mark_T updated uploaded file from @EarlEMelton with personal data removed.

07_Properties_2016_NSI.ods

Okay, Mark_T, I see the pencil now so will attach the file. Yes, I copy/pasted your formulas, filled down, then selected all the pertinent cells, went to Format Cells and pasted the format statement. I may not be doing it right as I still see the zeros. When I go back from there to the Format Cells thing again, that format statement has changed!!! Note that I also finished taking out all the sensitive data...I think! :-) Appreciate your help so much.

A thought: Should I have pasted the format statement one at a time in each cell, rather than selecting all the calculated cells and doing so only once? I'm afraid to try anything and mess it up further but can certainly take the time to do them individually if you say that would work better. Just let me know.

2016-11-11 17:55:52 +0200 Medalha recebida  Pergunta popular (fonte)
2016-11-07 02:53:04 +0200 Resposta comentada Can I print a Calc footer on each page? Currently only prints on first page.

Wow! I had seen that check box but not the word 'page,' only 'Same content left/right.' I didn't [want] the same content left and right. I wanted different content in the left, center, and right sections. After seeing your reply and checking the box anyway, it now displays the same footer, but on both pagea, exactly what I was wanting all along. 'Same content left/right' makes no sense whatsoever to me and seems totally misleading, but checking it worked. Gotta remember this one! Many thanks!

2016-11-06 23:58:15 +0200 Perguntou Can I print a Calc footer on each page? Currently only prints on first page.

Could never find out how to attach a sample file to the original post and can't even find that one now, so starting a new one. I have removed all sensitive data and am not overly concerned about the "#VALUE!"s that showed up after removing some other formulas and said data. Do need to learn how to print the footer on successive pages, though. Another (m.a.riosv) suggested uploading this so s/he can let me know where I'm going wrong. TIA for any help from anybody! 07_Properties_2016_NoData.ods

2016-11-06 14:23:41 +0200 Medalha recebida  Pergunta notável (fonte)
2016-11-06 03:59:17 +0200 Pergunta comentada Can I print a Calc footer on each page? Currently only prints on first page.

When I "Add a comment," that "attach" pencil is nowhere to be found. It's missing from this comment window now. Help please.

2016-11-06 03:55:23 +0200 Pergunta comentada Can I print a Calc footer on each page? Currently only prints on first page.

But when I go back to the original question I don't see where or how to upload the file I have ready or even to edit that question and upload. I seem to keep going in circles here. I consider myself reasonably computer literate and have helped a lot of people in the past. Perhaps my 73 years of "maturity" has something to do with it. Can I just "close" this one and start a new one with the same subject? Hopefully, if I do that, the missing pencil icon where I can attach the file will be there.

2016-11-06 02:19:40 +0200 Medalha recebida  Estudante (fonte)
2016-11-06 01:55:22 +0200 Perguntou How can I make a footer print on each page?

Thanks, m.a.riosv

I looked back at the page where I originally asked the question and, sure enough, there is an option to attach a file. So I've deleted all names and address, etc., and am trying to attach the workbook. I keep getting a popup that says ">3 points required to upload files."

What the heck 'points' are we talking about?

I tried making a numbered list of these paragraphs, but that didn't help.

No idea where to go from here.

Thanks for any help you can offer on getting the monthly sheets to print the footer on each page.

2016-11-04 18:24:42 +0200 Pergunta comentada Can I print a Calc footer on each page? Currently only prints on first page.

I can surely share one if you'll tell me how to do so. :-) Will I be uploading it here, e-mailing it to you, or something else? The main reason I'd like to be able to do it is that, although this is only a two-page sheet, either it or a future one could grow to several. The center section is Page # of ## (pages), which is kind of worthless unless it can be printed on additional pages.

2016-11-04 18:11:35 +0200 Medalha recebida  Pergunta popular (fonte)
2016-11-03 17:12:48 +0200 Perguntou Can I print a Calc footer on each page? Currently only prints on first page.

Two-page sheet only prints footer on page 1.

2016-11-01 18:41:48 +0200 Perguntou Insert > Headers and Footers grayed out, can't select

• Using LibO v5.2.2.2 Calc under Windoze 7, 64-bit PC w/GB of RAM. • Workbook has three tabs, currently only two months and one tab is for a YTD summary. • No tab will allow me to create either a header or footer.

Will gladly give any other info requested but don't know what else to offer at this time.

2016-03-06 17:07:55 +0200 Medalha recebida  Pergunta famosa (fonte)
2015-03-09 18:05:27 +0200 Medalha recebida  Pergunta notável (fonte)
2014-11-24 01:44:33 +0200 Medalha recebida  Pergunta popular (fonte)
2014-11-24 00:09:56 +0200 Perguntou Searchable text boxes

I'm using 3.5.7.5 on Linux Mint 13. Is there an equivalent of M$-Word's text box in Writer and Calc? I've been using the Rectangle button on the Drawing toolbar, but text inside it is not searchable. Another annoyance is that sometimes the rectangles will dislodge (if that's the right term) and appear at the top of page 1. In other words, they appear to lose their anchoring to where I originally placed them in the document. Help?

2014-09-14 15:24:50 +0200 Medalha recebida  Pergunta famosa (fonte)
2014-03-13 18:44:21 +0200 Medalha recebida  Pergunta notável (fonte)
2014-03-11 01:29:23 +0200 Medalha recebida  Pergunta popular (fonte)
2014-03-10 03:49:43 +0200 Medalha recebida  Editor (fonte)
2014-03-10 03:45:12 +0200 Perguntou Max recommended file size or page count in Writer

Is there a recommended maximum file size or page count in Writer?

I have two songbooks (lyrics only), one Country and the other Gospel. As you might guess, a considerable amount of time has gone into these. The Gospel book is pushing 400 pages (397, to be exact) and current file size is 200K. The Country book is smaller at 135K and 275 pages. Each book contains an alphabetical index, in case that would make any difference. Am I asking for unexpected problems/file corruption/whatever, or is there perhaps no recommended maximum size?

I should add that I am not currently experiencing any problems, but would just like to know if a risk exists or if there is a recommendation for avoiding any possible upcoming 'gotchas.'