[libreoffice-users] Need help and don't know where to even start.

[JL]

Good evening all,

I've found myself in a position where I need to drop serious weight for
health reasons.  I have a diet that works (more a complete change of
eating) but I need help in the planning of it.  I have used Libre Office
(and OOo before that) for years, but only for basic word processing and
*light* slideshow presentations.

I switched to the Eat to Live lifestyle last year and never felt better.
The problem is, I found myself eating out a lot (take away salads and
soups) to comply with the diet.  When I bought the stuff myself I either
bought to much, or not enough.  Eventually I caved into just eating what
was available.

Now that you know the backstory, what I'm trying to accomplish is this.

1. I need, using Calc, to create a calender view of the current month.

2. On each day, I need there to be about 5 dropdown menus, populated
with menu choices.

3. Once all of the week is put in (due to a lot of fresh vegetables
being in, it could be every 3 days. I'm flexible.) I need the program to
spit out a shopping list

Simplification of the above:  Throughout a week, I put in some meals
that have 1/2 a cup of spinach here, 2 cups there, ect. I need the
program to spit out total cups at the end of the week. (as an added
bonus, if I can put in that X cups ='s Y lbs of a given item so that I
get weight, even better)

In regards to the above simplification, I don't just need it for
spinach. It's going to giving me a weekly shopping list of every
component in every recipe.

I hope this isn't too long winded, but I'm at my wits end just sitting
here and staring at Calc. I need to make this happen, and fairly quickly
too.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Need help and don't know where to even start.

[Dries Feys]

Hello,

Though this is possible through calc, there are probably other and
even easier options available:

the ideal on a desktop pc would be to write something in base, though
I'm not experienced with that. Perhaps there exist some web based
options as well.
Finally, there are most likely possibilies in the different app
stores, eg : http://appcrawlr.com/android-apps/best-apps-eat-and-live

Good luck with the development / searching for the tool, but most of
all : good luck with loosing weight! Try to do some sports as well :-)

Met vriendelijke groeten, Salutations distinguées, Kind Regards,

DRIES FEYS
CORPORATE SERVICES • Specialist Software Developer

TVH GROUP NV
Brabantstraat 15 • BE-8790 WAREGEM
T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com
Watch our company movies on www.tvh.tv



Business Innovation
through
Information Technology
bi2t.tvh.com


On 19 January 2016 at 09:45, JL  wrote:
> Good evening all,
>
> I've found myself in a position where I need to drop serious weight for
> health reasons.  I have a diet that works (more a complete change of
> eating) but I need help in the planning of it.  I have used Libre Office
> (and OOo before that) for years, but only for basic word processing and
> *light* slideshow presentations.
>
> I switched to the Eat to Live lifestyle last year and never felt better.
> The problem is, I found myself eating out a lot (take away salads and
> soups) to comply with the diet.  When I bought the stuff myself I either
> bought to much, or not enough.  Eventually I caved into just eating what
> was available.
>
> Now that you know the backstory, what I'm trying to accomplish is this.
>
> 1. I need, using Calc, to create a calender view of the current month.
>
> 2. On each day, I need there to be about 5 dropdown menus, populated
> with menu choices.
>
> 3. Once all of the week is put in (due to a lot of fresh vegetables
> being in, it could be every 3 days. I'm flexible.) I need the program to
> spit out a shopping list
>
> Simplification of the above:  Throughout a week, I put in some meals
> that have 1/2 a cup of spinach here, 2 cups there, ect. I need the
> program to spit out total cups at the end of the week. (as an added
> bonus, if I can put in that X cups ='s Y lbs of a given item so that I
> get weight, even better)
>
> In regards to the above simplification, I don't just need it for
> spinach. It's going to giving me a weekly shopping list of every
> component in every recipe.
>
> I hope this isn't too long winded, but I'm at my wits end just sitting
> here and staring at Calc. I need to make this happen, and fairly quickly
> too.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? 
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
>

-- 


 DISCLAIMER 

http://www.tvh.com/glob/en/email-disclaimer

"This message is delivered to all addressees subject to the conditions
set forth in the attached disclaimer, which is an integral part of this
message."

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Need help and don't know where to even start.

[Andreas Säger]

Am 19.01.2016 um 09:45 schrieb JL:
> Good evening all,
> 
> I've found myself in a position where I need to drop serious weight for
> health reasons.  I have a diet that works (more a complete change of
> eating) but I need help in the planning of it. 


I'd suggest pencil & paper or one of these smartphone apps.





-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc- don't show the decimal point

[Alek]

On 01/19/2016 11:36 AM, Spencer Graves wrote:
>
>
> On 1/19/2016 10:20 AM, Brian Barker wrote:
>> At 10:14 19/01/2016 -0500, Alek Solzhenitsyn wrote:
>>> Brian, I'm not smart.
>>
>> I'm not sure if you are being serious, but it's not a question of
>> being smart or not - so I don't accept that you are not. It's very
>> easy to miss ideas that may happen to occur to others.
>>
>> Brian Barker
>>
>
> You need Format > Cells > Numbers: Format code = 
>
>
> With this, 0.1 appears as "" and 0.6 as "0001".

That isn't what I want- the wrong answer.

>
>
> For more on this, see
> "https://help.libreoffice.org/Common/Number_Format_Codes;, which I
> found searching for "libreoffice calc display fractions without
> decimal point".
>
>
> I agree with Brian:  The foremost experts in any field may not be able
> to solve problems that "lesser" minds handle easily.  That's why a
> second opinion in medicine (or anything else) can be useful.
>
>
>   Spencer Graves
>
>



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] unwanted 'document recovery' dialogue (was: Re: Cannot delete horizontal red line)

[Mike Scott]

On 19/01/16 16:24, R. Diez wrote:
...

Not unheard of. 8-) In fact, when closing Writer, both on Linux and
Windows, I often get a "LibreOffice Document Recovery" dialog. "Due to
an unexpected error, LibreOffice crashed.". "The following files will be
recovered", and then an empty list of files. If then leaves the lock
file ".~lock.CannotSelectRedLine.odt#" behind. If happens if I change
the document and then undo the changes and don't save it to disk, then
close LibreOffice Writer.



That's been happening to me ever since I moved to 5 (5.0.4.2 to be 
precise). Using Mint 17. Never an issue with 4.whatever-it-was.


I use Writer, save and exit, and am occasionally immediately greeted by 
the recovery dialogue followed (IIRC) by the generic LO startup window. 
Anyone else noticed this? It's not repeatable to order, and is quite 
unpredictable.



--
Mike Scott
Harlow, Essex, England

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc- don't show the decimal point

[Tom Davies]

Hi :)
I think the  first cunning answer, to multiply by 1000, then needs
Spencer's formatting in order to deal with the problem Brian
identified in his last paragraph, ie that of 123 needing to be shown
as 0123 to prevent it being mis-read or confusing.

I think that Brian was suggesting combining the "multiply by 1000"
into whatever formula creates the 4-decimal-place values in the first
place.  Doing so might help by avoiding the need for a 2nd calculation
that might then need to be hidden.

The formatting Spencer drew attention to was originally suggested by
Brian but kinda got ignored in this thread because the earlier part of
his answer had been somewhat flummoxing.

Anyway, i hope you have a "good enough" result by using some of the
answers in this thread!
Good luck and regards from
Tom :)



On 19 January 2016 at 20:15, Alek  wrote:
>
>
> On 01/19/2016 11:36 AM, Spencer Graves wrote:
>>
>>
>> On 1/19/2016 10:20 AM, Brian Barker wrote:
>>> At 10:14 19/01/2016 -0500, Alek Solzhenitsyn wrote:
 Brian, I'm not smart.
