461 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
108
views
OpenOffice Calc.Sheet.getCellByPosition.SetValue working incorrect in x64 Delphi
I have a simple Delphi code to working with OpenOffice.Calc:
procedure TForm7.Button1Click(Sender: TObject);
Var
OO, Desktop, ooParams, Calc, Sheet : OleVariant;
i : integer;
f : real;
begin
...
-1
votes
1
answer
185
views
Adding custom shortcut for Libre-office
I wonder if there is any keyboard shortcut available for the menu bar item Data -> Text to Columns..
I looked into various online resources like the below one, however could not find anything ...
2
votes
1
answer
60
views
Flex box background color cuts off at parent container width when using calc function for flex flex-basis
Trying to extend the background of the Flex box to go beyond its immediate parent boundaries, when scrolling. However, the background gets cut off at the width of the parent container.
<div style="...
0
votes
2
answers
107
views
How to use fraction string in Excel/Calc/Sheets as formula
I am having trouble to create a proper solution for following problem.
It shall be possible to enter fractions in a excel cell, which shall be used for further calculations.
Very simplified, it should ...
0
votes
1
answer
128
views
Maintaining Consistent Visual Border-Radius for Buttons of Different Sizes Using CSS calc()
I’m currently working on a project that involves two buttons of different sizes. Both buttons are designed with the same border-radius of 6px. However, when rendered in the browser, they appear to ...
0
votes
1
answer
57
views
Use calc function in r to calculate the mean from a stacked raster [closed]
I am using a stacked raster with the following properties:
class : RasterStack
dimensions : 116, 62, 7192, 100 (nrow, ncol, ncell, nlayers)
resolution : 200, 200 (x, y)
extent : 501829.3, ...
0
votes
2
answers
250
views
Calculate a running 7-day total in LibreOffice Calc, where dates may have multiple entries
How do I write a formula that I can copy and paste into a column in a LibreOffice Calc spreadsheet so that each cell displays a running 7-day total of the values in a different column. Column A ...
1
vote
2
answers
365
views
How to use a "reverse percentage"/unitless calculation in a CSS calc()? [duplicate]
I would like to use the following calculation in the width and height of an element:
(1 / 0.65) * 100, then the % sign
So that the width & height are set to 153.85%.
However I believe the first ...
0
votes
3
answers
58
views
HTML / CSS Calc / Flexbox positioning problem
I have been trying to make a page which has 3 horizontal sections, with content in the middle section that overlaps the sections above and below it. The content in the middle section is arranged ...
2
votes
1
answer
65
views
Margin depending on screensize and variable in width
I want to create a variable margin on the left, depending on screensize.
At 1351px screenwidth, and the margin should be 12.583vw,
when the screen is 2250px wide, the margin should be 29.802vw.
How ...
1
vote
1
answer
104
views
Make a clip-path inset a square on any viewport, in JS
Hello here is a codepen that shows my problem
I'm trying to make a JS calculation that changes the clip path inset of a div so that it shows a square.
There's one constraint: the square width has to ...
1
vote
1
answer
134
views
Error with 'calc' function: not working on RasterStack/RasterLayer
I'm currently working on climatic raster files. I have oceanographic data for 3 years during the months of january and february at a daily resolution. I have a loop reading .nc files and converting ...
0
votes
1
answer
596
views
CSS Calc and Multiplication
I know there is probably an obvious answer for this but I'm stumped.
I've been trying to create custom calculations to determine the exact percentage based on the pixels of an element, example:
....
1
vote
3
answers
1k
views
libreoffice calc Macro to shift focused cell to the right by one cell
I have a cell in focus. I want to shift the focus to one cell immediately in the right using a macro.
I've tried this but to no avail...
Sub move_cursor
sheet = ThisComponent.CurrentController....
0
votes
2
answers
2k
views
LibreOffice Calc macro to copy a range from one sheet to a different location in a different sheet
Using a macro, I want to copy whatever contents are in Sheet1,B2:D5 into Sheet2,A1 as a 'header cell'. There are numerous 'flirting around the edge' pages in the web on this but I can't uncover ...