Re: [libreoffice-users] Writer display problem in LO 6.4.6.2 on Linux Mint 20/Cinnamon V4.6.7

[Roderick Anderson]

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 page entirely. In other words, Minimize is now not a
partial screen, but it is in effect parking it off screen, where I can
maximize it again from the Writer icon on the task bar.

Ergo what is lost is the ability to reduce the window to a partial screen -
if I try, it becomes a postage stamp and my only option is to maximize it
to full screen again.


Minimize it to the postage stamp size then grab a corner and drag it up 
in size.  Might have to grab a 'corner' multiple times.


This happens to me every so often and I can't figure out what causes it.


\\||/
Rod
--


Rogier Fentener van Vlissingen 





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Writer display problem in LO 6.4.6.2 on Linux Mint 20/Cinnamon V4.6.7

[Rogier F. van Vlissingen]

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
partial screen, but it is in effect parking it off screen, where I can
maximize it again from the Writer icon on the task bar.

Ergo what is lost is the ability to reduce the window to a partial screen -
if I try, it becomes a postage stamp and my only option is to maximize it
to full screen again.

Rogier Fentener van Vlissingen 



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Suggestion: 3D spreadsheets

[Brian Barker]

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 could change the third dimension, showing the 2D 
spreadsheet of that third index.


My spreadsheet documents have this facility in that they possess 
multiple sheets. I can even select multiple sheets at once, so that 
any action can apply to corresponding cells on multiple sheets. In 
other words, I am able to select a cell range in your third dimension.


For instance let's say the third dimensions use Greek characters. 
Then by default you see the [alpha] 2D spreadsheet showing the 
numbers and letters grid at that value [alpha]. You hold Alt and 
scroll once and it changes to [beta] 2D spreadsheet. And so on.


How does this differ from multiple sheets labelled "alpha", "beta", and so on?


This could be really powerful. What do you think?


I think you should write the code.

Brian Barker  



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Question on value comand and Err:502

[Alan B]

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 format a cell as text, enter a decimal digit, e.g. 2, and point
value() at that cell it returns the number 2.

If i point cell("type",) at the cell containing digits that are
formatted as text the result is "l" (lower case L).

If I point cell("type",) at the value() formula that points at the
text formatted digits it returns v.

So, I would say that value() converts a number formatted as text to a
value, converts a formula that results in a number to a value, but will not
recognize a formula written as a text string and convert the string to
produce the value.

On Mon, Nov 23, 2020 at 11:50 PM Michael D. Setzer II 
wrote:

> Put a more complex question, and got no responses yet.
> So, here it is in simplest form
> =value(1+1)  converts the 1+1 to 2
> But =value( ) fails with Err:502 is text "1+1" is used or i a cell
> containing the text 1+1 is used??
> I've looked thru command, and this seems to be the one to convert a text
> string to a value? Is there another command, or am I doing something
> wrong?
>
> Contents of a simple spreadsheet
>
> 2   "=value(1+1)
> Err:502 "=VALUE("1+1")
> "1+1TRUE=ISTEXT(A3)
> Err:502 "=value(a3)
>
>
> ++
>  Michael D. Setzer II - Computer Science Instructor (Retired)
>  mailto:mi...@guam.net
>  mailto:msetze...@gmail.com
>  Guam - Where America's Day Begins
>  G4L Disk Imaging Project maintainer
>  http://sourceforge.net/projects/g4l/
> ++
>
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Question on value command and Err:502

[Brian Barker]

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( ) fails with Err:502 if text "1+1" is used or if a cell 
containing the text 1+1 is used??
I've looked thru command, and this seems to be the one to convert a 
text string to a value?


It is. But the text string "1+1" is not a value expressed as text but 
a numerical expression in text form. And VALUE() does not undertake 
to evaluate such expressions.



Is there another command, ...;