>>>
>>> I'm not sure if you are being serious, but it's not a question of
>>> being smart or not - so I don't accept that you are not. It's very
>>> easy to miss ideas that may happen to occur to others.
>>>
>>> Brian Barker
>>>
>>
>> You need Format > Cells > Numbers: Format code = 
>>
>>
>> With this, 0.1 appears as "" and 0.6 as "0001".
>
> That isn't what I want- the wrong answer.
>
>>
>>
>> For more on this, see
>> "https://help.libreoffice.org/Common/Number_Format_Codes;, which I
>> found searching for "libreoffice calc display fractions without
>> decimal point".
>>
>>
>> I agree with Brian:  The foremost experts in any field may not be able
>> to solve problems that "lesser" minds handle easily.  That's why a
>> second opinion in medicine (or anything else) can be useful.
>>
>>
>>   Spencer Graves
>>
>>
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? 
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Base out of memory

[Tom Davies]

Hi :)
I have just found this old thread;
https://forum.openoffice.org/en/forum/viewtopic.php?f=13=19016
and it might well still be very relevant.  Also this thread;
http://listarchives.libreoffice.org/global/users/msg08764.html

Err, do you know if you are using an external back-end to contain the
data?  If you are not sure then you are probably using the internal
back-end so that the whole database appears to be just 1 file.  Base
is much better when the tables are exported into an external back-end
that Base then just links to.  The internal back-end is just to help
those who are more familiar with MS's "Access" but Base is far more
powerful, thanks to it's ability to connect with a wide variety of
external back-ends.  Something small fast and powerful such as HSqlDb
might be ideal for your use-case even though it's built on Java;
http://hsqldb.org/
An ancient, heavily tweaked and very restricted form of HSqlDb was
squeezed into being the back-end for Base and there has been some work
into switching to a newer and more easily updateable internal back-end
but i am not sure about the progress.  Anyway the proper full releases
of HSqlDb perform much better than the internal version.

Sorry i am not being very helpful here!  Hopefully someone with a lot
more understanding and/or knowledge will appear or someone give some
other ideas worth trying.

Regards from
Tom :)

On 19 January 2016 at 12:51, Malcolm Moore  wrote:
> The error comes up before you have really had a chance to enter any data
> If you enter the first row and then start entering data in the second row the
> error pops as soon as the cursor goes to the first field in the second row.
>
>
> Mal
>
>
>
>  From:   Tom Davies 
>  To:   Malcolm Moore 
>  Cc:   "users@global.libreoffice.org" 
>  Sent:   19/01/2016 12:41 PM
>  Subject:   Re: [libreoffice-users] Base out of memory
>
> Hi :)
> I am not sure about the SQL error code and haven't even looked it up
> yet.  However it does sound like a quite small database that shouldn't
> be having any trouble with memory.
>
> As a quick first try maybe radically increasing the default settings
> in LibreOffice might help.
> Tools - Options - Memory
> The defaults are all for MUCH lower spec machines so you can easily
> allow LibreOffice to use much larger amounts of Ram.  Hmm, all the
> settings seem to be about graphics and objects so i'm not sure it
> would help.  I think it's still worth a try though.
>
> Regards from
> Tom :)
>
>
>
>
> On 19 January 2016 at 12:29, Malcolm Moore  wrote:
>> Can anyone point me in the right direction here
>>
>>
>> 2 users in a room of 32 users.
>> Design a table - name, DOB, phone number etc  no images or the like
>> Table saves OK
>> When you try and enter data it says
>>
>>
>> SQL Staus : S1000
>> Error code: 72
>> out of memory
>>
>>
>> Machines are openSUSE 13.2
>> 8G ram
>>
>>
>> Ta
>>
>>
>> M
>>
>>
>>
>> --
>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>> Problems? 
>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>> List archive: http://listarchives.libreoffice.org/global/users/
>> All messages sent to this list will be publicly archived and cannot be 
>> deleted
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? 
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Base out of memory

[Alexander Thurgood]

Le 19/01/2016 13:29, Malcolm Moore a écrit :




> 
> SQL Staus : S1000
> Error code: 72
> out of memory
> 

The message points to a lack of assigned memory for the Java VM process
that launches the Base-hdslqdb combination. Could it be that the
machines in question are using multiple other Java threads or apps and
there is not enough memory left to allocate to the opened ODB Java
hsqldb instance ?

If you want to increase the allocated Java resources for an ODB file,
you have to extract it, and go and tweak one of the database specific
configuration files contained therein (unfortunately, can't remember
which one, possibly SCRIPT.

The message could also be completely erroneous or misleading, such
things have already happened in LibreOffice, but then finding out what
really is the problem will be more difficult.



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Base out of memory

[Malcolm Moore]

Can anyone point me in the right direction here


2 users in a room of 32 users.
Design a table - name, DOB, phone number etc  no images or the like
Table saves OK
When you try and enter data it says 


SQL Staus : S1000
Error code: 72
out of memory


Machines are openSUSE 13.2
8G ram


Ta


M


  
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Base out of memory

[Malcolm Moore]

The error comes up before you have really had a chance to enter any data
If you enter the first row and then start entering data in the second row the 
error pops as soon as the cursor goes to the first field in the second row.


Mal



 From:   Tom Davies  
 To:   Malcolm Moore  
 Cc:   "users@global.libreoffice.org"  
 Sent:   19/01/2016 12:41 PM 
 Subject:   Re: [libreoffice-users] Base out of memory 

Hi :) 
I am not sure about the SQL error code and haven't even looked it up 
yet.  However it does sound like a quite small database that shouldn't 
be having any trouble with memory. 
 
As a quick first try maybe radically increasing the default settings 
in LibreOffice might help. 
Tools - Options - Memory 
The defaults are all for MUCH lower spec machines so you can easily 
allow LibreOffice to use much larger amounts of Ram.  Hmm, all the 
settings seem to be about graphics and objects so i'm not sure it 
would help.  I think it's still worth a try though. 
 
Regards from 
Tom :) 
 
 
 
 
On 19 January 2016 at 12:29, Malcolm Moore  wrote: 
> Can anyone point me in the right direction here 
> 
> 
> 2 users in a room of 32 users. 
> Design a table - name, DOB, phone number etc  no images or the like 
> Table saves OK 
> When you try and enter data it says 
> 
> 
> SQL Staus : S1000 
> Error code: 72 
> out of memory 
> 
> 
> Machines are openSUSE 13.2 
> 8G ram 
> 
> 
> Ta 
> 
> 
> M 
> 
> 
> 
> -- 
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org 
> Problems? 
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette 
> List archive: http://listarchives.libreoffice.org/global/users/ 
> All messages sent to this list will be publicly archived and cannot be 
> deleted 



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc- don't show the decimal point

[Spencer Graves]

On 1/19/2016 7:55 AM, Alek wrote:

A calc sheet I've made has thousands of 4 place decimal numbers that
never go over .  (it's a cosine trig. figure)

The decimal place takes up space on the sheet(s) and isn't needed as the
sheet will be printed out as a PDF.

Can someone please tell me how to get rid of the decimal point and so
that the resulting number doesn't change?



  Multiply by 1 then display as integer?


  You can do this in an extra display column beside the column with 
the number you want to display, then Format > Column > Hide the column 
with the number you want to display.  This is not as emotionally 
satisfying as doing it with a special format code, but I don't know the 
latter, and this will work.  Hope this helps. Spencer Graves


Alek





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Base out of memory

[Tom Davies]

Hi :)
I am not sure about the SQL error code and haven't even looked it up
yet.  However it does sound like a quite small database that shouldn't
be having any trouble with memory.

As a quick first try maybe radically increasing the default settings
in LibreOffice might help.
Tools - Options - Memory
The defaults are all for MUCH lower spec machines so you can easily
allow LibreOffice to use much larger amounts of Ram.  Hmm, all the
settings seem to be about graphics and objects so i'm not sure it
would help.  I think it's still worth a try though.

Regards from
Tom :)




On 19 January 2016 at 12:29, Malcolm Moore  wrote:
> Can anyone point me in the right direction here
>
>
> 2 users in a room of 32 users.
> Design a table - name, DOB, phone number etc  no images or the like
> Table saves OK
> When you try and enter data it says
>
>
> SQL Staus : S1000
> Error code: 72
> out of memory
>
>
> Machines are openSUSE 13.2
> 8G ram
>
>
> Ta
>
>
> M
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? 
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Calc- don't show the decimal point

[Alek]

A calc sheet I've made has thousands of 4 place decimal numbers that
never go over .  (it's a cosine trig. figure)

The decimal place takes up space on the sheet(s) and isn't needed as the
sheet will be printed out as a PDF.

Can someone please tell me how to get rid of the decimal point and so
that the resulting number doesn't change?

Alek


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc- don't show the decimal point

[Brian Barker]

At 08:09 19/01/2016 -0600, Spencer Graves wrote:

On 1/19/2016 7:55 AM, Alek Solzhenitsyn wrote:
A calc sheet I've made has thousands of 4 place decimal numbers 
that never go over .  (it's a cosine trig. figure). The decimal 
place takes up space on the sheet(s) and isn't needed as the sheet 
will be printed out as a PDF. Can someone please tell me how to get 
rid of the decimal point and so that the resulting number doesn't change?


Multiply by 1 then display as integer?

You can do this in an extra display column beside the column with 
the number you want to display, then Format > Column > Hide the 
column with the number you want to display. This is not as 
emotionally satisfying as doing it with a special format code, but I 
don't know the latter, and this will work.


Even simpler, why not construct your spreadsheet so that it handles 
the numbers you really want instead of those that you don't? Change 
your formulae - surely a simple task? - to calculate with up-to- 
four-digit integers instead of the fractional ones you have. You will 
find the number 1 helpful. You can easily *think* 0.1234 when you 
read "1234" in a cell.


You will want to format the cells as "" so that what you think of 
as 0.0123 will appear as "0123" and not "123".


I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Cannot delete horizontal red line

[R. Diez]

Hi all:

I managed to add an horizontal red line to my document's footer that I 
cannot delete anymore. I just cannot select it with the mouse.


Please find attached the document. I stripped all contents down to a 
couple of text lines.


Could that be a bug in LibreOffice? I am using the latest version 5.0.4.2.

Thanks,
  rdiez

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc- don't show the decimal point

[Alek]

On 01/19/2016 09:09 AM, Spencer Graves wrote:
>
>
> On 1/19/2016 7:55 AM, Alek wrote:
>> A calc sheet I've made has thousands of 4 place decimal numbers that
>> never go over .  (it's a cosine trig. figure)
>>
>> The decimal place takes up space on the sheet(s) and isn't needed as the
>> sheet will be printed out as a PDF.
>>
>> Can someone please tell me how to get rid of the decimal point and so
>> that the resulting number doesn't change?
>
>
>   Multiply by 1 then display as integer?
>
That's perfect.

Thanks,

Alek


>
>   You can do this in an extra display column beside the column
> with the number you want to display, then Format > Column > Hide the
> column with the number you want to display.  This is not as
> emotionally satisfying as doing it with a special format code, but I
> don't know the latter, and this will work.  Hope this helps. Spencer
> Graves
>>
>> Alek
>>
>>
>
>



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc- don't show the decimal point

[Alek]

On 01/19/2016 09:41 AM, Brian Barker wrote:
> At 08:09 19/01/2016 -0600, Spencer Graves wrote:
>> On 1/19/2016 7:55 AM, Alek Solzhenitsyn wrote:
>>> A calc sheet I've made has thousands of 4 place decimal numbers that
>>> never go over .  (it's a cosine trig. figure). The decimal place
>>> takes up space on the sheet(s) and isn't needed as the sheet will be
>>> printed out as a PDF. Can someone please tell me how to get rid of
>>> the decimal point and so that the resulting number doesn't change?
>>
>> Multiply by 1 then display as integer?
>>
>> You can do this in an extra display column beside the column with the
>> number you want to display, then Format > Column > Hide the column
>> with the number you want to display. This is not as emotionally
>> satisfying as doing it with a special format code, but I don't know
>> the latter, and this will work.
>
> Even simpler, why not construct your spreadsheet so that it handles
> the numbers you really want instead of those that you don't? Change
> your formulae - surely a simple task? - to calculate with up-to-
> four-digit integers instead of the fractional ones you have. You will
> find the number 1 helpful. You can easily *think* 0.1234 when you
> read "1234" in a cell.
>
> You will want to format the cells as "" so that what you think of
> as 0.0123 will appear as "0123" and not "123".
>
> I trust this helps.
>
> Brian Barker

Brian, I'm not smart.



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Cannot delete horizontal red line

[Brian Barker]

At 16:06 19/01/2016 +0100, R. Diez wrote:
I managed to add an horizontal red line to my document's footer that 
I cannot delete anymore. I just cannot select it with the mouse. 
Please find attached the document. I stripped all contents down to a 
couple of text lines.


Attached files are generally removed by the mailing list processor 
before messages are distributed, so no-one will have been able to see 
your document.


One possibility is that you have added a top or bottom border to a 
paragraph. This will remain even if you remove the text of the paragraph.

o Put the cursor in the preceding or following paragraph.
o Go to right-click | Paragraph... or right-click | Edit Paragraph 
Style... . (The problem could be in either place.)

o On the Borders tab, adjust "Line arrangement" to show no borders.


Could that be a bug in LibreOffice?


Possibly not.

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc- don't show the decimal point

[Brian Barker]

At 10:14 19/01/2016 -0500, Alek Solzhenitsyn wrote:

Brian, I'm not smart.


I'm not sure if you are being serious, but it's not a question of 
being smart or not - so I don't accept that you are not. It's very 
easy to miss ideas that may happen to occur to others.


Brian Barker  



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Cannot delete horizontal red line

[R. Diez]

Attached files are generally removed by the mailing list processor
before messages are distributed, so no-one will have been able to see
your document.


OK, thanks. It is a shame that I cannot send even a tiny example 
document. I am attaching it again, so that at least you get it.




One possibility is that you have added a top or bottom border to a
paragraph.

> [...]


I drew the line manually using Insert, Shapes, Line.

I double-checked anyway, and all places I could find following your 
instructions are set to "Set no borders".



>> Could that be a bug in LibreOffice?

> Possibly not.

Not unheard of. 8-) In fact, when closing Writer, both on Linux and 
Windows, I often get a "LibreOffice Document Recovery" dialog. "Due to 
an unexpected error, LibreOffice crashed.". "The following files will be 
recovered", and then an empty list of files. If then leaves the lock 
file ".~lock.CannotSelectRedLine.odt#" behind. If happens if I change 
the document and then undo the changes and don't save it to disk, then 
close LibreOffice Writer.


This is a very small document, on a rather clean Ubuntu 14.04.3, and a 
Windows 7 PC. All other software is pretty stable.


But the problem with the red line is what bothers me most at this point 
in time.


Thanks,
  rdiez


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc- don't show the decimal point

[Spencer Graves]

On 1/19/2016 10:20 AM, Brian Barker wrote:

At 10:14 19/01/2016 -0500, Alek Solzhenitsyn wrote:

Brian, I'm not smart.


I'm not sure if you are being serious, but it's not a question of 
being smart or not - so I don't accept that you are not. It's very 
easy to miss ideas that may happen to occur to others.


Brian Barker



You need Format > Cells > Numbers: Format code = 


With this, 0.1 appears as "" and 0.6 as "0001".


For more on this, see 
"https://help.libreoffice.org/Common/Number_Format_Codes;, which I found 
searching for "libreoffice calc display fractions without decimal point".



I agree with Brian:  The foremost experts in any field may not be able 
to solve problems that "lesser" minds handle easily.  That's why a 
second opinion in medicine (or anything else) can be useful.



  Spencer Graves


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] R1C1 reference style with LibreOffice

[pacopyc pacopyc]

Hi, I have to convert a macro from Excel to LibreOffice. The Excel macro
contains many formulas in R1C1 reference style.

How can I rewrite the formulas in R1C1 reference style with LibreOffice? Is
it possible?

Thanks
pacopyc

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted