python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - calc

LibreOffice Calc: How to use a variable in a function/formula?

Before After I'm trying to dynamically fill a range of cells in a column based on a number in another cell. So, fill x amount of cells with a value set in, say, E4. x is the value in cell E5. If cell...
test-img

Rylan

libreoffice

libreoffice-calc

calc

Votes: 0

Answers: 1

Latest Answer

To get the result shown in the images, enter =IF(ROW(D1)<=E$1;"Layer " & ROW(D1);"") in cell D3 and fill down to D10 by dragging the dark dot in the corner. Then change the ...
test-img

Jim K

libreoffice calc graph | scale in relation to each row of data

I have a list of data by year with expenses for each topic, eg. 2014 2015 ... expenses 1 12 14 exp. 2 321 339 exp. 3 43'334 42'991 As the different rows do...
test-img

user30424

graph

scale

libreoffice

calc

Votes: 0

Answers: 1

Latest Answer

Use a column that calculates the averages of each row. Use columns that calculate the relative value of each expense, for example in percent, in relation to the average of its row. Use these relative...
test-img

the busybee

Stepwise calculation based on window width in CSS

I need to make a calculation that every 100px of window width + 2% css increased in the left %: Examples: width > 700px: left: 30% width > 800px: left: 32% How I can do this?
test-img

Lazarus

css

sass

calc

Votes: 0

Answers: 1

Latest Answer

It's not currently possible to write a single CSS ruleset that increments a property stepwise every 100 pixels of window width in all major browsers. You'll need to write a separate media query for ea...
test-img

Sean

How do I get SUM by date without losing a calculation that relies on summing instance

CODE: SELECT occurred_at, SUM(CASE WHEN activity_name = 'create' THEN 1 ELSE 0 END) AS has_create, SUM(CASE WHEN activity_name = 'Resolve' THEN 1 ELSE 0 END) AS has_resolve FROM Activ...
test-img

DataYes

sql

sum

calc

Votes: 0

Answers: 1

Latest Answer

Something like this: WITH dat AS ( SELECT occurred_at, SUM(CASE WHEN activity_name = 'create' THEN 1 ELSE 0 END) AS has_create, SUM(CASE WHEN activity_name = 'Resolve' THEN 1 ELSE 0 EN...
test-img

FlexYourData

Posts

Questions

Blogs

Jobs