Ask Your Question

bluefrog's profile - activity

2020-10-16 01:07:25 +0100 marked best answer page style with customer pg number

Hi

I've managed to figure out how to create a page style, but I'd like the page style to have page numbers such as A1, A2, A3, ... in the right footer.

The only options available when "Page numbers" are selected in the newly created style:

1,2,3

A,B,C,

I,II,II

None

etc.

But no customer option. Is there a way perhaps ?

2020-10-16 01:07:02 +0100 received badge  Famous Question (source)
2020-10-01 15:20:49 +0100 received badge  Famous Question (source)
2020-07-21 12:50:16 +0100 received badge  Notable Question (source)
2020-04-15 01:41:31 +0100 received badge  Notable Question (source)
2020-04-14 17:26:34 +0100 marked best answer need to show t = supremum of T

How to indicate supremum or infimum? In Latex it is "t= sup_{T}".

2020-04-14 17:19:11 +0100 received badge  Popular Question (source)
2020-02-20 19:42:49 +0100 received badge  Famous Question (source)
2020-02-20 19:42:49 +0100 received badge  Notable Question (source)
2020-01-05 18:11:44 +0100 received badge  Famous Question (source)
2018-04-03 22:35:42 +0100 received badge  Famous Question (source)
2018-01-19 00:53:26 +0100 received badge  Notable Question (source)
2017-10-02 16:15:46 +0100 commented question spreadsheet calc on every other cell

Thanks, yes agreed, ideally the data should be loaded into a database and normalised, but the data above is simply a ben

2017-10-02 16:14:46 +0100 commented question spreadsheet calc on every other cell

Thanks, yes agreed, ideally the data should be loaded into a database and normalised, but the data above is simply a ben

2017-09-28 17:33:03 +0100 received badge  Popular Question (source)
2017-09-28 17:19:05 +0100 received badge  Popular Question (source)
2017-09-28 16:50:58 +0100 marked best answer spreadsheet calc on every other cell

I have the following sequence of data:

     A      B   C   D   E

    435     1   B   199 
    1194    1   C   199 759
    1196    1   B   199 
    1993    1   C   199 797
    1994    1   B   199 
    2303    1   D   199 309

Column E represents the column A minus the previous row in column A. So every other cell in column is calculated. When I drag down, each cell is calculated, instead of every other cell. How can I calculate for every other cell ? Also, I would like to count the number of "B's".

2017-09-28 13:29:12 +0100 edited question spreadsheet calc on every other cell

spreadsheet calc on every other cell I have the following sequence of data: A B C D E 435 1

2017-09-28 13:29:12 +0100 received badge  Editor (source)
2017-09-28 13:28:45 +0100 asked a question spreadsheet calc on every other cell

spreadsheet calc on every other cell I have the following sequence of data: A B C D E 435 1

2017-09-24 13:26:11 +0100 received badge  Notable Question (source)
2017-09-24 12:29:43 +0100 commented answer page style with customer pg number

Thanks for reply. I have a dissertation document, "6. Appendix A" is the proposal, which has its own headings and sub-he

2017-09-24 12:29:28 +0100 commented answer page style with customer pg number

Thanks for reply. I have a dissertation document, "6. Appendix A" is the proposal, which has its own headings and sub-he

2017-09-24 12:28:01 +0100 commented answer page style with customer pg number

Thanks for reply, this worked, but my main contents shows: Introduction.....1 Main................2 2.1 xxx .........

2017-09-24 12:27:43 +0100 commented answer page style with customer pg number

Thanks for reply, this worked, but my main contents shows: 1. Introduction.....1 Main................2 2.1 xxx .....

2017-09-24 12:27:24 +0100 commented answer page style with customer pg number

Thanks for reply, this worked, but my main contents shows: 1. Introduction.....1 2. Main................2 2.1 xxx ....

2017-09-24 12:25:52 +0100 commented answer page style with customer pg number

Thanks for reply. I have a dissertation document, "6. Appendix A" is the proposal, which has its own headings and sub-he

2017-09-24 12:08:58 +0100 received badge  Notable Question (source)
2017-09-24 12:05:55 +0100 received badge  Popular Question (source)
2017-09-24 09:05:51 +0100 received badge  Popular Question (source)
2017-09-24 01:32:26 +0100 asked a question page style with customer pg number

page style with customer pg number Hi I've managed to figure out how to create a page style, but I'd like the page styl

2017-09-06 10:06:25 +0100 received badge  Popular Question (source)
2017-09-05 23:28:35 +0100 commented answer Heading numbering not following

great, many thanks.

2017-09-05 23:28:20 +0100 received badge  Supporter (source)
2017-09-05 23:28:17 +0100 marked best answer Heading numbering not following

I've just, based on my previous post , introduced Chapter numbering.

The numbering for the headings however do not follow, they appear as follows: 1. Introduction 2 Methods 1.1 Overview 1.2 Design

Headings 2, Overview & Design, should b 2.1 & 2.2 respectively. I have verified that both the Introduction and Methods are Heading 1.

Any suggestions ?

2017-09-05 19:13:10 +0100 asked a question Heading numbering not following

Heading numbering not following I've just, based on my previous post , introduced Chapter numbering. The numbering for

2017-09-05 19:05:44 +0100 marked best answer Heading numbering 1 1.1 1.1.1.1 etc etc

I am trying to get the following Heading numbering:

for Heading 1, Heading 2, Heading 3

Heading 1 Heading 1.1 Heading 1.1.1

automatically applied. I've tried the following , F11 for styles & formatting. Selecting each Heading, and selecting modify for each. Under "modify" I selected , "Outline & Numbering", then "Numbering X" , where X represents the heading number style. I then select "edit style" and the outline I want, then "apply" and "apply" But Heading 2 appears as Heading 2 under Heading 1, instead of Heading 1.1. Same applies to Heading 3 & 4.

Can anybody help ?

image description image description

2017-09-05 19:05:28 +0100 commented answer Heading numbering 1 1.1 1.1.1.1 etc etc

Got it, thanks

2017-09-05 19:05:06 +0100 answered a question Heading numbering 1 1.1 1.1.1.1 etc etc

Got it, thanks!

2017-09-05 16:36:00 +0100 asked a question Heading numbering 1 1.1 1.1.1.1 etc etc

Heading numbering 1 1.1 1.1.1.1 etc etc I am trying to get the following Heading numbering: for Heading 1, Heading 2, H

2017-09-05 16:35:42 +0100 asked a question Heading numbering 1 1.1 1.1.1.1 etc etc

Heading numbering 1 1.1 1.1.1.1 etc etc I am trying to get the following Heading numbering: for Heading 1, Heading 2, H

2017-07-29 23:44:44 +0100 commented answer if function question circular reference

thanks, moved function to H1

2017-07-29 23:43:38 +0100 marked best answer if function question circular reference

How can I specify the current cell value for a condition that evaluates to false? For example, function looks as follows

=IF(F1="null",I1, J1 )

The function exists in J1, so if F1 is null, then use the value from I1, otherwise leave J1 as is. Currently Err:522 appears in J1, since the function refers to itself.

2017-07-29 23:43:38 +0100 received badge  Scholar (source)
2017-07-29 22:53:18 +0100 edited question if function question circular reference

if function question circular reference How can I specify the current cell value for a condition that evaluates to false