What you need instead is the EVALUATE() function. (PS: It doesn't exist!)

I think the fact that VALUE(1+1) entered as part of a formula does 
what it does is a lucky side effect. Clearly in this case LibreOffice 
is doing something similar to the automatic editing that is done when 
any material is entered into a spreadsheet cell. I'm talking about 
this sort of thing: when you type "+02" (no quotes) into a cell 
formatted as Number, you see just 2. The "1+1" in this case is being 
entered into a cell (as part of a formula), not arising as the result 
of some calculation.


I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Suggestion: 3D spreadsheets

[Dave Howorth]

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 mouse, you could change the third dimension, showing the 2D
> spreadsheet of that third index.
> 
> For instance let's say the third dimensions use greek characters.
> Then by default you see the "α" 2D spreadsheet showing the numbers
> and letters grid at that value "α".
> You hold Alt and scroll once and it changes to "β" 2D spreadsheet.
> And so on.
> 
> Also it would require a way to select the X and Y axis in order to
> visualize the data. So for instance you could change the X axis to
> display the greek letters dimension and show the numbers on Y axis.
> 
> This could be really powerful. What do you think? 

Maybe some examples of how it would be useful versus alternatives and
ideally some idea showing how easy to use it is?

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Question on value command and Err:502

[Dave Howorth]

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 +1000
"Michael D. Setzer II"  wrote:

> =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 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( ) fails with Err:502 if text1+1is used or if a cell
> containing the text 1+1 is used??
> I've looked thru command, and this seems to be the one to convert a
> text string to a value?
> 
> 
> It is. But the text string1+1is not a value expressed as text but
> a numerical expression in text form. And VALUE() does not undertake
> to evaluate such expressions.
> 
> 
> Is there another command, ...;
> 
> 
> What you need instead is the EVALUATE() function. (PS: It doesn't
> exist!)
> 
> 
> I think the fact that VALUE(1+1) entered as part of a formula does
> what it does is a lucky side effect. Clearly in this case LibreOffice
> is doing something similar to the automatic editing that is done when
> any material is entered into a spreadsheet cell. I'm talking about
> this sort of thing: when you type=+02(no quotes) into a cell
> formatted as Number, you see just 2. The1+1in this case is being
> entered into a cell (as part of a formula), not arising as the result
> of some calculation.
> 
> 
> As you mention, and as I found the evaluate command is what other 
> spreadsheets have that would seem to handle this, but libreoffice
> calc doesn't??
> 
> 
> Have just been playing with that GPS to Decimal problem, and was 
> trying to get a simplier process to do it.
> 
> 
> Have made a number of macros, that can do it just fine, but they have 
> long formulas. Was looking to do it with a set of regex commands.
> Commands did what I wanted, but can't get it to calculate the result..
> 
> 
> Best I've gotten So Far.
> Raw Data in column A
> 0315'090E
> Have a Macro that puts formula in column
> B=REGEX(REGEX(REGEX(REGEX(REGEX(INDIRECT(ADDRESS(ROW(),COLUMN()-1)),,+),',/60+ot;),CHAR(34),/3600),[EN],),[OSW],*(-1))
> That creates the Forumula 03+15/60+090/3600
> But value in macro fails if put around it, and using value on the
> cell, or even a cell, where the data is copied fails. So, it is not
> being seen as a formula. Seems Value only works on a string that only
> contains digits and nothing else?? And as you said. LibreOffice
> doesn't have evaluate as others do.So, macro does what I want, but no
> way I've found to automatically get it to convert to the value. I can
> do the following steps to get the result I want. After running the
> macro I can manually do the following: F2,F9,CR,HOME,=,CR
> That puts the cell in edit mode, then F9 calculates it to the text
> formula and enter, the Home to go to the beginning, insert an = to
> convert it from a text cell to an actual format, and then enter to
> get the final result as digit values.
> 
> 
> But again, LibreOffice doesn't have the keypress option to add that.
> Other methods work fine, just was trying something different.
> Just thought there would be some kind of command to do it..
> 
> 
> Additionally, it probable is a flux that value(1+1) worked, probable
> does calculation first, and then sees nothing to convert. When it see
> as string, it probable checks for non-digits, and thus fails
> automatically..
> 
> 
> Thought there might be something else. Not an issue that effects me,
> but thought it would be interesting to figure out..
> 
> 
> Have a nice day and be safe..
> 
> 
> 
> 
> I trust this helps.
> 
> Brian Barker
> 
> 
> 
> 
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more:
> https://wiki.documentfoundation.org/Netiquette List archive:
> https://listarchives.libreoffice.org/global/users/ Privacy Policy:
> https://www.documentfoundation.org/privacy
> 
> 
> 
> 


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Away around problem. Don't do it with libreoffice??

[Michael D. Setzer II]

=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 
's/^/=(/;s/\/+/;s/\x27/\/60+/;s/\x22/\/3600/;s/O\|S/\)*(-1)/;s/N\|E/)/'gps.txtgps.csv
sed -e 
's/^/(/;s/\/+/;s/\x27/\/60+/;s/\x22/\/3600/;s/O\|S/\)*(-1)/;s/N\|E/)/'gps.txtgps.raw
paste -d, gps.txt gps.csvgpsboth.csvbc -lgps.rawgps2.txt
paste -d, gps.txt gps2.txtgpsbc.csv#libreoffice --infilter=CSV:44,34,76,1 
gps.csv gpsboth.csv gpsbc.csv


To process the 1000 records time ./gps3.sh reports.


real0m0.037s
user0m0.019s
sys0m0.009s


So, less than 4 hundredth of a secondFirst sed line creates a file that just 
has the decimal version for matching line
Second sed line makes a version of the output for use as input to bc, since it 
doesn't like the leading 
= that is needed to import into libreoffice.
paste command just makes a combined version of input data, and result in 
columns A and B
bc -l takes the formula file, and actual calculates the final number, so no 
need for libreoffice to 
calculate it.
paste again combines the two files.
For time test the loading to libreoffice is commented out.


Did find an error in my earlier process thou..
In other macros, date is converted to time value so the multiply by -1 for 
values didn't need ( ).
The above adds that..


Well, a simple solution that works, and libreoffice can read the csv files 
without issue..
Also, a lot faster...


Again. Have a nice day.




-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Suggestion: 3D spreadsheets

[PaddleS]

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 spreadsheet
of that third index.

For instance let's say the third dimensions use greek characters. Then by
default you see the "α" 2D spreadsheet showing the numbers and letters grid
at that value "α".
You hold Alt and scroll once and it changes to "β" 2D spreadsheet. And so
on.

Also it would require a way to select the X and Y axis in order to visualize
the data. So for instance you could change the X axis to display the greek
letters dimension and show the numbers on Y axis.

This could be really powerful. What do you think? 



--
Sent from: 
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Question on value command and Err:502

[Michael D. Setzer II]

=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 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( ) fails with Err:502 if text1+1is used or if a cell
containing the text 1+1 is used??
I've looked thru command, and this seems to be the one to convert a
text string to a value?


It is. But the text string1+1is not a value expressed as text but
a numerical expression in text form. And VALUE() does not undertake
to evaluate such expressions.


Is there another command, ...;


What you need instead is the EVALUATE() function. (PS: It doesn't exist!)


I think the fact that VALUE(1+1) entered as part of a formula does
what it does is a lucky side effect. Clearly in this case LibreOffice
is doing something similar to the automatic editing that is done when
any material is entered into a spreadsheet cell. I'm talking about
this sort of thing: when you type=+02(no quotes) into a cell
formatted as Number, you see just 2. The1+1in this case is being
entered into a cell (as part of a formula), not arising as the result
of some calculation.


As you mention, and as I found the evaluate command is what other 
spreadsheets have that would seem to handle this, but libreoffice calc 
doesn't??


Have just been playing with that GPS to Decimal problem, and was 
trying to get a simplier process to do it.


Have made a number of macros, that can do it just fine, but they have 
long formulas. Was looking to do it with a set of regex commands.
Commands did what I wanted, but can't get it to calculate the result..


Best I've gotten So Far.
Raw Data in column A
0315'090E
Have a Macro that puts formula in column 
B=REGEX(REGEX(REGEX(REGEX(REGEX(INDIRECT(ADDRESS(ROW(),COLUMN()-1)),,+),',/60+ot;),CHAR(34),/3600),[EN],),[OSW],*(-1))
That creates the Forumula
03+15/60+090/3600
But value in macro fails if put around it, and using value on the cell, or even 
a 
cell, where the data is copied fails. So, it is not being seen as a formula. 
Seems 
Value only works on a string that only contains digits and nothing else?? And 
as 
you said. LibreOffice doesn't have evaluate as others do.So, macro does what I 
want, but no way I've found to automatically get it to 
convert to the value.
I can do the following steps to get the result I want.
After running the macro I can manually do the following:
F2,F9,CR,HOME,=,CR
That puts the cell in edit mode, then F9 calculates it to the text formula and 
enter, the Home to go to the beginning, insert an = to convert it from a text 
cell 
to an actual format, and then enter to get the final result as digit values.


But again, LibreOffice doesn't have the keypress option to add that.
Other methods work fine, just was trying something different.
Just thought there would be some kind of command to do it..


Additionally, it probable is a flux that value(1+1) worked, probable does 
calculation first, and then sees nothing to convert. When it see as string, it 
probable checks for non-digits, and thus fails automatically..


Thought there might be something else. Not an issue that effects me, but 
thought it would be interesting to figure out..


Have a nice day and be safe..




I trust this helps.

Brian Barker




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy




-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy