[libreoffice-users] Trying to make a macro

[jorge]

Good evening:

I try to make a macro in Calc to insert a sheet from a file in .txt
format or .csv using the LO process: Record macro.

I did it but the macro run and stop in the directory where the file is,
but not record the select and not open the sheet although I did when I
recorded the macro.

The code that the process wrotten is this, would you please guide me to
finish:

REM  *  BASIC  *

sub Main
rem
--
rem define variables
dim document   as object
dim dispatcher as object
rem
--
rem get access to the document
document   = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")

rem
--
rem dispatcher.executeDispatch(document, ".uno:InsertSheetFromFile", "",
0, Array())

end sub

I use LibreOffice version 4.2.8.2 on Ubuntu 14.04 LTS


Thanks and Regards,

-- 
Atentamente,

Jorge Rodríguez


-- 
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] Re: Time Calculations in LOBase

[Don Parris]

Many thanks to Robert and Bruce.  I will try this as I have time over the
weekend, and report back how it goes.

On Thu, Aug 25, 2016 at 7:15 PM, Bruce Hohl  wrote:

> I can confirm as follows.
>
> With this in table1:
> ID time1 time2
> 1 01/01/16 11:30 PM 01/02/16 04:00 AM
> 2 01/02/16 01:30 AM 01/02/16 05:30 AM
> This query:
> SELECT "time1", "time2", DATEDIFF( 'minute', "time1", "time2" ) AS
> "diff_minutes", DATEDIFF( 'minute', "time1", "time2" ) / 60.00 AS
> "diff_hours" FROM "Table1"
>
> Returns:
> time1 time2 diff_minutes diff_hours
> 01/01/16 11:30 PM 01/02/16 04:00 AM 270 4.5
> 01/02/16 01:30 AM 01/02/16 05:30 AM 240 4
> This might be helpful:
> http://hsqldb.org/doc/guide/builtinfunctions-chapt.html#bfc_
> datetime_functions
>
> Be mindful of appropriate use of HSQLDB embedded:
> https://wiki.openoffice.org/wiki/FAQ_(Base)
>
>
> On Thu, Aug 25, 2016 at 3:29 PM, Robert Großkopf <
> rob...@familiegrosskopf.de> wrote:
>
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> Hi Don,
>>
>> > It occurs to me my OP may not have been as clear as it should be.
>> > To clarify, I need to calculate the decimal value of the times
>> > involved: (([day_end]-[day_start])-([lunch_end]-[lunch_start])) =
>> > H.nn worked
>> >
>> > So, for example: ((17:00-08:00)-(13:00-12:00)) = 8.0
>>
>> This one works:
>> SELECT "ID", "DayBegin", "DayEnd", "LunchBegin", "LunchEnd",
>> DATEDIFF('hh',"DayBegin", "DayEnd")-DATEDIFF('hh',"LunchBegin",
>> "LunchEnd") AS "Worked" FROM "Times"
>>
>> Examples I have written down in Base-Handbook. But the newer versions
>> aren't translated yet from German to English.
>>
>> Be careful with the example. It does only work with the value for the
>> hour. So you get the same with
>> (17:00-08:00)-(13:00-12:00)
>> and for example
>> (17:10-08:00)-(13:00-12:00)
>>
>> So it would be better to write down the same code for minutes:
>> SELECT "ID", "DayBegin", "DayEnd", "LunchBegin", "LunchEnd",
>> DATEDIFF('mi',"DayBegin", "DayEnd")-DATEDIFF('mi',"LunchBegin",
>> "LunchEnd") AS "Worked" FROM "Times"
>>
>> So you get the workingtime in minutes. Devide it with 60.00 (.00 for
>> the decimal places) and you get a better diff for hours than in the
>> first query.
>>
>> Regards
>>
>> Robert
>> -BEGIN PGP SIGNATURE-
>> Version: GnuPG v2
>>
>> iQIcBAEBAgAGBQJXv0czAAoJELDKYwaoS9AI28IQAKRBFUlzHX28fOBjp+pAGWeH
>> 9JnaNSJl0ao2bC1uKjpgI7dN/osbmA6Muj99RIdSpict6goXu+zIKNLTlzw/wSeO
>> 6w3Xvk3HD/sr4ow4BTQV/2n8A05dHKsIaZnYB8YCjz6d7XEzwxdEyca2zM+3U9KU
>> LuKNhvbPNpzzPq41p2dAWk8gA99fKEhhFpefsCk8FyW7d1+Rr/+DcqrYn+hY/qRo
>> UVuNpxr0EOZT4Qa2/c5uXE9DPmKnjo2Q93rvrL1ROO3Xj/Tzi5JexDPaQ4f52YsI
>> FXHQ6g7PxzDKM5NZ0pKlRlcJqg/9Sv01v75PuuQM9+Sq56LQpImyk99GTO0sJbsM
>> Hu3bwnHzEy3Up+au0Ra7jJ/cPkkXdgrJYQUUZJ32CSWlaiFQK9PizsfnzlA4OWRn
>> 6s9O1F3zoDhs50dsERsgLYn4oN0AfFocR4Np9jVPBgYKzhe2yhdem3nZjFwqCjeY
>> z1L+sNtu6zTikqrGBem8+U14Ti7ogLRdF7pe7X4ONvYAiYP3PXd5DoOcFwr8MRVg
>> 4BybEk8pOYzzzeGzrTKaJFA1ECQy/l8B0mS4CzKHlDeA5t9WxnuIr3TiCO0KaHya
>> eTwdyxA5Mhv82t+Egptb/MP2kLArO9trHakM02QkbL64A3g1qlo8CIAzAudu9QrC
>> KG5LqIEUIeMows6DOgKq
>> =49Q8
>> -END PGP SIGNATURE-
>>
>> --
>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
>> ubscribe/
>> 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
>>
>
>


