Re: [libreoffice-users] Static vs. dynamic time
Was looking for options on this, but haven't found exactly what I'm
looking for.
Closest I've found is Ctrl + ; that inserts current date
and Ctrl + Shift + ; that inserts the current time.
Both seem to be the fixed value?
But have found no way to do that in a formula??
Recall long ago in either Lotus or Quattro, you could use now() and then
{Calc} and it would convert the current time to the fixed value. But that
was long long ago. Macro recorder doesn't seem to record that kind of
stuff, and entering formulas don't either.
On 3 Oct 2020 at 10:31, Michael Manning wrote:
From: Michael Manning
Date sent: Sat, 3 Oct 2020 10:31:58 +1000
Subject:Re: [libreoffice-users] Static vs. dynamic time
To: LibreOffice
> When I have needed a static date or time in Libreoffice Calc, I have found
> that the only way to do this is to enter the date or time directly into the
> spreadsheet and not to use a formula.
>
> As an example of this, I have been using Calc to measure the drift of
> timepieces compared to a time standard at weekly intervals over a 26 week
> period. I pre-enter the dates at which the measurements are to be made.
> At the required date, I simply enter the time as shown on the timepiece and
> the time as shown on the time standard at the same instance. These times
> are then converted to seconds and the difference between in seconds is then
> calculated and charted to show the time drift. These times and dates are
> static and can be used for later referral.
>
> I am not sure if there is a way to use a formula or macro to enter a static
> date. If there is, it is beyond my capabilities. Entering dates and times
> directly seems very straightforward to me.
>
> Mike
> email: michaelgmann...@gmail.com
> Libreoffice https://www.libreoffice.org/
>
>
>
>
> On Fri, 2 Oct 2020 at 19:41, Chimel wrote:
>
> > Hi,
> >
> > I use the formula IF(A1<>"";NOW()) copied to every cell of column B.
> > It gives me the correct time every time I type anything on a line of column
> > A.
> > But this is refreshed constantly by the time of the computer, not the time
> > I
> > typed something in column A.
> > I tried looking for a static version of NOW() or playing with iterations
> > (probably not correctly) or looking for a way to stop recomputing this
> > specific column to no avail.
> > Is there a way to set on column B the time of the typing on each line of
> > column A and keep it as a static time.
> >
> > I am usually good with formulas, but this very basic need escapes me.
> > As far as usability is concerned, a STATICNOW() function seems much more
> > useful than the current NOW() function. Or inserting a 0,1 argument for
> > staticness or something.
> > So far, I am forced to type or insert the time manually each time.
> > Let me repeat it: Manually each time! Me! ;)
> >
> > Thanks,
> > Chimel.
> >
> >
> >
> > --
> > Sent from:
> > http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html
> >
> > --
> > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> > Problems?
> > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> > List archive: https://listarchives.libreoffice.org/global/users/
> > Privacy Policy: https://www.documentfoundation.org/privacy
> >
> >
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
++
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mi...@guam.net
mailto:msetze...@gmail.com
Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
++
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Static vs. dynamic time
When I have needed a static date or time in Libreoffice Calc, I have found that the only way to do this is to enter the date or time directly into the spreadsheet and not to use a formula. As an example of this, I have been using Calc to measure the drift of timepieces compared to a time standard at weekly intervals over a 26 week period. I pre-enter the dates at which the measurements are to be made. At the required date, I simply enter the time as shown on the timepiece and the time as shown on the time standard at the same instance. These times are then converted to seconds and the difference between in seconds is then calculated and charted to show the time drift. These times and dates are static and can be used for later referral. I am not sure if there is a way to use a formula or macro to enter a static date. If there is, it is beyond my capabilities. Entering dates and times directly seems very straightforward to me. Mike email: michaelgmann...@gmail.com Libreoffice https://www.libreoffice.org/ On Fri, 2 Oct 2020 at 19:41, Chimel wrote: > Hi, > > I use the formula IF(A1<>"";NOW()) copied to every cell of column B. > It gives me the correct time every time I type anything on a line of column > A. > But this is refreshed constantly by the time of the computer, not the time > I > typed something in column A. > I tried looking for a static version of NOW() or playing with iterations > (probably not correctly) or looking for a way to stop recomputing this > specific column to no avail. > Is there a way to set on column B the time of the typing on each line of > column A and keep it as a static time. > > I am usually good with formulas, but this very basic need escapes me. > As far as usability is concerned, a STATICNOW() function seems much more > useful than the current NOW() function. Or inserting a 0,1 argument for > staticness or something. > So far, I am forced to type or insert the time manually each time. > Let me repeat it: Manually each time! Me! ;) > > Thanks, > Chimel. > > > > -- > Sent from: > http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Static vs. dynamic time
On Fri, 2 Oct 2020 21:27:30 +0200 Johnny Rosenberg wrote: > In Google Spreadsheets What does this have to do with LO? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Static vs. dynamic time
At 02:37 02/10/2020 -0700, Chimel Noname wrote: I use the formula IF(A1<>"";NOW()) copied to every cell of column B. It gives me the correct time every time I type anything on a line of column A. But this is refreshed constantly by the time of the computer, not the time I typed something in column A. I tried looking for a static version of NOW() or playing with iterations (probably not correctly) or looking for a way to stop recomputing this specific column to no avail. Is there a way to set on column B the time of the typing on each line of column A and keep it as a static time. This is a simple question but unfortunately does not appear to have a simple answer. But - like with your other question - you can do something using a recursive formula. Enter into B1 =IF(A1="";"";IF(B1="";NOW();B1)) Once again, you need to have Tools | Options... | LibreOffice Calc | Calculate | Iterative References | Iterations ticked. This almost works, in that if A1 is empty and you enter something there, then B1 will change to record the time. But if you now simply overtype what is already in A1, B1 will not change. There is an easy workaround, however: before typing your new value into A1, just press Delete to empty A1 (B1 will now be empty too) and then enter your new value (B1 becomes the new time). So far, I am forced to type or insert the time manually each time. No longer! I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Re: Static vs. dynamic maximum
Den fre 2 okt. 2020 kl 16:20 skrev Chimel : > A cell with a formula can have a whole "history" of values that change > every > now and then. > I'm pretty sure it can not. Please prove me wrong. I'd love to know what this is all about. Maybe I just don't understand what you are trying to say. Kind regards Johnny Rosenberg > It has only one value at one given time, it's this value that I want to > compare with its previous values so I can extract the maximal value the > cell > ever reached. > > > > > -- > Sent from: > http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Can you please associate my extension to me?
Although I could manage it, I could no longer find it except to manage it... Cannot check it again until Sunday when I am again near a computer Sent from BlueMail On Oct 2, 2020, 3:13 AM, at 3:13 AM, Heiko Tietze wrote: >On 01.10.20 22:11, Andrew Pitonyak wrote: >> I noticed it seemed to have just disappeared but I can see if to >maintain it but not navigate to it. my best guess is that it is because >I inadvertently changed the title but I don't really know. I tried to >put entitled back, but did not cause it to reappear. > >Your extension has the status MODIFIED (whatever than means); maybe >this causes >it not being shown on the page? Or do you talk about the "Manage your >extensions" section, which is empty for me for some reason. In any case >you are >welcome to file a ticket on >https://redmine.documentfoundation.org/projects/extensions/issues > >Cheers, >Heiko > > >-- >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >Problems? >https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: >https://wiki.documentfoundation.org/Netiquette >List archive: https://listarchives.libreoffice.org/global/users/ >Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Static vs. dynamic time
Some disappointment: Now I'm not so sure any more that this is possible. My idea was to check the currently selected cell, but it has two big flaws: 1: When updating cell contents, any cell can be selected. 2: ThisComponent.CurrentSelection.getValue() seems to always return 0 in a situation like that, no matter which cell is selected and no matter its value… but even if that part worked, the whole thing wouldn't work anyway, see 1. So I simply failed to make it work. Sorry. In my Google Spreadsheet, I have a script that fills in the corresponding cell in column A if one of a few cells in the same row was filled, but there doesn't seem to be any (easy) way to trigger a macro to run when a cell was changed in LibreOffice. Maybe trying with listeners, but I never studied those so I'm totally clueless about them. In Google Spreadsheets you only have to create a function and call it OnEdit(). It will run every time a cell is changed. In that function, you just write code to find out what cell was changed and if a cell in a certain column or cell range was changed, just fill in the current date and/or time value in your time- or date column at the same row as the cell that was changed. It's actually very straight forward. Anyway, odd that I couldn't find an easy way to do it in LibreOffice Calc. I'm sure it's possible, but I don't have a clue how to do it, at the moment. I'm sure I'm overlooking something. This should be easy, shouldn't it? A few simple workarounds that comes to mind: Use the pre-defined keyboard shortcuts to insert date, time or date and time. I don't remember the shortcuts now, because I changed mine (to Ctrl+↵ for date), but maybe it is Ctrl+; that is the same as in Excel? Another workaround is to use the NOW() function and when finished just select all date cells and then hit Ctrl+c Insert ↵. Ctrl+c for copying the cell range, Insert for Paste Special (or is that just another one of those keyboard shortcuts that I changed on my own setup?) and ↵ for executing the paste. Or write a macro that replaces all date cell's formulas with their values automatically and run it before saving your spreadsheet. Or maybe let the same macro also save the spreadsheet and use that macro instead of Ctrl+s for saving. Kind regards Johnny Rosenberg Den fre 2 okt. 2020 kl 19:58 skrev Johnny Rosenberg : > Den fre 2 okt. 2020 kl 11:41 skrev Chimel : > >> Hi, >> >> I use the formula IF(A1<>"";NOW()) copied to every cell of column B. >> It gives me the correct time every time I type anything on a line of >> column >> A. >> But this is refreshed constantly by the time of the computer, > > > Yes, that's the point with the NOW() function. It's usually used for > calculating time, for instance how long ago a certain date was, for > instance =NOW()-A1, which you then format to whatever format you like. With > no formatting you get it in days. > > not the time I >> typed something in column A. >> > > That's correct and intended. > > I tried looking for a static version of NOW() or playing with iterations >> (probably not correctly) or looking for a way to stop recomputing this >> specific column to no avail. >> Is there a way to set on column B the time of the typing on each line of >> column A and keep it as a static time. >> > > Yes, I actually do that in a Google Spreadsheet, but it can be done in all > spreadsheets that support macros or scripts, I think. > >> >> I am usually good with formulas, but this very basic need escapes me. >> > > It's probably because there is no cell function for that. You have to > create your own. > > As far as usability is concerned, a STATICNOW() function seems much more >> useful than the current NOW() function. > > > It depends on what you want to do. See above. I find both useful, but in > different situations. > > >> Or inserting a 0,1 argument for >> staticness or something. >> So far, I am forced to type or insert the time manually each time. >> Let me repeat it: Manually each time! Me! ;) >> > > I'll experiment a bit with a macro for this. I'm back when done, if nobody > beats me to it. > > > Kind regards > > Johnny Rosenberg > > >> >> Thanks, >> Chimel. >> >> >> >> -- >> Sent from: >> http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html >> >> -- >> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >> Problems? >> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette >> List archive: https://listarchives.libreoffice.org/global/users/ >> Privacy Policy: https://www.documentfoundation.org/privacy >> >> -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy:
Re: [libreoffice-users] Static vs. dynamic maximum
At 06:41 02/10/2020 -0700, Chimel Noname wrote: ... I am also stuck with extracting the maximum value of one given cell. For instance, A1 contains variable numbers, and I want to store the maximal value of this cell in B1. As others have said, the cell, does not "contain variable numbers", but only the single value (or expression) that is there at the time. The trouble is that MAX() compares 2 different cells, whereas I want the maximal value of one cell. No, you don't. A recursive formula such as =MAX(A1;B1) would probably not work, and returns an error 523 indeed. Actually, this works: read on. At 07:18 02/10/2020 -0700, Chimel Noname wrote: A cell with a formula can have a whole "history" of values that change every now and then. No, the cell has just whatever is in it now. It has only one value at one given time, it's this value that I want to compare with its previous values so I can extract the maximal value the cell ever reached. But the previous values have been overwritten by the current one, so are no longer there. Actually, you have solved your own problem. If you want to keep a record in B1 of the largest of all the values that have appeared in A1, then putting =MAX(A1;B1) into B1 would appear to work - as B1 has kept a record of that part of the history of A1's values that you need. But the logic is recursive: evaluating the formula changes one of its parameters, so the formula potentially needs evaluating again. How many times should this happen? The process might never terminate. In this case, you want the calculation to happen once only, but how can LibreOffice know that? All you need to do is to permit recursive calculations, which you do by ticking Tools | Options... | LibreOffice Calc | Calculate | Iterative References | Iterations. Then your formula works. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Question about saving Excel 365 (.xlsx) files in LibreOffice Calc 6.4.6
Le 2020-10-01 01:13, Tom Williams a écrit : Hi! A friend of mine sent me an Excel 365 spreadsheet to get my help to add a formula. The spreadsheet is "simple", in that it had about 90 rows of data, with only one column being a numeric value. Everything else was plain text. I added the formula (to sum the numbers in the one numeric column) and when I saved the file, in XLSX format, I noticed the file size was smaller. Here is what I found: Original file: 22kb Calc 6.4.6 on Ubuntu 20.04: 16kb Calc 5.1.6 (I think) on Mint 18.3: 9kb Why would saving the file in Calc reduce the file size? Thanks in advance! Peace... "The Other" Tom -- /When I leave, I don't know what I'm hoping to find, And when I leave, I don't know what I'm leaving behind.../ Hello Tom A pleasure to have a librarian lol, well already the previous versions of LibreOffice converted to Ms Office format are necessarily more dancing in size as you have noticed, I will advise you to publish the latest version of LibreOffice 7.0.1.2 then to come back to your question I don't have a screenshot but I send you mine which also shows a document at the base ods of 33.6 kiB converted to xlsx format of 26.9 kiB but when you look at the content level the xlsx version is in excel zip so compressed at the base where the xlsx size will be smaller than the ods version in size because it is compressed at the source. I hope to have answered your concern if not please specify your question to me with screenshots so that I understand well why it is not a question. cordially Sandra LOUVEZO -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Static vs. dynamic time
Den fre 2 okt. 2020 kl 11:41 skrev Chimel : > Hi, > > I use the formula IF(A1<>"";NOW()) copied to every cell of column B. > It gives me the correct time every time I type anything on a line of column > A. > But this is refreshed constantly by the time of the computer, Yes, that's the point with the NOW() function. It's usually used for calculating time, for instance how long ago a certain date was, for instance =NOW()-A1, which you then format to whatever format you like. With no formatting you get it in days. not the time I > typed something in column A. > That's correct and intended. I tried looking for a static version of NOW() or playing with iterations > (probably not correctly) or looking for a way to stop recomputing this > specific column to no avail. > Is there a way to set on column B the time of the typing on each line of > column A and keep it as a static time. > Yes, I actually do that in a Google Spreadsheet, but it can be done in all spreadsheets that support macros or scripts, I think. > > I am usually good with formulas, but this very basic need escapes me. > It's probably because there is no cell function for that. You have to create your own. As far as usability is concerned, a STATICNOW() function seems much more > useful than the current NOW() function. It depends on what you want to do. See above. I find both useful, but in different situations. > Or inserting a 0,1 argument for > staticness or something. > So far, I am forced to type or insert the time manually each time. > Let me repeat it: Manually each time! Me! ;) > I'll experiment a bit with a macro for this. I'm back when done, if nobody beats me to it. Kind regards Johnny Rosenberg > > Thanks, > Chimel. > > > > -- > Sent from: > http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Re: Static vs. dynamic time
This is exactly the formula I needed, it works just fine every time. Thanks again, Brian. -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Re: Static vs. dynamic maximum
Thanks, Brian. The formula I mentioned earlier works now. I tried the Iterations settings before, enabled and disabled it with different values (step, min), but when I clicked on the Reset button to restore the default options, it actually only restores the previous values I played with before, not the LibreOffice "factory settings". These previous values of 1 for steps and min return the error 523 I mentioned. I tried step=100 and min=0,001, and my formula (the same you mentioned) works just fine. So the formula was fine all along, it's the Iterations settings that were incorrect. Problem solved, thanks to everybody who helped and sorry if I was not clear. -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Question about saving Excel 365 (.xlsx) files in LibreOffice Calc 6.4.6
On 10/2/20 7:32 AM, sandralo...@vivaldi.net wrote: > Le 2020-10-01 01:13, Tom Williams a écrit : >> Hi! A friend of mine sent me an Excel 365 spreadsheet to get my help to >> add a formula. The spreadsheet is "simple", in that it had about 90 >> rows of data, with only one column being a numeric value. Everything >> else was plain text. I added the formula (to sum the numbers in the one >> numeric column) and when I saved the file, in XLSX format, I noticed the >> file size was smaller. >> >> Here is what I found: >> >> Original file: 22kb >> >> Calc 6.4.6 on Ubuntu 20.04: 16kb >> >> Calc 5.1.6 (I think) on Mint 18.3: 9kb >> >> Why would saving the file in Calc reduce the file size? >> >> Thanks in advance! >> >> Peace... >> >> "The Other" Tom >> >> -- >> /When I leave, I don't know what I'm hoping to find, >> And when I leave, I don't know what I'm leaving behind.../ > > Hello Tom > > A pleasure to have a librarian lol, well already the previous versions > of LibreOffice converted to Ms Office format are necessarily more > dancing in size as you have noticed, I will advise you to publish the > latest version of LibreOffice 7.0.1.2 > > then to come back to your question I don't have a screenshot but I > send you mine which also shows a document at the base ods of 33.6 kiB > converted to xlsx format of 26.9 kiB but when you look at the content > level the xlsx version is in excel zip so compressed at the base where > the xlsx size will be smaller than the ods version in size because it > is compressed at the source. > > I hope to have answered your concern if not please specify your > question to me with screenshots so that I understand well why it is > not a question. > > cordially > Sandra LOUVEZO Thanks for the reply! I'll try LibreOffice 7 and see what happens. I think I have it installed in a virtual Windows 10 environment I sometimes use. Thanks! Peace... "The Other" Tom -- /When I leave, I don't know what I'm hoping to find, And when I leave, I don't know what I'm leaving behind.../ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Static vs. dynamic maximum
On Fri, 2 Oct 2020 15:03:17 +0100 Dave Howorth wrote: Hello Dave, >So the entire notion of the 'maximum' value of a cell is meaningless. I /think/ what Chimel wants is B1=A1 if A1>B1 How to achieve that in LO Calc, IDK; I keep getting circular reference errors. -- Regards _ / ) "The blindingly obvious is / _)radnever immediately apparent" Just coz they do it in the movies, doesn't mean to say that it's cool Keep It Clean - The Vibrators -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Re: Static vs. dynamic maximum
A cell with a formula can have a whole "history" of values that change every now and then. It has only one value at one given time, it's this value that I want to compare with its previous values so I can extract the maximal value the cell ever reached. -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Static vs. dynamic maximum
On Fri, 2 Oct 2020 06:41:27 -0700 (MST) Chimel wrote: > Hi, > > I must be of a conservative mind today, because after the message > about static NOW(), I am also stuck with extracting the maximum value > of one given cell. What do you mean by 'the maximum value' of a cell? It sounds like you think cells have a history of their contents? That's not the case. A cell has a value. If you then enter a different value in the cell, it has the new value. It does not 'remember' the old value. (Notwithstanding the ability of the UI to 'undo' editing - that's something completely different). So the entire notion of the 'maximum' value of a cell is meaningless. > For instance, A1 contains variable numbers, and I want to store the > maximal value of this cell in B1. > The trouble is that MAX() compares 2 different cells, whereas I want > the maximal value of one cell. > A recursive formula such as =MAX(A1;B1) would probably not work, and > returns an error 523 indeed. > > Is there a way to store the maximal value of a cell using a formula, > preferably? > > Thanks, > Chimel. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Static vs. dynamic maximum
Hi, I must be of a conservative mind today, because after the message about static NOW(), I am also stuck with extracting the maximum value of one given cell. For instance, A1 contains variable numbers, and I want to store the maximal value of this cell in B1. The trouble is that MAX() compares 2 different cells, whereas I want the maximal value of one cell. A recursive formula such as =MAX(A1;B1) would probably not work, and returns an error 523 indeed. Is there a way to store the maximal value of a cell using a formula, preferably? Thanks, Chimel. -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] corrupted font name and size display in format bar in Calc
On 01/10/2020 20:36, JPS wrote: On 01/10/2020 13.28, Philip Jackson wrote: In LO 6.4.5.2 and 6.4.6.2 (UbuntuStudio), whenever I open one of my spread sheets, made years' ago but in weekly use, I find that the font name and the font size is slightly corrupted in the formatting toolbar. The size should be 10 but it looks like both 20 and 10 written in the same space at same time. Equally the font name should be Liberation Sans but it too looks sometimes like a combination of two names. This is less common that the font size corruption. If I highlight a cell and click the font size dropdown, the correct size is clearly displayed. If I then select another cell, instead of displaying 10 it looks like a mix of 10 and 12 (not 20 and 10 as when first opened) until I again click on the dropdown. If I close the formatting bar and reopen it, the corruption is back. Hi Philip, Exactly the same issue here but not only in Calc but also in Writer, Impress and Draw. No old documents needed to reproduce it. Just open any of these modules, type in some characters so that you have at least two different fonts and two different font sizes. Then point the cursor in the text to the different fonts and font sizes and that's it. I am currently using Xubuntu 20.04, Ubuntu Studio 20.04 and Ubuntu Budgie 20.04. I downloaded LO 6.3.6.2, LO 6.4.6.2 and LO 7.0.1.2 from libreoffice.org and installed them in an external hard drive so that I can access these installations from any distro. The issue only occurs when running these installations of LO 6.3 or LO 6.4 from Ubuntu Studio; it does never happen with LO 7.0 (regardless of the distro) and it also never happens when running any of these same three installations of LO from Xubuntu or from Ubuntu Budgie. Thanks for your confirmation, JPS. I can confirm that I get the effect in Writer too. I hadn't noticed it before but you're quite right. Interesting that you get the poor display only in UbuntuStudio and even using downloads of LO direct from libreoffice.org. I made a fresh, clean installation of UbuntuStudio 20.04.1 at the beginning of August and my experience with it so far is that it is the worst since I started with this distro back in 14.04. I have some applications that take 32 seconds to start up regardless of whether it is the first start or an n'th start since bootup. I had xscreensaver which wouldn't kick in until I disabled the startup script that came with the distro. Some applications do start normally but some are always slow and some of these slow ones were part of the distribution and not something I installed later. Maybe it has something to do with the fact announced by UbuntuStudio that their dev's were pretty well all working with Kubuntu and the KDE Plasma desktop. 20.04 was their last planned release with the XFCE desktop. Anyway, it does not appear to be a subject for this discussion group and would be more correctly dealt with on the Ubuntu forums. Thanks and best regards, Philip -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Static vs. dynamic time
Hi, I use the formula IF(A1<>"";NOW()) copied to every cell of column B. It gives me the correct time every time I type anything on a line of column A. But this is refreshed constantly by the time of the computer, not the time I typed something in column A. I tried looking for a static version of NOW() or playing with iterations (probably not correctly) or looking for a way to stop recomputing this specific column to no avail. Is there a way to set on column B the time of the typing on each line of column A and keep it as a static time. I am usually good with formulas, but this very basic need escapes me. As far as usability is concerned, a STATICNOW() function seems much more useful than the current NOW() function. Or inserting a 0,1 argument for staticness or something. So far, I am forced to type or insert the time manually each time. Let me repeat it: Manually each time! Me! ;) Thanks, Chimel. -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Can you please associate my extension to me?
FWIW, the MODIFIED flag is apparently the status for unpublished extensions (maybe you changed something but the extension file?). And after pressing the button again it shows up now on the page. On 01.10.20 22:11, Andrew Pitonyak wrote: > I noticed it seemed to have just disappeared but I can see if to maintain it > but not navigate to it. my best guess is that it is because I inadvertently > changed the title but I don't really know. I tried to put entitled back, but > did not cause it to reappear. > > > > > > Sent from BlueMail > > On Oct 1, 2020, 11:12 AM, at 11:12 AM, Dave Howorth > wrote: >> On Thu, 1 Oct 2020 15:59:01 +0200 >> Heiko Tietze wrote: >> >>> Publishing is only possible for admins. We consider to make this >>> available in future. I pushed the button now... >> >> Page not found >> >>> On 01.10.20 14:37, Andrew Pitonyak wrote: I think that I am missing something obvious. How do I change the latest version from DRAFT to published so that people can download it? On Thursday, October 01, 2020 02:12 EDT, Heiko Tietze wrote: Done, you are now the maintainer of this extension. Many thanks for your contribution, Heiko On 30.09.20 21:16, Andrew Douglas Pitonyak wrote: > > Is anyone able to associate this extension to me: > > >> https://extensions.libreoffice.org/en/extensions/show/code-colorizer-formatter > > > If you cannot associate the extension to "and...@pitonyak.org", > can I email the latest version for upload. > > > -- Dr. Heiko Tietze, UX-Designer and UX-Mentor Tel: +49 30 5557992-63 | Mail: heiko.tie...@documentfoundation.org The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts Legal details: https://www.documentfoundation.org/imprint -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? >> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy >>> >> >> >> -- >> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >> Problems? >> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >> Posting guidelines + more: >> https://wiki.documentfoundation.org/Netiquette >> List archive: https://listarchives.libreoffice.org/global/users/ >> Privacy Policy: https://www.documentfoundation.org/privacy > -- Dr. Heiko Tietze, UX-Designer and UX-Mentor Tel: +49 30 5557992-63 | Mail: heiko.tie...@documentfoundation.org The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts Legal details: https://www.documentfoundation.org/imprint -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Can you please associate my extension to me?
On 01.10.20 22:11, Andrew Pitonyak wrote: > I noticed it seemed to have just disappeared but I can see if to maintain it > but not navigate to it. my best guess is that it is because I inadvertently > changed the title but I don't really know. I tried to put entitled back, but > did not cause it to reappear. Your extension has the status MODIFIED (whatever than means); maybe this causes it not being shown on the page? Or do you talk about the "Manage your extensions" section, which is empty for me for some reason. In any case you are welcome to file a ticket on https://redmine.documentfoundation.org/projects/extensions/issues Cheers, Heiko -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
