h the matrixafter a re-calculation. I was not
questioning Brian's answer, I just want to examine his answer more
closely by setting up a true/false table similar to Brian's.
sorry for the confusion.
TomW
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? h
find the address of the Max value. If there are
duplicate values it shows the last location.
=ADDRESS(MAX((A1:C2=MAX(A1:C2))*ROW(A1:C2)),MAX((A1:C2 =
MAX(A1:C2))*COLUMN(A1:C2)),4)
This is an array function and you need to use Ctrl-Shift-Enter instead
of Enter.
Hope this works for you,
the file will open in 4.4.0.
TomW
--
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.libreof
, hope it helps.
Best regards
Xbot:
I found that if I saved your file in Calc as an ods, the err:509 would
go away.
I then re-saved as the xlsx file and still did not get the Err:509.
I do not know if anything in the file is lost during the file type changes.
TomW
--
To unsubscr
p://presentationsoft.about.com/od/powerpointadvanced/a/package_hub.htm
http://office.microsoft.com/en-us/powerpoint-help/package-a-presentation-for-cd-HA010336719.aspx
/
TomW
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/ma
ion 3.6.7.2 (Build ID: e183d5b), Version: 4.2.4.2
Build ID: 63150712c6d317d27ce2db16eb94c2f3d7b699f8 and Version:
4.3.0.0.beta2 Build ID: a06aa316117a6ff0f05c697c82831c227812d810, all on
Vista.
Sincerely,
TomW
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http:
On 2014-01-01 10:49, TomW wrote:
On 2014-01-01 06:22, IGraham wrote:
Hello and a happy new year
Calc, paste special, transpose and link
I've done this before but can't get it to work again - I'm blaming
the brain
cells
In one spreadsheet I select a range of vertical cells a
w sheet.
Vista Home Premium LibreOffice Portable Version: 4.1.4.2
Vista Home Premium LibreOffice RC1 Version: 4.2.0.1
TomW
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Po
s displacement should not even happen,
specially with "AutoRefresh" (traces) set on, but I guess this is why
the "Refresh Traces" action exists(?).
Is this happening just in my system?
TIA,
Ady.
Ady;
Same behavior in 4.0.6 LibreOffice on WinXP, and 4.1.2.3 LibreOffice
s rtf correctly.
Save rtf file as odt with Version 4.1.1.2: File layout is mangled in
either version.
Save rtf file as odt with LibreOffice 3.5.5.2: Opens correctly with 4.1.1.2
TomW
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get
te extension, and unless the
End Note extension is installed, LO does not recognize the field in
question. This makes it un-editable.
TomW
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lis
to try truncating data using a text editor on
the original file.
TomW
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundati
o "Warrant Market"
Any comments?
Cheers
Tim:
Thexls files are XML files with an xls file extension. Amaya, a
xmleditor, bloats to nearly a 1 gig of memory, when this file is opened.
TomW
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffic
licly archived and cannot be
deleted
At the bottom of your list enter some text to use a place holder. e.g
'---
When you need to add a new entry, select the dummy entry and insert a
cell to shift the list down. This will keep LO from crashing.
TomW (Crashes using the portable versi
said above, and I got all the results.
Sincerely,
Taang Zomi
To All:
What I found on my LibreOffice 3.5.5.2 (vista): lower case fn did not
work(error like OP), upper case FN does work. In calling up the
autotext dialog, then selecting 'formula numbering', the dis
|Options|Fonts, you can use font substitution to change the
"Courier New 10 pt" font to a different font. FYI: This will impact any
other documents that use the "Courier New" font that may not be plain
text files.
Maybe this helps,
TomW
--
For unsubscribe inst
$D$2:$D$1001>=$P2)*($D$2:$D$1001<$Q2),$H$2:$H$1001))}
TomW
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
bscure. Other obscure words include
"ninnyhammer" and "flibbertigibbet" which I've only just learned.
Andrew:
Try googling for the following, starting on page 23.
Bookbinding and Its Auxiliary Branches: Punching, crimping, cycletting ...
By John J. Pleger
TomW
--
For unsu
uration of two monitors, one to the
right of the other.
(sigh)
Maybe 3.6 will solve this
MR
+
MR:
Link to old versions.
http://download.documentfoundation.org/libreoffice/
TomW
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.or
t be listed in the
'META-INF/manifest.xml' file as it does not exist in the ODF package
'doctest.odt'!
doctest.odt: Info: Generator: OpenOffice.org/2.0$Linux
OpenOffice.org_project/680m1$Build-8990
Save
ybe a dev could chime in and let us know why the "QuickStart"
is not on the Linux version of LibreOffice?
Cheers,
Marc
Hello:
On Windows one must do a custom install to include the Quickstarter.
TomW
--
For unsubscribe instructions e-mail to: users+h...@global.libre
On 2012-02-01 06:33, Tanstaafl wrote:
On 2012-01-31 6:19 PM, TomW wrote:
On 2012-01-31 06:42, Tanstaafl wrote:
On 2012-01-30 3:36 PM, Cor Nouws wrote:
I tried in 3.4.5 and it works there fine too. Ctrl-V creates a nice
Impress-table with the content that I copy from Calc.
But... we don&#
staafl:
OOo 2.4.2 pastes as a calc8 file by default.
OOo 3.2.1 pastes as table of cells by default.
All on Vista (No rocks please)
TomW
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
P
On 2012-01-15 10:24, Tanstaafl wrote:
On 2012-01-13 5:17 PM, TomW wrote:
Both 3.4.4 and 3.5.0beta3, on Vista, will paste a table of the selected
Calc cells without using Paste Special.
Well, since I wouldn't touch Vista with a ten foot pole, I don't care
if it works with Vista
3.4.4 on Windows 7 64 bit...
Both 3.4.4 and 3.5.0beta3, on Vista, will paste a table of the selected
Calc cells without using Paste Special.
TomW
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to
08p3601508.html
Sent from the Users mailing list archive at Nabble.com.
TinKicker:
I just did a test on my Vista system by setting a very short
auto-save(auto recovery) time. The path for my system is
C:\Users\TomW\AppData\Roaming\LibreOffice\3\user\backup on my system.
When you close th
by columns. From your example, you can
filter Col A for 'a' or 'A', then filter Col B and filter the data for
either 'hx' or 'hy'.
This will only show the rows of data that match your filter criteria.
If you use the 'Standard Filter', you can s
this message in context:
http://nabble.documentfoundation.org/Re-border-frames-tp3573496p3573496.html
Sent from the Users mailing list archive at Nabble.com.
Check to see if "text boundaries" is checked in the 'View' menu
drop-down list.
TomW
--
For unsubscribe instru
.
Insert
|Fields
|Other
|DocInformation
|Modified
|Date
To test it, I also added the time field. Each time I saved it, it would
adjust to the time it was saved.
TomW
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help
d graphics that were first inserted as links, go to *Edit -
Links* and click the *Break Link* button.
4.
Click *Open* to insert the image."
You can change the picture from the menu Edit|Links
or
In the Picture properties dialog, select the Picture Tab, there you can
change the p
allow it.
Strangely enough I could get your code to work in Excel with the correct usage
of the ReDim (minus the ReDim y variable), but could not get it to work in
LibreOffice. Ran out of time as it is way past my bedtime.
TomW
--
For unsubscribe instructions e-mail to: users+h...@global.libreof
l may applicable for your
needs.
"If you don’t have a previous FileMaker Pro application with which to do
the conversion, you can download a trial version of FileMaker Pro 6 from
www.filemaker.com and use it to convert files."
TomW
--
Unsubscribe instructions: E-
: Wd004.doc in my temp
folder.
This scenario seems familiar from the OOo lists.
TomW
--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All
feature you are looking for, but this menu section offered
some other options.
TomW
--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messag
libreoffice-3.3.1.2
will open MS Works 9.0 wps files.
TomW
--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be
On 2011-02-26 13:17, Sebastian G. wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Can fields and their input list be added globally?
This applies to Writer.
With "Insert> Fields" it is possible to add a field that contains a
list of possible selections.
Like a field with name "Level" an
On 2011-02-22 12:33, Zhehao Mao wrote:
Is there a way to convert an OLE Chart to a Bitmap in Libreoffice? I am
working on an assignment with a classmate who uses Microsoft Word, and I
know that OLE objects don't carry over from odt to docx.
Zhehao:
The only way I found to do this.
Copy t
Put 'z' in C2, then remove it
The vlookup in B2 works again!
Phil Hibbs.
Phil:
I get the same result using OOo 3.2.1 on Vista Sp2. (Substituting 65536
as the last row)
Delete a row the result is blank. (MRI Inspection Tool shows a value of 0.0)
Enter 'z' in C2 and it
38 matches
Mail list logo
