For the last several versions of LO, and I believe back to OO, I am
having a data entry/display issue re: comments. On a calc sheet with
frozen cells, if I am putting a comment in a cell at the top of the
unfrozen area, I have a problem with data entry. It seems that the
mouse cursor must be
I know this is a bad time, since 4.0 was just released, but improvement
is an ongoing process.
For the 'recent documents' menu selection under 'file', it would be nice to:
1) allow us to set the number of recent documents, under tools/options.
2) allow us, in the recent menu, to right click and
/2013 11:33 AM, Joel Madero wrote:
On Tue, Feb 12, 2013 at 11:04 AM, John R. Sowden
jsow...@americansentry.net mailto:jsow...@americansentry.net wrote:
I know this is a bad time, since 4.0 was just released, but
improvement is an ongoing process.
For the 'recent documents' menu
not be suggested because of the above and the fact that it is not
clear where to request them.
John
On 02/12/2013 11:51 AM, Joel Madero wrote:
On Tue, Feb 12, 2013 at 11:50 AM, John R. Sowden
jsow...@americansentry.net mailto:jsow...@americansentry.net wrote:
I went to the site that you
Why do the Libreoffice powers that be define dbase/xbase as a flat file
database, not a relational database. The below definitions from the
Base Intro documentation demonstrate what I am saying:
*Flat databases*
A flat database contains one or more tables, each containing one or more
On 03/03/2013 07:27 AM, Dan Lewis wrote:
On 03/03/2013 10:09 AM, John R. Sowden wrote:
Why do the Libreoffice powers that be define dbase/xbase as a flat
file database, not a relational database. The below definitions from
the Base Intro documentation demonstrate what I am saying:
*Flat
On 03/03/2013 09:30 AM, Regina Henschel wrote:
Hi John,
John R. Sowden schrieb:
Why do the Libreoffice powers that be define dbase/xbase as a flat file
database, not a relational database. The below definitions from the
Base Intro documentation demonstrate what I am saying:
Do you have
On 03/03/2013 10:28 AM, Jay Lozier wrote:
On 03/03/2013 12:39 PM, Mark Stanton wrote:
I think the (incorrect) definition that is being used is whether LO
manipulates files directly or talks to a database engine.
I don't think there is a dBase or FoxBase engine. I'm pretty sure
there is a
On 03/03/2013 10:50 AM, Wolfgang Keller wrote:
Why do the Libreoffice powers that be define dbase/xbase as a flat
file database, not a relational database.
The main issue for me would be whether the database management
system (some call it engine or whatever) actually enforces
relational
When I have split a calc document to lock the titles, etc, I have a
problem inserting/editing comments for a cell if the comment text area
is above the split line. LO only accepts about 4 characters, then
ignores further entry, I have to put the mouse cursor in the comment
area and click on
Good Morning:
I have been receiving duplicate messages from the libreoffice users
mailing list for about a month. Multiple messages to
users+ow...@global.libreoffice.org is only resulting in a boilerplate
email that talks mainly about how to unsubscribe from the list.
How do I get a
test-delete me
--
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:
--
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
I have 2 Open menu options, both seem to to do the same thing. I have
version 4.0.2.2 under Ubuntu
John
--
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:
I am having a problem setting the default font in calc. This is usually
not an issue, as I often start a new sheet from an existing sheet. But
if I start from the first menu, I get a font called 'arial' (sounds like
a mermaid or m$). Since I am using an oss program, i would prefer to
use an
On 07/02/2013 01:56 PM, Regina Henschel wrote:
Hi John,
John R. Sowden schrieb:
I am having a problem setting the default font in calc. This is usually
not an issue, as I often start a new sheet from an existing sheet. But
if I start from the first menu, I get a font called 'arial' (sounds
We have created a floor plan, using LO Draw with a scale of 1/8 = 1'.
Now we want to take it to Kinko's (Fed Ex) and have it printed for about
$4.00 per page. Problem is they cannot print it. A few questions:
1) What is the standard file format (description and file type) for
professional
On 07/24/2013 04:23 AM, Kracked_P_P---webmaster wrote:
On 07/24/2013 06:41 AM, John R. Sowden wrote:
We have created a floor plan, using LO Draw with a scale of 1/8 =
1'. Now we want to take it to Kinko's (Fed Ex) and have it printed
for about $4.00 per page. Problem is they cannot print
the word out.
Again thanks,
John
On 07/24/2013 06:41 AM, John R. Sowden wrote: We have created a floor
plan, using LO Draw with a scale of 1/8 = 1'. Now we want to take it
to Kinko's (Fed Ex) and have it printed for about $4.00 per page.
Problem is they cannot print it. A few questions:
1
that is printed is the area inside this
grayed box.
tia,
John
On 07/24/2013 12:42 PM, John R. Sowden wrote:
On 07/24/2013 06:41 AM, John R. Sowden wrote: We have created a floor
plan, using LO Draw with a scale of 1/8 = 1'. Now we want to take it
to Kinko's (Fed Ex) and have it printed
/2013 09:45 AM, John R. Sowden wrote:
I am having another, yet related, problem. The drawing is larger than
8.5 x 11. When I display it on the screen, there is a grayed
portrait double line box, which covers the same area that is printed,
on the screen. I thought that was the page pane. Not so
Similar to gedit (ubuntu), it would be nice if I could point my mouse
_near_ the lower right corner to adjust the size of a libre office
window, as opposed to placing the tip of the mouse pointer arrow on the
pixel where the vertical and horizontal lines meet. Usually I cannot
even get to the
I am running Ubuntu 12.04, the Libre Office 3.5.3.2 with 1 GB ram. I
rarely go into my swap partition. When in calc, often the system grinds
to a halt. Usually it takes about 15 seconds to allow mouse pointer
change, etc. Meanwhile, I can run Freecell with no slowdown while I am
waiting,
On 06/23/2012 10:04 AM, Jay Lozier wrote:
John,
On 06/23/2012 12:15 PM, John R. Sowden wrote:
I am running Ubuntu 12.04, the Libre Office 3.5.3.2 with 1 GB ram. I
rarely go into my swap partition. When in calc, often the system
grinds to a halt. Usually it takes about 15 seconds to allow
: [libreoffice-users] Screen goes dark gray, Libreoffice stops
To: users@global.libreoffice.org
Date: Saturday, 23 June, 2012, 18:31
On 06/23/2012 10:04 AM, Jay Lozier wrote:
John,
On 06/23/2012 12:15 PM, John R. Sowden wrote:
I am running Ubuntu 12.04, the Libre Office 3.5.3.2 with 1 GB ram. I
rarely
On 06/23/2012 12:05 PM, Andreas Säger wrote:
Am 23.06.2012 20:54, Tom Davies wrote:
Hi :)
Open Lo and go to
Tools - Options - Java
Once again: Not a single built-in Calc feature depends on Java.
Like any other type of document, spreadsheets can be exported to XHTML
which depends on Java,
LO 3.6.2.2 on Xubuntu 12.10. when I dir to File-- open, I am presented
with hundreds of hidden files (1st char is a period). How do I hide
these. I searched help, and all of the tools--options area.
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems?
On 11/07/2012 04:50 PM, John R. Sowden wrote:
LO 3.6.2.2 on Xubuntu 12.10. when I dir to File-- open, I am
presented with hundreds of hidden files (1st char is a period). How
do I hide these. I searched help, and all of the tools--options area.
found the answer: while in the open a file
How do I 'save as' or export selected text in LO calc to an ascii file
where i can exit it. I seem only to have the options for special file
formats, PDF, XML, etc.
Thanks, John
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems?
Been having the problem for a long time. Using Calc, I write a date,
Oct 23rd, (I add the rd which shows as a superscript. Problem is
whenever I add new text to the cell, it is in the superscript size, not
regular text.
John
--
To unsubscribe e-mail to:
On 10/11/2013 12:51 PM, Mark Bourne wrote:
John R. Sowden wrote:
Been having the problem for a long time. Using Calc, I write a date,
Oct 23rd, (I add the rd which shows as a superscript. Problem is
whenever I add new text to the cell, it is in the superscript size, not
regular text.
John
On 10/13/2013 12:59 AM, Paul van Tooren wrote:
John,
After adding the rd insuperscript, you have to chance again back to
normal script.
Succes
Paul van Tooren
-Oorspronkelijk bericht- From: John R. Sowden
Sent: Friday, October 11, 2013 8:21 PM
To: users@global.libreoffice.org
On 10/25/2013 12:02 PM, william drescher wrote:
I just upgraded to Version 4.0.5.2
(Build ID: 5464147a081647a250913f19c0715bca595af2f)
Now I have duplicate open buttons on the standard toolbar. Both have
tooltips that say Open (ctrl + O)
not a problem for me, just wondered
bill
same
On 10/25/2013 01:57 PM, Joel Madero wrote:
On 10/25/2013 01:15 PM, John R. Sowden wrote:
On 10/25/2013 12:02 PM, william drescher wrote:
I just upgraded to Version 4.0.5.2
(Build ID: 5464147a081647a250913f19c0715bca595af2f)
Now I have duplicate open buttons on the standard toolbar. Both
have
On 10/25/2013 08:28 PM, baldwin linguas wrote:
On Fri, Oct 25, 2013 at 11:09 PM, John R. Sowden
jsow...@americansentry.net wrote:
On 10/25/2013 01:57 PM, Joel Madero wrote:
On 10/25/2013 01:15 PM, John R. Sowden wrote:
On 10/25/2013 12:02 PM, william drescher wrote:
I just upgraded
On 11/19/2013 06:10 PM, Jay Lozier wrote:
On 11/19/2013 07:30 PM, Virgil Arrington wrote:
FreeOffice is interesting. In many ways, it resembles LO or OOo. Does
anyone know if it was some form of fork or dirivative?
Virgil
Virgil
I believe FreeOffice is proprietary and is the free version
I just installed LO 4.1 on my win vista laptop. the font I normally use
on my desktops (ubuntu 13.10) is freesans. There is no freesans in the
font list. Is this a 'windows thing'?
How large (in K) are each font file (I'm sure they vary somewhat)?
How do I delete the ones that I will never
or find the best choice we have is a bad one.
Regards from
Tom :)
On 11 December 2013 22:11, John R. Sowden jsow...@americansentry.net wrote:
I just installed LO 4.1 on my win vista laptop. the font I normally use on
my desktops (ubuntu 13.10) is freesans. There is no freesans in the font
list
With the recent messages re: the label function, I created a shipping
label. Worked very nicely. Is there a feature to populate the rest of
the labels on a sheet (on the screen), from the top left one, so they
are all the same?
John
--
To unsubscribe e-mail to:
would make sense.
John
On 12/17/2013 02:32 PM, Don C. Myers wrote:
Hi John,
If you are using the table based templates, simply copy and paste.
Don
On 12/17/2013 02:35 PM, John R. Sowden wrote:
With the recent messages re: the label function, I created a shipping
label. Worked very nicely
On 01/04/2014 08:12 PM, Brian Barker wrote:
At 19:10 04/01/2014 -0500, Ryan Ashley wrote:
I have developed a spreadsheet which contains a sheet for the cover
and basic information as well as one sheet for every month. There is
a cell with a number on every sheet at location H35. I want the
On 01/19/2014 03:15 AM, Ernest Dale wrote:
I run an important database on Lotus Approach and I have found that
Approach will not install on a fresh version of Windows.
To surmount the problem I have downloaded Libre Office and attempted to
transfer the database on to it. I appear to have
Is it possible to copy text, then paste it into the edit box in calc 4,x
under ubuntu 13.10? Now I have to put the cursor in the edit box, then
click on edit- paste.
John
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
I have a calc sheet about 600 lines long with data at the top that I
would like to see while I an using the data at, say line 400. Is it
possible to open a second window showing the data at the top while
editing the data at lower lines?
John
--
To unsubscribe e-mail to:
On 03/06/2014 01:34 PM, Brian Barker wrote:
At 13:20 06/03/2014 -0800, John R. Sowden wrote:
I have a calc sheet about 600 lines long with data at the top that I
would like to see while I an using the data at, say line 400. Is it
possible to open a second window showing the data at the top
On 03/07/2014 04:09 AM, Cley Faye wrote:
2014-03-06 22:49 GMT+01:00 John R. Sowden jsow...@americansentry.net:
On 03/06/2014 01:34 PM, Brian Barker wrote:
At 13:20 06/03/2014 -0800, John R. Sowden wrote:
I have a calc sheet about 600 lines long with data at the top that I
would like to see
why can't I right click on paste to paste text into the edit box instead
of having to go to the edit--paste drop down menu?
no one has ever asked, or is there a technical reason?
John
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
On 04/21/2014 02:42 PM, Dave Liesse wrote:
Don't think I've ever run across the right-click behavior you mention,
but I just left-click in the box and then Ctrl-V (I never use a menu if
there's a shortcut key available -- too slow!).
Dave
On 4/21/2014 13:09, John R. Sowden wrote:
why can't
On 04/22/2014 11:39 AM, libreoffice-ml.mbou...@spamgourmet.com wrote:
John R. Sowden wrote:
why can't I right click on paste to paste text into the edit box instead
of having to go to the edit--paste drop down menu?
I assume you're referring to the input line (where you can type
formulas etc
On 04/23/2014 11:56 AM, libreoffice-ml.mbou...@spamgourmet.com wrote:
John R. Sowden wrote:
re: alternatives, this is how I use it-might apply to others:
Pay credit card on line
Copy verification number from web site
paste verification number to an empty cell
change font from not free sans
I have a vendor who allows me to download a spreadsheet of my monthly
invoice. If she downloads it to herself, in the CSV format, she gets 1
field per column in Excel. If I download the sheet in the CSV format, I
get all of the fields in 1 column. See headings below from libreoffice.
On 05/13/2014 12:10 PM, Cley Faye wrote:
2014-05-13 20:32 GMT+02:00 John R. Sowden jsow...@americansentry.net:
I have a vendor who allows me to download a spreadsheet of my monthly
invoice. If she downloads it to herself, in the CSV format, she gets 1
field per column in Excel. If I download
I have tried to standardize on freesans 10 point for most ss uses. I
just came on a file with very small type size, yet when I selected the
cell and the format - font, I got freesans 10 point. Not wanting to
diagnose myself as blind and/or crazy, I brought up another file with
the same
Below is why I still use WordStar 5.5 in my office:
I am creating a form (an invoice for my ebay purchases because many
sellers don't send one).
1) ebay lower cases their name. I type 'ebay'. LO corrects me to make
it Ebay.
2) I type seller:. on the next line I create an underline about
John,
On 5 September 2014 22:20, John R. Sowden jsow...@americansentry.net
wrote:
Below is why I still use WordStar 5.5 in my office:
I am creating a form (an invoice for my ebay purchases because many
sellers don't send one).
1) ebay lower cases their name. I type 'ebay'. LO corrects me
Now that I have created my invoice form, I went into file/properties and
checked 'open as read only', so the form does not get filled in.
Then I decided to make some improvements. When I opened the file, of
course, it is set to read only, so I went to properties and found the
check box
form
with no mods to a new file name, exit LO, using Linux, delete the
original file. I just assumed there was a way to unset what LO set.
John
On 09/05/2014 07:10 PM, Dave Barton wrote:
Original Message
From: John R. Sowden jsow...@americansentry.net
To: users
' and 'apply user changes' buttons/boxes
selections in the properties selection, but they had no effect.
John
On 09/06/2014 09:25 AM, John R. Sowden wrote:
Good Morning All:
Re: the properties/security/read only, this is where it all started,
because I used that feature to secure the file
I hadn't even thought of/tried the undelete feature. I was unaware of
Ctrl Z, but, as hex 26 is an end of file marker, in my mind I block that
out. That was a trick that I have used to make part of a file
unreadable, based on which editor was being used to view the file.
Thanks,
John
On
I have been using LO from the 'beginning'. I have never be able to get
the menu command 'Find' to work. Just to be sure I just tried again.
The Edit-Find Selection has the three dots after it, telling me that a
dialog box/menu will open. Nothing happens, anywhere on the screen.
When I press
On 09/17/2014 11:27 AM, Mark Bourne wrote:
John R. Sowden wrote:
I have been using LO from the 'beginning'. I have never be able to get
the menu command 'Find' to work. Just to be sure I just tried again.
The Edit-Find Selection has the three dots after it, telling me that a
dialog box/menu
I am starting the long trek from WordStar/DOS to Libre Office/Ubuntu. I
have many forms to create, about 6 are envelopes. Since our Dell Laser
printer does not like to print envelopes en masse, I'm giving LO a go.
Problem is in 'help', I am directed to 'insert envelope'. By insert, I
On the other hand it can't hurt to have a quick look! ;)
Regards from
Tom :)
On 1 October 2014 06:51, John R. Sowden jsow...@americansentry.net wrote:
I am starting the long trek from WordStar/DOS to Libre Office/Ubuntu. I
have many forms to create, about 6 are envelopes. Since our Dell Laser
printer
There is a program called gLabels. I use it to create mailing labels.
Re: business cards, I would avoid laser, as business cards are usually
stacked together, so they rub. They will wear off the laser toner. Ink
is soaked into the paper so it won't come off. That would interfere with
the
On 02/22/2015 10:02 AM, Jay Lozier wrote:
On 02/22/2015 12:18 PM, office76#xt wrote:
Hi,
This may sound like some ones homework but its really an
algorithm
question I have.
Imagine you had a square plot of land. You could assign this to a
grid and
create a two dimensional graph
I am moving a form from WordStar/DOS to LO. I have all of the
coordinates, font sizes, etc. from the DOS doc; now I need to create the
LO doc. How do I display the column and line numbers (on the LO screen,
not the document).
John
--
To unsubscribe e-mail to:
LO v4.1, xubuntu v12.04
I have a 1000-2000 line spreadsheet with half of the cells with
formulas. When I, say, delete 30 lines, it takes about 45 seconds.
The problem is that I have no idea if it is still a work in progress, or
its done. A simple indicator (flashing colored circle, etc.) to
always a good idea. this should be done about once every 6 mo. to also
track trends. first the questions should be suggested and agreed upon.
then, before the next survey 6 mo. down the road, we discuss
modifications to the list; probably more additions than deletions, maybe
a few wording
I have been dealing with this issue for years, going back to the Open
Office days.
How do you install Libreoffice under Ubuntu?
Where are the step by step, clearly documented instructions?
When are they not either on the download page in LO or a clear link on
the download page?
Here's what
I have been using the command line since trs-80, cp/m and dos before
moving to linux. What are the commands? (Fresh PPA)
John
On 10/08/2015 08:50 PM, Andreas Säger wrote:
Am 09.10.2015 um 04:47 schrieb John R. Sowden:
I have been dealing with this issue for years, going back to the Open
Lo ver 4.4.3.2 Calc under Ubuntu 14.04. I entered "= up arrow" in a
cell so the above cell equals the current cell. I have been using this
sheet for > 5 years. I use this formula in each years sheet 72 times,
this is the first error.
I was able to duplicate it 3 times. The first 2 times
More: This time I copied from a diffent cell to the same cell as
before, immed crash. Also I do three columns like this. The first col
was ok, the third col was ok, the lower of the two in the second col was
ok, the upper of the second col went boom.
On 12/01/2015 12:52 PM, John R. Sowden
.
John
On 12/01/2015 01:16 PM, Tim Lloyd wrote:
John,
did you get LO from the ubuntu repos?
I tried this under Fedora 23 and LO5.0.1.2 (from the LO website) with
no problems.
Cheers
On 02/12/15 08:11, John R. Sowden wrote:
More: This time I copied from a diffent cell to the same cell
I want a link (launcher?) on my ubuntu 14.04 box to run LO in a
directory that I specify without opening a specific file. I entered the
"working directory" and the approved execution name
(/usr/bin/libreoffice). Problem is LO comes up in, I think, the last
directory that I used. How do I
Why am I sent off to the internet when I press F1 for help if I have
local help down
loaded? (ubuntu 14.04, LO v4.4.3.2)
If it tests for local help and cannot find it (installed incorrectly),
how can I test for correct
install myself (where is/what is the file, etc.)
tia,
John
--
To
r problem, then I cannot help you further, but
maybe someone else can.
Graham
On 20 November 2015 at 21:50, John R. Sowden
<jsow...@americansentry.net <mailto:jsow...@americansentry.net>> wrote:
Why am I sent off to the internet when I press F1 for help if I
have local
Under help, I have 3 files, no dir. I created the en-US directory, then
I moved the 3 files into the new dir. Tried LO again, but I still went
to the net.
John
On 11/21/2015 10:36 AM, Regina Henschel wrote:
Hi John,
John R. Sowden schrieb:
Thanks for the response. I found that LO
I have a SS with about 6 pages, lots of calcs, lookups, etc. about 175K
in size. I am running LO ver 5.0.3.2 under Ubuntu ver 14.04 with 4 GB
ram.. The other year's sheets of the same size run fine (several a
little larger). All of a sudden at about line 250 I hit a brick wall. I
enter
that isn't ready for spreadsheet prime time.
Virgil
On 01/15/2016 02:20 PM, John R. Sowden wrote:
I have a SS with about 6 pages, lots of calcs, lookups, etc. about
175K in size. I am running LO ver 5.0.3.2 under Ubuntu ver 14.04
with 4 GB ram.. The other year's sheets of the same size run
I have a spreadsheet that is about 500 rows long and about 20 columns
wide. Column 1 is a date column.
I do not process the date in any cell formulas. When I hit December,
about half way through the 500 rows, it tales about 15 seconds to enter
a number in a blank field. This is new, as I have
xubuntu 14.04 lts, LO v5.0.5.2
When I load a calc file it takes a long time. The progress bar at the
bottom immediately goes the the middle, then stops. I have timed it at
about 40 seconds until the file is opened. This seems to be an issue
only with my "checkbook". We are on a
sorry xubuntu gnome (not unity)
On 03/16/2016 01:35 PM, V Stuart Foote wrote:
@John, *
What OS and Desktop Environment. On Windows builds, there is a nice large
target, at least 10 px, that triggers the corner "resize" grab. Have no
problem resizing this OS.
Stuart
--
View this message
, but I don't
remember the processor speed (it was 3rd-fastest available when I got
the machine, but that's about 5½ years ago now). Do you, perhaps,
have a number of non-displaying calculated fields? That's the only
thing that comes to mind.
Dave Liesse
On 3/15/2016 10:14, John R. Sowden
RecentDocsThumbnail does not appear to be in the expert database.
John
On 03/22/2016 07:52 AM, V Stuart Foote wrote:
Recent Documents and its related RecentDocsThumbnail (at 5.2) are
configurable in Expert Configuration (Tools -> Options -> Advanced: Expert
Configuration
Open the Expert
In order to reduce the size of an LO window, the mouse is used to grab
the lower right corner and bring it up/left. The problem is that it
seems that the point of the mouse pointer must be on the corner pixel of
the window. This is very tedious and time consuming. My first thought
was this
On 04/21/2016 03:43 PM, Piet van Oostrum wrote:
John R. Sowden wrote:
> I have an accounting ledger in calc, with two columns in question.
>
> col 1 is credit (amount charged to account) and col 2 is the account
> number (a 4 digit number currently formatted a number wit
I have an accounting ledger in calc, with two columns in question.
col 1 is credit (amount charged to account) and col 2 is the account
number (a 4 digit number currently formatted a number with no decimal,
but not text).
My objective is to sum the amounts in column 1 if col 2=1234. Not a
R. Sowden wrote:
I wrote about this a few weeks ago, but got no response. Now I have
done some testing and my results might cause someone to notice what
the issue is. I am running Ubuntu 14.04 and LO Version 5.0.5.2.
I have a spreadsheet of about 200k. it is about 6 pages and there
are some
ture to being a menu-item, such as the "Help" menu or
somewhere.
Regards from
Tom :)
On 13 May 2016 at 16:47, John R. Sowden <jsow...@americansentry.net> wrote:
Whenever I start LO 5, I get a message about a file that is damaged and I
am asked if I want to fix it. I say y
Whenever I start LO 5, I get a message about a file that is damaged and
I am asked if I want to fix it. I say yes, LO comes back and says it
cannot be fixed.
I am able to access the file (password protected SS) with no problem.
I am offered the option of deleting information regarding fixing
I wrote about this a few weeks ago, but got no response. Now I have
done some testing and my results might cause someone to notice what the
issue is. I am running Ubuntu 14.04 and LO Version 5.0.5.2.
I have a spreadsheet of about 200k. it is about 6 pages and there are
some links between a
On 04/30/2016 09:23 AM, Andreas Säger wrote:
Am 30.04.2016 um 00:02 schrieb John R. Sowden:
I then copied another test sheet and deleted all entries below December,
calcs and cursor moves worked fine.
Therefore I concluded that the problem is with the dates after
December. I am doing no date
Barker wrote:
At 10:23 20/07/2016 -0700, John R. Sowden wrote:
I think you just introduced another set of questions.
I don't think so ...
Is the "&" used for macro substitution?
Er, nope: it's the concatenation operator.
I assume the lowercase n is a shorthand way of definin
If I have a cell with following formula, can I replace a cell
coordinate, such as the 52 below, with a variable that I can assign at
the top of my spreadsheet?
=sum(a1:a52)
Thanks, John
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
with my mouse
(manual), is it possible that the indirect() function will fail because
the assignment was not reread? (I am thinking in terms of procedural
code here (Basic, Pascal, xBase).
John
On 07/20/2016 09:35 AM, Brian Barker wrote:
At 08:50 20/07/2016 -0700, John R. Sowden wrote:
If
I have a 5 page spreadsheet, one page that gets used ofter, the others
are not used much. Page 2 is a chart of accounts that a column in page
1 refers to often. Page 1 is about 400 lines long, maybe 10 columns
wide. There is a date column, but I do not do date math, and no other
cells refer
I have a 5 page spreadsheet, one page that gets used ofter, the others
are not used much. Page 2 is a chart of accounts that a column in page
1 refers to often. Page 1 is about 400 lines long, maybe 10 columns
wide. There is a date column, but I do not do date math, and no other
cells refer
e most easily resolved with
a rebuild (reinstall). Consider it an opportunity to improve the worksheet
with better functions available more clear layout & formatting.
On Sat, Feb 4, 2017 at 9:48 PM, John R. Sowden <jsow...@americansentry.net>
wrote:
Why has my message regarding a &quo
I had this problem years ago, and wrote to the list for help. The
solution was to create a separate empty spreadsheet, (and a write
document?), then convert? it to a template, and label it somehow, in
order to set the default font and size. The Elephant in this Room is:
These two settings
GMT-0500 (Eastern Standard Time), John R.
Sowden <jsow...@americansentry.net> wrote:
Haven't tested by turning autocalc back on.
Why not?
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsub
1 - 100 of 131 matches
Mail list logo