Date: prev next · Thread: first prev next last
2016 Archives by date, by thread · List index

I have a process that I do in a spreadsheet, and part of the process is 
converting a text date field that is in the MM/YY format?? from the website 
that I download 487 records. The process to convert it to the real date field 
that it should have been is: Text date is in G1, so in L1 I use the formula.
=eomonth(date(right(g1,2),left(g1,2),1),0).  That gives me the proper last day 
of the month as the expiration date.

He is my problem. When I record as a macro, entering the formula doesn't 
get included in the macro. All the other steps do, but not the formula???

I have discovered, and I can record the macro, but instead of putting in the 
formula as it should be entered, I type it without the = at the beginning. This 
the Macro recorder handles with no problem, and it works, just doesn't put 
the correct formula. I can then edit the Macro, and add the =, and it works 
perfectly?? (This is with the latest libreoffice under linux. Don't know if 
it does the same in windows?

I've also had an issue using Format Cell. I pops up with a message about 
wanting to install a Russian font?? Even with an empty spread sheet. Doesn't 
matter if I use menu format cell or right-click format cell.  In running calc with 
strace I get these lines.
** (soffice:19050): DEBUG: InstallFontconfigResources method failed
** (soffice:19050): DEBUG: InstallFontconfigResources problem : did not 
agree to search

The first one is what I think is the error that causes the asking to install 
russian font, and the second is when I select close. It I let it search, it come 
back with it finds no font?


  Michael D. Setzer II -  Computer Science Instructor      
  Guam Community College  Computer Center                                
  Guam - Where America's Day Begins                        
  G4L Disk Imaging Project maintainer
+----------------------------------------------------------+ (Original)
Number of Seti Units Returned:  19,471
Processing time:  32 years, 290 days, 12 hours, 58 minutes
(Total Hours: 287,489)

ABC         16613838.513356 | EINSTEIN   123793630.788695
ROSETTA     54887642.050834 | SETI        97748790.390510

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.