-- 
D.C. Parris, FMP, Linux+, ESL Certificate
Minister, Security/FM Coordinator, Free Software Advocate
http://dcparris.net/ 

GPG Key ID: F5E179BE

-- 
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] Save button

[Virgil Arrington]

I should have clarified that is with the Gnome desktop. When using the 
Unity desktop, I see a small red dot on the save icon. Either way, the 
save icon changes when a change is made to a document.


Virgil


On 08/26/2016 03:12 PM, Virgil Arrington wrote:
On my system, Ubuntu 16.04 and LO 5.1.5.2, the save button doesn't get 
greyed out, but when I make a change to the file, a yellow starburst 
appears on the disk image in the save button. It's not as obvious as a 
greyed out icon, but, once learned, it is noticeable.


Virgil


On 08/26/2016 02:19 PM, CLOSE Dave wrote:

In the past, when I saved a document and hadn't yet made additional
changes, the "save" button was grayed out. This let me know that I had
done the save and avoided doing so redundantly. With the most recent
versions (I have 5.1.5.2-3 for Fedora 24), that doesn't seem to be true
any more. Why not? Can this be fixed?






--
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] Overly aggressive autofomatting issues in LibreOffice

[James Knott]

On 08/26/2016 04:15 PM, Steve Edmonds wrote:
>> Maybe write a user guide: _Abusing Calc: How to do things without
>> totally destroying your data, when using Calc for that for which it is
>> neither designed to do, nor is suitable for_:
>> * Two chapters on using Calc as a text editor;
>> * Three chapters on using Calc as a database;
>> * Two chapters on using Calc as a drawing program;
>>
>> jonathon
> And don't forget calc as a photo album.
>

Someone I knew used Excel to create a road map!


-- 
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] Overly aggressive autofomatting issues in LibreOffice

[Steve Edmonds]

On 2016-08-27 06:23, toki wrote:

On 26/08/2016 14:13, M Henri Day wrote:


- while dealing more specifically with Microsoft's Excel, should, as noted
in the next-to-last paragraph, give even LibreOffice developers pause. If
the claim that LibreOffice behaves like Microsoft Office in this particular

a)The actual research paper is:
  Gene name errors are widespread in the scientific literature
 Mark Ziemann,
 Yotam Eren and
 Assam El-OstaEmail author
Genome Biology201617:177
DOI: 10.1186/s13059-016-1044-7
© The Author(s). 2016
Published: 23 August 2016

Downloadable from
http://genomebiology.biomedcentral.com/articles/10.1186/s13059-016-1044-7

b) Issues with gene researchers using Excel were noted as long as 1999,
with the Human Gene Project. (Researchers are still correcting errors
made by that project, because of their over-reliance on Excel, instead
of using a real database.)

c) Ignoring the issue of using the wrong tool for the job, the majority
of errors are a direct result of the researchers not knowing how to
correctly use the tool that they were using. What doesn't help matters,
is that the researchers don't realise they are having problems, until
after the fact.


some attention should be devoted to making turning off autoformatting

in Calc easier for users

Should people be encouraged to use Calc for a task for which it is
neither designed, nor suitable for, rather than using Base, which is
designed to be a database?

Maybe write a user guide: _Abusing Calc: How to do things without
totally destroying your data, when using Calc for that for which it is
neither designed to do, nor is suitable for_:
* Two chapters on using Calc as a text editor;
* Three chapters on using Calc as a database;
* Two chapters on using Calc as a drawing program;

