[libreoffice-users] Changing the sidebar colour

2014-05-31 Thread aloisio
Hello, I'm using the default theme supplied on opensuse 13.1 but I'd like to change a couple of things. How do I change the background colour on the left sidebar here: https://i.imgur.com/BzdJM6r.jpg ? Is it a hidden setting? Do I have to create an alternate theme? Or perhaps yet something

[libreoffice-users] Can't get leading zeros in Calc

2014-05-31 Thread Oogie McGuire
I'm tearing my hair out here. I have a spreadsheet and the data was originally entered as 4 digits. I need to pass it to a database system that requires 6 digits. I've tried formatting with 2 leading zeros but I still cannot get the number to properly show up as 00number Any ideas? Eugenie

Re: [libreoffice-users] Can't get leading zeros in Calc

2014-05-31 Thread Brian Barker
At 17:34 31/05/2014 -0600, Oogie McGuire wrote: I'm tearing my hair out here. Don't! I have a spreadsheet and the data was originally entered as 4 digits. I need to pass it to a database system that requires 6 digits. I've tried formatting with 2 leading zeros but I still cannot get the

Re: [libreoffice-users] Can't get leading zeros in Calc

2014-05-31 Thread Joe Conner
On 05/31/2014 04:34 PM, Oogie McGuire wrote: I'm tearing my hair out here. I have a spreadsheet and the data was originally entered as 4 digits. I need to pass it to a database system that requires 6 digits. I've tried formatting with 2 leading zeros but I still cannot get the number to

Re: [libreoffice-users] Can't get leading zeros in Calc

2014-05-31 Thread Oogie McGuire
Already tried that, it doesn't work. I tried a custom format 00 but still only get 4 digits. On May 31, 2014, at 6:17 PM, Joe Conner joeconner2...@gmail.com wrote: cell-format-number. In the format code bar near the bottom input cell format as 00. without the quote marks. You

Re: [libreoffice-users] Can't get leading zeros in Calc

2014-05-31 Thread ZP
On Sun, 01 Jun 2014 01:11:36 +0100 Brian Barker b.m.bar...@btinternet.com wrote: At 17:34 31/05/2014 -0600, Oogie McGuire wrote: I'm tearing my hair out here. Don't! I have a spreadsheet and the data was originally entered as 4 digits. I need to pass it to a database system that

Re: [libreoffice-users] Can't get leading zeros in Calc

2014-05-31 Thread Jay Lozier
On 06/01/2014 01:02 AM, ZP wrote: On Sun, 01 Jun 2014 01:11:36 +0100 Brian Barker b.m.bar...@btinternet.com wrote: At 17:34 31/05/2014 -0600, Oogie McGuire wrote: I'm tearing my hair out here. Don't! I have a spreadsheet and the data was originally entered as 4 digits. I need to pass it

Re: [libreoffice-users] Can't get leading zeros in Calc

2014-05-31 Thread Brian Barker
At 13:02 01/06/2014 +0800, Zonly Ponly wrote: On Sun, 01 Jun 2014 01:11:36 +0100 Brian Barker wrote: At 17:34 31/05/2014 -0600, Oogie McGuire wrote: I have a spreadsheet and the data was originally entered as 4 digits. I need to pass it to a database system that requires 6 digits. I've tried