Haven't found documentation to confirm but I believe your first example
=value(1+1) is recognized as a formula, the formula is processed and the
result converted to a value.
It works for me if I enter =value(sum(1,1)) the cell displays 2 and
=CELL("type",), pointed at that cell, displays v
If I
At 07:45 24/11/2020 -0700, Pierre Louis Boyer wrote:
Something new an that would be really great is to add implementation
for 3 (and potentially more) dimensional spreadsheets. What it would
look like :
Basically the same as a 2D spreadsheet. But by holding Alt+scrolling
with the mouse, you
On Tue, 24 Nov 2020 07:45:52 -0700 (MST)
PaddleS wrote:
> Something new an that would be really great is to add implementation
> for 3 (and potentially more) dimensional spreadsheets.
> What it would look like :
> Basically the same as a 2D spreadsheet. But by holding Alt+scrolling
> with the
You'd probably get more help if you made your emails understandable!
Below is what I see from you ...
(with some > quote marks on the left hand side)
I can't even tell what you wrote in addition to what Brian wrote, let
alone begin to interpret what you're asking.
On Wed, 25 Nov 2020 00:02:04
=Wanted to see if it could be done outside libreoffice calc, since it doesn't
want to work.
Since I don't have the original user info, I created a file with 1000
randomly created data elements.
Created a bash script using sed to do the same processing.
Shell script gps3.sh
sed -e
At 14:48 24/11/2020 +1000, Michael D. Setzer II wrote:
Put a more complex question, and got no responses yet.
You have to admit that your description and layout were pretty foggy!
Did anyone understand it?
So, here it is in simplest form
=value(1+1) converts the 1+1 to 2
But =value( )
=On 24 Nov 2020 at 13:05, Brian Barker wrote:
Date sent:60;Tue, 24 Nov 2020 13:05:46 +
To:;=users@global.libreoffice.org
From:60;Brian Barker;b.m.bar...@btinternet.com
Subject:;Re: [libreoffice-users] Question on value command
and Err:502
At 14:48 24/11/2020 +1000, Michael D. Setzer II
Something new an that would be really great is to add implementation for 3
(and potentially more) dimensional spreadsheets.
What it would look like :
Basically the same as a 2D spreadsheet. But by holding Alt+scrolling with
the mouse, you could change the third dimension, showing the 2D
This problem happens in Writer, but not in Calc, so it is limited to the
module.
I must have done something, for this suddenly started happening.
I can display a page either full screen, or minimize it completely, so it
disappears off the page entirely. In other words, Minimize is now not a
On 11/24/20 2:54 PM, Rogier F. van Vlissingen wrote:
This problem happens in Writer, but not in Calc, so it is limited to the
module.
I must have done something, for this suddenly started happening.
I can display a page either full screen, or minimize it completely, so it
disappears off the
10 matches
Mail list logo