jonathon

And don't forget calc as a photo album.

--
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] Save button

[Virgil Arrington]

On my system, Ubuntu 16.04 and LO 5.1.5.2, the save button doesn't get 
greyed out, but when I make a change to the file, a yellow starburst 
appears on the disk image in the save button. It's not as obvious as a 
greyed out icon, but, once learned, it is noticeable.


Virgil


On 08/26/2016 02:19 PM, CLOSE Dave wrote:

In the past, when I saved a document and hadn't yet made additional
changes, the "save" button was grayed out. This let me know that I had
done the save and avoided doing so redundantly. With the most recent
versions (I have 5.1.5.2-3 for Fedora 24), that doesn't seem to be true
any more. Why not? Can this be fixed?



--
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] Save button

[Brian Barker]

At 11:19 26/08/2016 -0700, Dave Close wrote:
In the past, when I saved a document and hadn't yet made additional 
changes, the "save" button was grayed out. This let me know that I 
had done the save and avoided doing so redundantly. With the most 
recent versions (I have 5.1.5.2-3 for Fedora 24), that doesn't seem 
to be true any more. Why not?


See
https://cgit.freedesktop.org/libreoffice/core/commit/?id=22328a224df4619218b88205838307f70612207e 
. Apparently the Save button is always enabled in order to provide 
access to the (new) associated drop-down. The document modification 
status is shown instead by a differentiated Save button icon, which I 
think you can see at

https://i.ytimg.com/vi/LrWPfWSuLSA/maxresdefault.jpg .


Can this be fixed?


You mean "configured"? Apparently not;
https://wiki.documentfoundation.org/ReleaseNotes/5.1 says "Removed 
/org.openoffice.Office.Common/Misc/AlwaysAllowSave. Saving is now 
always allowed."


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] Overly aggressive autofomatting issues in LibreOffice

[Joe Conner]

+1 ;-)

On 08/26/2016 11:23 AM, toki wrote:

<>


in Calc easier for users Should people be encouraged to use Calc for a 
task for which it is neither designed, nor suitable for, rather than 
using Base, which is designed to be a database? 


Maybe write a user guide: _Abusing Calc: How to do things without 
totally destroying your data, when using Calc for that for which it is 
neither designed to do, nor is suitable for_: * Two chapters on using 
Calc as a text editor; * Three chapters on using Calc as a database; * 
Two chapters on using Calc as a drawing program; jonathon 


--
Blessings, Joe Conner
Joshua 24:15 "...as for me and my house, we will serve the LORD."


--
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] Overly aggressive autofomatting issues in LibreOffice

[toki]

On 26/08/2016 14:13, M Henri Day wrote:

> - while dealing more specifically with Microsoft's Excel, should, as noted
> in the next-to-last paragraph, give even LibreOffice developers pause. If
> the claim that LibreOffice behaves like Microsoft Office in this particular

a)The actual research paper is:
 Gene name errors are widespread in the scientific literature
Mark Ziemann,
Yotam Eren and
Assam El-OstaEmail author
Genome Biology201617:177
DOI: 10.1186/s13059-016-1044-7
© The Author(s). 2016
Published: 23 August 2016

Downloadable from
http://genomebiology.biomedcentral.com/articles/10.1186/s13059-016-1044-7

b) Issues with gene researchers using Excel were noted as long as 1999,
with the Human Gene Project. (Researchers are still correcting errors
made by that project, because of their over-reliance on Excel, instead
of using a real database.)

c) Ignoring the issue of using the wrong tool for the job, the majority
of errors are a direct result of the researchers not knowing how to
correctly use the tool that they were using. What doesn't help matters,
is that the researchers don't realise they are having problems, until
after the fact.

>some attention should be devoted to making turning off autoformatting
in Calc easier for users

Should people be encouraged to use Calc for a task for which it is
neither designed, nor suitable for, rather than using Base, which is
designed to be a database?

Maybe write a user guide: _Abusing Calc: How to do things without
totally destroying your data, when using Calc for that for which it is
neither designed to do, nor is suitable for_:
* Two chapters on using Calc as a text editor;
* Three chapters on using Calc as a database;
* Two chapters on using Calc as a drawing program;

jonathon




-- 
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] Save button

[CLOSE Dave]

In the past, when I saved a document and hadn't yet made additional 
changes, the "save" button was grayed out. This let me know that I had 
done the save and avoided doing so redundantly. With the most recent 
versions (I have 5.1.5.2-3 for Fedora 24), that doesn't seem to be true 
any more. Why not? Can this be fixed?
-- 
Dave Close
-- 
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: dsum

[Istvan Toth]

I thank her answer immediately, I am studying the notified Help Kit
ti


On 08/26/2016 05:00 PM, Bruce Hohl [via Document Foundation Mail 
Archive] wrote:
> There is an example in the installable help at:
> Help > LibreOffice Help
> Contents tab > Spreadsheets > Functions Types and Operators > Database
> Functions
>
> I just checked and that example works.
>
> On Fri, Aug 26, 2016 at 2:25 AM, Istvan Toth <[hidden email] 
> > wrote:
>
> > Guten Morgen,
> > ich kann die dsum Function nicht richtig Parameter geben, immer kann 
> ich
> > Fehler bekomman,
> > Was kann ich nicht richtig eingeben?
> > Mfg
> > ti
> >
> >
> >
> > --
> > View this message in context: http://nabble.documentfoundation.org/dsum-
> > tp4191752.html
> > Sent from the Users mailing list archive at Nabble.com.
> >
> > --
> > To unsubscribe e-mail to: [hidden email] 
> 
> > 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: [hidden email] 
> 
> 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
>
>
> 
> If you reply to this email, your message will be added to the 
> discussion below:
> http://nabble.documentfoundation.org/dsum-tp4191752p4191798.html
> To unsubscribe from dsum, click here 
> .
> NAML 
> 
>  
>





--
View this message in context: 
http://nabble.documentfoundation.org/dsum-tp4191752p4191819.html
Sent from the Users mailing list archive at Nabble.com.
-- 
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] Overly aggressive autofomatting issues in LibreOffice

[Wade Smart]

--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005


On Fri, Aug 26, 2016 at 10:58 AM, M Henri Day  wrote:
> 2016-08-26 17:31 GMT+02:00 Wade Smart :
>>
>> > I tried - and a popup appers to write down my mailadress and register.
>> > Couldn't read the text in background.
>> >
>> > Regards
>> >
>> > Robert
>>
>> This is what I saw as well.
>
>
> We seem to be discussing an entirely different issue from that which I
> originally proposed. I hope Cristopher Ingraham will regard it as fair use
> if I reproduce the content of the article below
> :
>
> «A surprisingly high number of scientific papers in the field of genetics
> contain errors introduced by Microsoft Excel, according to an analysis
> recently published in the journal Genome Biology.
>
> A team of Australian researchers analyzed nearly 3,600 genetics papers
> published in a number of leading scientific journals — like Nature, Science
> and PLoS One. As is common practice in the field, these papers all came with
> supplementary files containing lists of genes used in the research.
>
> The Australian researchers found that roughly 1 in 5 of these papers
> included errors in their gene lists that were due to Excel automatically
> converting gene names to things like calendar dates or random numbers.
>
> You see, genes are often referred to in scientific literature by symbols —
> essentially shortened versions of full gene names. The gene "Septin 2" is
> typically shortened as SEPT2. "Membrane-Associated Ring Finger (C3HC4) 1, E3
> Ubiquitin Protein Ligase" gets mercifully shortened to MARCH1
>
> Even worse, there's no easy way to undo this automatic formatting once it
> has happened. Edit -> Undo simply deletes everything in the cell. You can
> try to convert the formatting from "General," the default, to "Text," which
> you might expect to change it back to the original characters you enter. But
> instead, changing the formatting to "Text" makes the cell contents appear as
> 42615 — Excel's internal numeric code referring to the date 9/2/2016.
>
> Even more troubling, the researchers note that there's no way to permanently
> disable automatic date formatting within Excel. Researchers still have to
> remember to manually format columns to "Text" before you type anything in
> new Excel sheets — every. single. time.
> But even the genetics researchers among us are only human, and they
> sometimes forget to do this. Hence, you end up with 20 percent of these
> genetics papers containing preventable errors introduced by Excel.
>
> The Australian researchers note that this problem was first identified in a
> paper published more than a decade ago. "Nevertheless, we find that these
> errors continue to pervade supplementary files in the scientific
> literature," they write.
>
> Genetics isn't the only field where a life's work can potentially be
> undermined by a spreadsheet error. Harvard economists Carmen Reinhart and
> Kenneth Rogoff famously made an Excel goof — omitting a few rows of data
> from a calculation — that caused them to drastically overstate the negative
> GDP impact of high debt burdens. Researchers in other fields occasionally
> have to issue retractions after finding Excel errors as well.
>
> The Australian researchers note that Excel isn't the only spreadsheet
> program with overly aggressive autoformatting issues — the same errors crop
> up in open-source programs like LibreOffice Calc and Apache OpenOffice Calc
> too.
>
> They do note, however, that one perfectly free spreadsheet program did not
> have any issues storing the gene names as typed — Google Sheets.»
>
>
> Perhaps now we can get back to discussing the issue of overly aggressive
> autoformatting in LibreOffice ?...
>
> Henri

