[libreoffice-users] Re: Malware in latest Win x64 download

Three weeks ago I reported what I supposed was a false positive to Avira antivirus about LibreOffice development versions, it was accepted as false positive and solved on a few days. Miguel Ángel -- View this message in context:

[libreoffice-users] Re: Copy-Paste(special) times in Calc.

There is a way. After select and copy, click on the right arrow of the paste icon and select paste as Unformatted text or Formatted text [RTF] Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/Copy-Paste-special-times-in-Calc-tp4211360p4211366.html Sent

[libreoffice-users] Re: Calc - blank cell not treated as 0 in formula when referenced from external file/sheet

Set up references as relative path is on: Menu/Tools/Options/LibreOffice/Load-Save/General Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/Calc-blank-cell-not-treated-as-0-in-formula-when-referenced-from-external-file-sheet-tp4205236p4205612.html Sent from

[libreoffice-users] Re: Calc - blank cell not treated as 0 in formula when referenced from external file/sheet

Please could you share sample files to test? Miguel Ángel -- View this message in context: http://nabble.documentfoundation.org/Calc-blank-cell-not-treated-as-0-in-formula-when-referenced-from-external-file-sheet-tp4205236p4205510.html Sent from the Users mailing list archive at Nabble.com.

[libreoffice-users] Re: Another LO anti-feature

There is a bug report tdf#92160 - sc: limit search results to 1000 entries. I think it should be on the last 5.2.4.2 released version. Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/Another-LO-anti-feature-tp4203317p4203337.html Sent from the Users

[libreoffice-users] Re: Slow response time with Calc

Perhaps in relation with: https://bugs.documentfoundation.org/show_bug.cgi?id=71409 Test with Menu/Tools/Options/LibreOffice/Accessibility - Support assistive disable. Miguel Ángel. -- View this message in context:

[libreoffice-users] Re: PDF file size bigger in 5.2.4

I guess with the same settings, specially those in relation with images size. The export button use the settings on Menu/File/Export as pdf. Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/PDF-file-size-bigger-in-5-2-4-tp4201989p4202099.html Sent from the

[libreoffice-users] Re: Libra Office and MS Word compatibility query

Since LibreOffice 5.0 can be opened page files https://wiki.documentfoundation.org/ReleaseNotes/5.0#New_import_filters but don't expect warranties about everything will be perfect. Every time that a file is converted, increase the options for issues, as LibreOffice is available for Mac, IMO

[libreoffice-users] Re: Observations on LO v5.2.1.2

. >One reason I delayed updating is what I read with regard to v4 -- the >icons in the menu bars are terrible! Way too large, as is the bar at >the bottom with the "Find" window, which I can't find a way to get rid of. ?

[libreoffice-users] Re: COUNTIFS with cells of yyyy-mm-dd

Or =SUMPRODUCT(YEAR(A1:A50)=2011) Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/COUNTIFS-with-cells-of--mm-dd-tp4195901p4196282.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to:

[libreoffice-users] Re: limited undo.

Since 5.1 undo step are available only into the expert configuration Menu/Tools/Options/LibreOffice/Advanced - TOpen expert configuration. Verify if steps value is enough, default value is 100. -- View this message in context:

[libreoffice-users] Re: sumifs() with wildcard question

You need to wait a couple of months for the next release 5.2, it implements the option to use regular expressions or wildcard. https://wiki.documentfoundation.org/ReleaseNotes/5.2#Support_wildcards_to_be_compatible_with_XLS.2FXLSX_and_with_ODF_1.2 Miguel Ángel. -- View this message in

[libreoffice-users] Re: copying down references to other cells turns text to UPPERCASE

Hi Thomas, Menu/Tools/Options/LibreOffice/OpenCL Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/copying-down-references-to-other-cells-turns-text-to-UPPERCASE-tp4184881p4185005.html Sent from the Users mailing list archive at Nabble.com. -- To