Looks like a user problem to me.
Is no one proof reading this papers before submission?

Wade

-- 
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] Overly aggressive autofomatting issues in LibreOffice

[Jean-Baptiste Faure]

Le 26/08/2016 à 16:13, M Henri Day a écrit :
> ​This *Wapo* article (
> https://www.washingtonpost.com/news/wonk/wp/2016/08/26/an-alarming-number-of-scientific-papers-contain-excel-errors/)​
> - while dealing more specifically with Microsoft's Excel, should, as noted
> in the next-to-last paragraph, give even LibreOffice developers pause. If
> the claim that LibreOffice behaves like Microsoft Office in this particular
> respect is indeed true, then I submit that some attention should be devoted
> to making turning off autoformatting in Calc easier for users

Please, have a look here :
https://bugs.documentfoundation.org/show_bug.cgi?id=101696

Best regards.
JBF


-- 
Seuls des formats ouverts peuvent assurer la pérennité de vos documents.
Disclaimer: my Internet Provider being located in France, each of our
exchanges over Internet will be scanned by French spying services.

-- 
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] Overly aggressive autofomatting issues in LibreOffice

[Peter]

On 27/08/16 00:13, M Henri Day wrote:

​This *Wapo* article (
https://www.washingtonpost.com/news/wonk/wp/2016/08/26/an-alarming-number-of-scientific-papers-contain-excel-errors/)​
- while dealing more specifically with Microsoft's Excel, should, as noted
in the next-to-last paragraph, give even LibreOffice developers pause. If
the claim that LibreOffice behaves like Microsoft Office in this particular
respect is indeed true, then I submit that some attention should be devoted
to making turning off autoformatting in Calc easier for users

Henri

As a research  scientist of over 28 years, I do NOT believe the problem 
is with the spread sheet software but merely due to poor proof reading 
of the author and (presumably papers are sent for independent review 
before publication) by the independent reviewer. If this problem has 
been known for 10 years then even more shame on the authors and 
reviewers. Spreadsheets are meant for mathematical use (hence Open 
Office Calc). If you use a program for something other than it primary 
purpose the you need to take steps to ensure the appropriate steps to 
protect your data integrity.



Regards

Peter

--
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] Overly aggressive autoformatting issues in LibreOffice

[M Henri Day]

2016-08-26 18:10 GMT+02:00 Brian Barker :

> At 16:13 26/08/2016 +0200, M Henri Day wrote:
>
>> This *Wapo* article ( https://www.washingtonpost.com
>> /news/wonk/wp/2016/08/26/an-alarming-number-of-scientific-
>> papers-contain-excel-errors/ ) - while dealing more specifically with
>> Microsoft's Excel, should, as noted in the next-to-last paragraph, give
>> even LibreOffice developers pause. If the claim that LibreOffice behaves
>> like Microsoft Office in this particular respect is indeed true, then I
>> submit that some attention should be devoted to making turning off
>> autoformatting in Calc easier for users...
>>
>
> Surely some of the first things to understand about spreadsheets are that
> o Each cell is formatted in some way,
> o Data entered into cells may automatically be edited, and
> o In the absence of explicit cell formatting by the user, entering data
> may also (invisibly) set the cell format.
>
> If you drive your car into a lamppost or a brick wall, do you call this a
> vehicle manufacturing error or admit that not having learned to use the
> brake pedal puts the blame on you? Any spreadsheet user entering "MARCH1"
> and seeing it instantly converted to 01/03/01 (or perhaps 03/01/01) who
> doesn't immediately wake up to the problem with their own skills doesn't
> deserve the label "researcher". (Incidentally, I think LibreOffice will not
> interfere with "SEPT2" but would with "SEP2".)
>
> Anyone creating a spreadsheet containing gene (or other) names needs to
> format the appropriate columns as Text before entering data. If they don't
> carry this out, they should expect confusing results.
>
> It is certainly true that spreadsheets are a particularly fragile method
> of handing data and need to be used with care. Their apparent ease of use
> is deceptive: users do indeed need to be aware of proper techniques before
> being let loose on an application. They should also be aware of the
> consequences of published spreadsheets being moved between locales and to
> system with different settings - for example, date origins. It's not clear
> to me whether by "supplemental files" the author means spreadsheet
> documents themselves or just material originally entered into spreadsheets.
> Doesn't the fragility mean that spreadsheet documents are unsuitable for
> publication in this fashion and that researchers should know to fossilize
> material, perhaps as PDF, for publication? Any reader who wants to develop
> the material can contact the author for a copy of the original spreadsheet
> document; it is then up to them to be aware of the portability issues.
>
> I took my new umbrella out with me the other day but it failed to protect
> me from the rain. I complained about this failing to the manufacturer, who
> suggested that just taking it with me was not sufficient and that I needed
> to unfurl it and hold it above my head. Worse than that, they had the
> effrontery to suggest that I should have known this!
>
> Brian Barker
>

​The point, as I understood it, Brian, was that a means to automatically
turn off the autoformatting feature in the spreadsheets in MS Office,
LibreOffice, and Apache OpenOffice, which could be useful to many users,
particularly those writing scientific papers in which the confusion
described in the article, is lacking. Note also that Google Sheets seems to
be able to provide such a means

To imply, as you seem to do above, that users are simply careless in their
use of these tools is, to my mind, both false and ungenerous...

Henri​

-- 
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] highlight color won't change

[Armin Le Grand]

Hi,


how do you change the selection color in LO? I know no possibility.

LO takes the selection color from the system it runs at. Please change 
it there.



Am 25.08.2016 um 13:53 schrieb PegM4:

I highlighted some text in my Writer document and saved the document.  I now
think the highlighting is too dark.  I have tried to change the highlighting
to a lighter color several times and it would change.  I then saved it and
closed it. I've gone through this process several times, but every time I
open it, it is the original dark highlighting.

I'm using LibreOffice Writer 5.1.3.2 on an iMac computer with OS X El
Capitan.

Thank you
PegM



--
View this message in context: 
http://nabble.documentfoundation.org/highlight-color-won-t-change-tp4191700.html
Sent from the Users mailing list archive at Nabble.com.



--
--
ALG (PGP Key: EE1C 4B3F E751 D8BC C485 DEC1 3C59 F953 D81C F4A2)


--
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] Overly aggressive autoformatting issues in LibreOffice

[Brian Barker]

At 16:13 26/08/2016 +0200, M Henri Day wrote:
This *Wapo* article ( 
https://www.washingtonpost.com/news/wonk/wp/2016/08/26/an-alarming-number-of-scientific-papers-contain-excel-errors/ 
) - while dealing more specifically with Microsoft's Excel, should, 
as noted in the next-to-last paragraph, give even LibreOffice 
developers pause. If the claim that LibreOffice behaves like 
Microsoft Office in this particular respect is indeed true, then I 
submit that some attention should be devoted to making turning off 
autoformatting in Calc easier for users...


Surely some of the first things to understand about spreadsheets are that
o Each cell is formatted in some way,
o Data entered into cells may automatically be edited, and
o In the absence of explicit cell formatting by the user, entering 
data may also (invisibly) set the cell format.


If you drive your car into a lamppost or a brick wall, do you call 
this a vehicle manufacturing error or admit that not having learned 
to use the brake pedal puts the blame on you? Any spreadsheet user 
entering "MARCH1" and seeing it instantly converted to 01/03/01 (or 
perhaps 03/01/01) who doesn't immediately wake up to the problem with 
their own skills doesn't deserve the label "researcher". 
(Incidentally, I think LibreOffice will not interfere with "SEPT2" 
but would with "SEP2".)


Anyone creating a spreadsheet containing gene (or other) names needs 
to format the appropriate columns as Text before entering data. If 
they don't carry this out, they should expect confusing results.


It is certainly true that spreadsheets are a particularly fragile 
method of handing data and need to be used with care. Their apparent 
ease of use is deceptive: users do indeed need to be aware of proper 
techniques before being let loose on an application. They should also 
be aware of the consequences of published spreadsheets being moved 
between locales and to system with different settings - for example, 
date origins. It's not clear to me whether by "supplemental files" 
the author means spreadsheet documents themselves or just material 
originally entered into spreadsheets. Doesn't the fragility mean that 
spreadsheet documents are unsuitable for publication in this fashion 
and that researchers should know to fossilize material, perhaps as 
PDF, for publication? Any reader who wants to develop the material 
can contact the author for a copy of the original spreadsheet 
document; it is then up to them to be aware of the portability issues.


I took my new umbrella out with me the other day but it failed to 
protect me from the rain. I complained about this failing to the 
manufacturer, who suggested that just taking it with me was not 
sufficient and that I needed to unfurl it and hold it above my head. 
Worse than that, they had the effrontery to suggest that I should 
have known this!


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] Overly aggressive autofomatting issues in LibreOffice

[M Henri Day]

2016-08-26 17:31 GMT+02:00 Wade Smart :

> > I tried - and a popup appers to write down my mailadress and register.
> > Couldn't read the text in background.
> >
> > Regards
> >
> > Robert
>
> This is what I saw as well.
>

​We seem to be discussing an entirely different issue from that which I
originally proposed. I hope Cristopher Ingraham will regard it as fair use
if I reproduce the content of the article below​
​ :

«A surprisingly high number of scientific papers in the field of genetics
contain errors introduced by Microsoft Excel, according to an analysis
recently published in the journal Genome Biology.

A team of Australian researchers analyzed nearly 3,600 genetics papers
published in a number of leading scientific journals — like Nature, Science
and PLoS One. As is common practice in the field, these papers all came
with supplementary files containing lists of genes used in the research.

The Australian researchers found that roughly 1 in 5 of these papers
included errors in their gene lists that were due to Excel automatically
converting gene names to things like calendar dates or random numbers.

You see, genes are often referred to in scientific literature by symbols —
essentially shortened versions of full gene names. The gene "Septin 2" is
typically shortened as SEPT2. "Membrane-Associated Ring Finger (C3HC4) 1,
E3 Ubiquitin Protein Ligase" gets mercifully shortened to MARCH1

Even worse, there's no easy way to undo this automatic formatting once it
has happened. Edit -> Undo simply deletes everything in the cell. You can
try to convert the formatting from "General," the default, to "Text," which
you might expect to change it back to the original characters you enter.
But instead, changing the formatting to "Text" makes the cell contents
appear as 42615 — Excel's internal numeric code referring to the date
9/2/2016.

Even more troubling, the researchers note that there's no way to
permanently disable automatic date formatting within Excel. Researchers
still have to remember to manually format columns to "Text" before you type
anything in new Excel sheets — every. single. time.
But even the genetics researchers among us are only human, and they
sometimes forget to do this. Hence, you end up with 20 percent of these
genetics papers containing preventable errors introduced by Excel.

The Australian researchers note that this problem was first identified in a
paper published more than a decade ago. "Nevertheless, we find that these
errors continue to pervade supplementary files in the scientific
literature," they write.

Genetics isn't the only field where a life's work can potentially be
undermined by a spreadsheet error. Harvard economists Carmen Reinhart and
Kenneth Rogoff famously made an Excel goof — omitting a few rows of data
from a calculation — that caused them to drastically overstate the negative
GDP impact of high debt burdens. Researchers in other fields occasionally
have to issue retractions after finding Excel errors as well.

The Australian researchers note that Excel isn't the only spreadsheet
program with overly aggressive autoformatting issues — the same errors crop
up in open-source programs like LibreOffice Calc and Apache OpenOffice Calc
too.

They do note, however, that one perfectly free spreadsheet program did not
have any issues storing the gene names as typed — Google Sheets.»​


​Perhaps now we can get back to discussing the issue of overly aggressive
autoformatting in LibreOffice ?...

Henri

-- 
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] Overly aggressive autofomatting issues in LibreOffice

[Wade Smart]

> I tried - and a popup appers to write down my mailadress and register.
> Couldn't read the text in background.
>
> Regards
>
> Robert

This is what I saw as well.

-- 
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] dsum

[Bruce Hohl]

There is an example in the installable help at:
Help > LibreOffice Help
Contents tab > Spreadsheets > Functions Types and Operators > Database
Functions

I just checked and that example works.

On Fri, Aug 26, 2016 at 2:25 AM, Istvan Toth  wrote:

> Guten Morgen,
> ich kann die dsum Function nicht richtig Parameter geben, immer kann ich
> Fehler bekomman,
> Was kann ich nicht richtig eingeben?
> Mfg
> ti
>
>
>
> --
> View this message in context: http://nabble.documentfoundation.org/dsum-
> tp4191752.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> 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] AutoText Completion

[Philip Jackson]

On 25/08/16 23:42, CVAlkan wrote:
> I recently installed a new OS and am now using LibreOffice Version: 5.2.0.4,
> Build ID: 1:5.2.0~rc4-0ubuntu1~xenial2.
> 
> When I went to set up some autotext completions, I first tested that
> everything worked the same as I'm used to. So I typed dt and then pressed
> F3. Nothing happened! Did someone break the "Hello World" of the autotext?
> So I pressed Ctrl+F3 and looked through the listings. Sure enough, dt was
> there, along with lorem ipsum and all his other friends.
> 

Interesting. This provoked me to check it out on my new (10 days' ago)
clean install of UbuntuStudio 16.04 LTS which has LibreOffice Version:
5.1.4.2 Build ID: 1:5.1.4-0ubuntu1.

dt followed by F3 works fine and prints out a load of dummy text.

> 
> So I looked into Tools>Customize and F3 was right there - and unassigned. I
> thought that was a standard assignment, as I don't recall ever having to
> explicitly set it; 

F3 is a standard assignment in 5.1.4.2 and works fine

Ctrl+F3 is also shown as a standard assignment but on my machine, it
does not work as a LO shortcut because it has been hijacked by the
window manager and takes me to desktop #3.

Ctrl+F1 takes me to desktop #1 and so on for all the Ctrl+F(n) combos up
to the 6 desktops I use.

I never realized I could change desktops that way because I always
change desktop using Crtl+Alt+ left or right arrow key.

And when I check the UbuntuStudio settings manager for the Window
Manager keyboard shortcuts, the Ctrl+F(n) are indeed shown there.

Curious how it all varies from version to version.  You live and learn.
Philip


-- 
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] Overly aggressive autofomatting issues in LibreOffice

[mxk]

On 8/26/2016 10:21 AM, James Knott wrote:

On 08/26/2016 10:17 AM, Wade Smart wrote:

>You have to register to read the article.

I didn't have to.

Nor did I.

--
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] Overly aggressive autofomatting issues in LibreOffice

[James Knott]

On 08/26/2016 10:17 AM, Wade Smart wrote:
> You have to register to read the article.

I didn't have to.


-- 
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] Overly aggressive autofomatting issues in LibreOffice

[Wade Smart]

You have to register to read the article.
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005


On Fri, Aug 26, 2016 at 9:13 AM, M Henri Day  wrote:
> This *Wapo* article (
> https://www.washingtonpost.com/news/wonk/wp/2016/08/26/an-alarming-number-of-scientific-papers-contain-excel-errors/)
> - while dealing more specifically with Microsoft's Excel, should, as noted
> in the next-to-last paragraph, give even LibreOffice developers pause. If
> the claim that LibreOffice behaves like Microsoft Office in this particular
> respect is indeed true, then I submit that some attention should be devoted
> to making turning off autoformatting in Calc easier for users
>
> Henri
>
> --
> 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] Overly aggressive autofomatting issues in LibreOffice

[M Henri Day]

​This *Wapo* article (
https://www.washingtonpost.com/news/wonk/wp/2016/08/26/an-alarming-number-of-scientific-papers-contain-excel-errors/)​
- while dealing more specifically with Microsoft's Excel, should, as noted
in the next-to-last paragraph, give even LibreOffice developers pause. If
the claim that LibreOffice behaves like Microsoft Office in this particular
respect is indeed true, then I submit that some attention should be devoted
to making turning off autoformatting in Calc easier for users

Henri

-- 
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] example convenience of calc

[message]

Readers,

Useful to be able to type in the command line:

libreoffice --calc --nologo 
https://www.gov.uk/government/uploads/system/uploads/attachment_data/file/450279/Progress_8_2015_opt_in_schools_final_list.ods


Then the spreadsheet appears directly from the web server!

Looks good with the 'load url bar' view of the url in the menu bar too, 
like a web browser! :)


--
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: LibreOffice on a Chromebook?

[Alexander Thurgood]

Le 25/08/2016 à 20:07, Kevin O'Brien a écrit :

Hi Kevin,


> I have been thinking about getting a Chromebook, but the one thing
> holding me back is that I need to be able to run LibreOffice. Is that
> something I can do now? And if so, how well does it run?


Not directly, but if you install Crouton on top of ChromeOS, then yes,
you can also run LibreOffice.

I have installed Crouton on my Toshiba Chromebook 2 (2015) and am using
Ubuntu 16.04 with LXDE desktop environment. LibreOffice provided by that
Ubuntu version works pretty much as it would on a standard Linux OS.

Alex



-- 
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] dsum

[Gabriele Ponzo]

This list is meant to be written in English ;)

Il 26/ago/2016 08:45, "Istvan Toth"  ha scritto:

> Guten Morgen,
> ich kann die dsum Function nicht richtig Parameter geben, immer kann ich
> Fehler bekomman,
> Was kann ich nicht richtig eingeben?
> Mfg
> ti
>
>
>
> --
> View this message in context: http://nabble.documentfoundation.org/dsum-
> tp4191752.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> 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] dsum

[Istvan Toth]

Guten Morgen,
ich kann die dsum Function nicht richtig Parameter geben, immer kann ich
Fehler bekomman,
Was kann ich nicht richtig eingeben?
Mfg
ti



--
View this message in context: 
http://nabble.documentfoundation.org/dsum-tp4191752.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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