[libreoffice-users] Re: copying down references to other cells turns text to UPPERCASE

I can't reproduce with Version: 5.2.0.0.alpha1+ But as it happens from row 100 looks as an OpenCL issue, please test disabling it: Menu/Tools/Options/LibreOffice/OpenCL The number 100 is set up in: Menu/Tools/Options/LibreOffice calc/Formula - Custom Miguel Ángel. -- View this message in

[libreoffice-users] Re: function sumif question

As SUMIF takes advantage of regular expressions, you can use the 'or' operator in them '|' =SUMIF(A2:A4;"1234|2345|6789";B2:B4) Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/function-sumif-question-tp4181679p4181680.html Sent from the Users mailing list

[libreoffice-users] Re: Dynamic Validation List

Hi Joel, find attached a sample file, I hope it is what you want. To avoid duplicates in the list it`s needed to mark 'Sort entries ascending' Be aware of Menu/Tools/Options/LibreOffice calc/General - Expand formatting, if it is activated, when selecting in A1, then A1 DataValidaty overwrite

[libreoffice-users] Re: Problem with Document- Bad Behavior

Not reproducible. Win10x64 LibreOffice Version: 5.0.5.1 (x64) Please test if disable or enable OpenGl in Menu/Tools/Options/LibreOffice /View has some effect. And increase at least up to 48 Mb the option in Menu/Tools/Options/LibreOffice/Memory/Graphics cache/Use for LibreOffice?. If nothing

[libreoffice-users] Re: 5.0.5.1 and 5.1.0.3 crashes easily on Windows (10, 1511 build, 64 bit)

Please try resetting the user profile, sometimes solves strange issues. https://wiki.documentfoundation.org/UserProfile Usually it's enough renaming/deleting the file "user/registrymodifications.xcu", it affect all the options in Menu/Tools/Options, and the files "user/basic/dialog.xlc" and

[libreoffice-users] Re: COUNTIF() with more than one conditions

Or if you have active regular expression (Menu/Tools/Options/LibreOffice calc/Calculation) =COUNTIF(C152:C228;"=H|K|Sze|Cs|P") Inner help. |Finds the terms that occur before the "|" and also finds the terms that occur after the "|". For example, "this|that" finds "this" and "that". Miguel

[libreoffice-users] Re: difference between Excel and Calc

Yes there are two Tom Menu/Tools/Options/LibreOffice calc/Formula - Formula Options - Formula syntax. and another one in Menu/Tools/Options/LibreOffice calc/Formula - Detailed calculation settings - Custom - Details - Reference syntax. Miguel Ángel. -- View this message in context:

[libreoffice-users] Re: R1C1 reference style with LibreOffice

You can select it for the spreadsheet in: Menu/Tools/Options/LibreOffice calc/Formula - Formula Options - Formula syntax Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/R1C1-reference-style-with-LibreOffice-tp4172305p4172334.html Sent from the Users

[libreoffice-users] Re: Sorting table (Writer) with months or days

Adding hidden character/numbers or with background color (optionally with a minimum size) at the beginning of the words. Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/Sorting-table-Writer-with-months-or-days-tp4170240p4170244.html Sent from the Users

[libreoffice-users] Re: Win 10

All LibreOffice versions run in Win10, since the first "LibreOffice 3.3.4 " up to Master, without the need for set up any kind of compatibility. I have more than a dozen installed, usually the people issues are about rights on the system, but running the install file as administrator should solve

[libreoffice-users] Re: TRANLATION FOR LIBREOFFICE

Here you have a link to an extension: http://extensions.libreoffice.org/extension-center/tradutorlibretext Please @giancarlo Writing in all caps is like shouting -- View this message in context:

[libreoffice-users] Re: LibreOffice 4.4, 5.0 : firefox personas not work with path url...why?

I think would be better revert to the previous version. Maybe not so beautifully but more useful, simple and practical. Could it be possible? Miguel Ángel. -- View this message in context:

[libreoffice-users] Re: LibreOffice 4.4, 5.0 : firefox personas not work with path url...why?

Sorry, Manuel, sure I didn't explain right. I didn't ask you on return to a previous version. I was wondering about revert the change in the program. Regards. Miguel Ángel. -- View this message in context:

[libreoffice-users] Re: Calc 5.0.3.2 AutoCalculate

Hi James, sorry but I think not a good news. https://bugs.documentfoundation.org/show_bug.cgi?id=56896 https://bugs.documentfoundation.org/show_bug.cgi?id=92664 Maybe the problem is in relation with your formulas in the conditional format, using functions inside CF makes it very slow. I think

[libreoffice-users] Re: Large spreadsheet does not open in LibreOffice.

Sometimes people select the whole sheet to apply a direct format, cleaning direct formatting, at least out of data range could helps a lot, because seems LibreOffice doesn't like it too much. Miguel Ángel. -- View this message in context:

[libreoffice-users] Re: Fwd: Need a count formula for calc

I think for not take care of the number of blank cells, it's easier and versatile with SUMPRODUCT() =SUMPRODUCT($A$2:$A$12>$B$2:$B$12;$A$2:$A$12>0;$B$2:$B$12>0) Attached a sample file. Miguel Ángel. -- View this message in context:

[libreoffice-users] Re: Upload a picture to http://ask.libreoffice.org

Hi Regina, I have uploaded some images, this weekend, without problem, but I remember have had this kind of trouble some times, I think can happen when changing between comment and answer and vice versa. Miguel Ángel. -- View this message in context:

[libreoffice-users] Re: Preventing the display of #VALUE! in a spreadsheet

There are a couple of options about how to treat strings in formulas. Menu/Tools/Options/LibreOffice calc/Formula - Detailed calculation settings - Custom Miguel Ángel. -- View this message in context:

[libreoffice-users] Re: LO Writer and regex - finding everything but one thing

Hi @gordon, I hope this is what you are looking for. p(?!.*topic.*).*lt;\/p finds paragraph with 'p' tag without 'topic¡ inside. (?!.*topic.*).* does the exclusion. A good place to text regex: https://regex101.com/ Miguel Ángel.

[libreoffice-users] Re: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?

I think Piet have pointed to the source of the problem. Seems in several sheet there are cells formatted out data range. Sheet 'Análisis Pisos' seems empty but has a lot of empty comments, better delete the sheet. For a first cleaning, to do in every sheet: - Ctrl+End goes to bottom-right

[libreoffice-users] Re: Font versus Character Substitution

If it's really not possible to mix languages in the same paragraph, then it's strange that Character Styles have the option to select font languages for Asian and CTL. Sorry if this have no sense, I have never used Asian or CTL languages. Miguel Ángel -- View this message in context:

[libreoffice-users] Re: converting txt to dates

If DATEVALUE(A2) is giving an error, maybe there is something else in the cell, or you are using English-US as language then it is an invalid date, month=14? You can also try with Menu/Data/Text to column after select the data, click on column head and select in column type the day type. Miguel

[libreoffice-users] Re: Is This Possible In Calc?

Not from other but you can do it directly in C20. C20: =formula + IF(B1=10;STYLE(whatever);0) LibreOffice help: STYLE function https://help.libreoffice.org/Calc/Spreadsheet_Functions#STYLE -- View this message in context:

[libreoffice-users] Re: Estimating size of page with Calc

Hi Marc, I think not so complicated :-), calc has page styles applicable individually for every sheet. - [F11] styles and formatting. - Select page styles (second icon) - Create a new page style (right-clic on one style - New) . - In the Page tab, select the paper size. - In the Sheet tab -

[libreoffice-users] Re: Feature Request for Calc - input forms and reports

If I am not wrong this extension was incorporated in calc, being accessible in Menu/Data/Form. Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/Feature-Request-for-Calc-input-forms-and-reports-tp4119629p4119780.html Sent from the Users mailing list archive

[libreoffice-users] Re: Defined name CRLF(Newline) cell in Excel cannot be correctly imported

Hi @katsum, works for me as I think it must be expected, with: Win7x64, LibreOffice 4.2.6.5 / 4.2.7.2 / 4.3.0.4 / 4.3.1.0.0+ / 4.4.0.0.alpha0+ I don't remember any option to change this behavior, but maybe there is any. Try resetting the User Profile

[libreoffice-users] Re: Defined name CRLF(Newline) cell in Excel cannot be correctly imported

Good, that you have found a solution. And thanks for share it. Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/Defined-name-CRLF-Newline-cell-in-Excel-cannot-be-correctly-imported-tp4118441p4118470.html Sent from the Users mailing list archive at

[libreoffice-users] Re: Currently Using Spreadsheet for Personal Project - Thinking About Database

Hi Joel, please don't think in reading the documentation like wasted time but an invested time. It can really help to learn the basis, which I'm sure will be useful for ever, specially what is learned about SQL. And IMO without at least a quick read not easy even to ask for help. With the

[libreoffice-users] Re: SumIF / SumProduct question

Why not: =SUMPRODUCT($O$2:$O$131=x,$AU$2:$AU$131=Dk Blue, $AW$2:$AW$131) the function multiply the values for every argument, if a condition is true their result is 1, what implies if both are true= 1 * 1 * AWvalue and this result is added. and depends on your version you can do it: =SUMIFS(

[libreoffice-users] Re: Calc function to return the daynumber weeknumber of the year

For weeks they have been always in LibreOffice: WEEKNUM( ) returns ISO 8601 week numbers. WEEKNUM_ADD( ) returns week number as excel. For days: =DAYS(TODAY();DATE(YEAR(TODAY());1;1)-1) I think the best way to find calc functions it's through function wizard:

[libreoffice-users] Re: Problem with Export as PDF

Hi Pat, location for user profile is detailed in: https://wiki.documentfoundation.org/UserProfile about your issue: select what export seems incompatible with the option for Embed OpenDocument file, maybe a bug. Miguel Ángel. -- View this message in context:

[libreoffice-users] Re: Compatibility issue opening an .xlsx file with calc: Err:509

Hi Eric, I think the problem is with what I guess are the table fields, not supported by LibreOffice, as range of named ranges. http://nabble.documentfoundation.org/file/n4114219/Captura.png Miguel Ángel -- View this message in context:

Re: Request for review: (Re: [libreoffice-users] Re: crash - crash - crash - crash. !@#$#@!)

+1 Virgil There is no worse contempt that not to do appreciation. Miguel Ángel -- View this message in context: http://nabble.documentfoundation.org/crash-crash-crash-crash-tp4106932p4107580.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to:

[libreoffice-users] Re: Inserting DRAW file as linked OLE in WRITER file?

Hi, perhaps I am wrong, but I think a good way to have more control, it's insert a new draw OLE object in the document Menu/Insert/Object/OLE object - create new - LibreOffice Drawing. The new draw object is embedded in the document, no external draw file, you can insert/paste images in it and use

[libreoffice-users] Re: Default Date Format in Libreoffice Calc

You are right about calc, I thought that I had verified it, but it's clear not properly. The format used is the locale in which the file is open, not the locale in what the file was created. At least is how it works for me, saving in 4.1 Spanish local and opening in 4.2 locale English USA.

[libreoffice-users] Re: Default Date Format in Libreoffice Calc

Hi Ralph, double click the field, selecting additional format you can choose the language for date field. http://nabble.documentfoundation.org/file/n4100577/Captura.png -- View this message in context:

[libreoffice-users] Re: Default Date Format in Libreoffice Calc

Sorry Ralph I confuse the application. For calc editing the header select the field and the button for change Font, there you can select the language. http://nabble.documentfoundation.org/file/n4100583/Captura.png -- View this message in context: