If the date to check is in B3, try the following formula:
=IF(WEEKDAY(B3)=1;B3-2;IF(WEEKDAY(B3)=7;B3-1;B3))
Don't forget to format the target cell as a date ;-)
Succes
Met vriendelijke groeten, Salutations distinguées, Kind Regards,
DRIES FEYS
CORPORATE SERVICES • Specialist Software
On 06/12/2015 07:29 AM, Gordon Burgess-Parker wrote:
could I use this future date to generate a reminder in Lightning calendar?
Lightning uses SQLite.
SQLite does no data validation. It has no objections to putting a 5 MB
binary blob into a field that is supposed to be a single integer.
The
On 12 Jun 2015 at 8:49, Gordon Burgess-Parker wrote:
Date sent:Fri, 12 Jun 2015 08:49:35 +0100
From:Gordon burgess-parkergordo...@mail.com
To:users@global.libreoffice.org
Subject:Re: [libreoffice-users] Calc date formulae
On 12/06/15 08:44, Dries Feys wrote:
If the date to check is in B3, try
Am 12.06.2015 um 09:51 schrieb Andrea Venturoli:
Hello.
A customer of mine reported this problem to me on Windows 7/64b with LO
4.4.3.
When she opens some XLSX file (which contains from a few to a lot of
sheets), sometimes one of the sheet is blank (i.e. all the cells are
empty as if it
Hello.
A customer of mine reported this problem to me on Windows 7/64b with LO
4.4.3.
When she opens some XLSX file (which contains from a few to a lot of
sheets), sometimes one of the sheet is blank (i.e. all the cells are
empty as if it was a new sheet).
This is very critical, since if
On 12 Jun 2015 at 8:49, Gordon Burgess-Parker wrote:
Date sent: Fri, 12 Jun 2015 08:49:35 +0100
From: Gordon Burgess-Parker gordo...@mail.com
To: users@global.libreoffice.org
Subject:Re: [libreoffice-users] Calc date formulae
On
Anyone know of one? I can't find any.
--
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:
On 12/06/15 08:44, Dries Feys wrote:
If the date to check is in B3, try the following formula:
=IF(WEEKDAY(B3)=1;B3-2;IF(WEEKDAY(B3)=7;B3-1;B3))
Don't forget to format the target cell as a date ;-)
Succes
Great! Brilliant! Thanks very much!
--
To unsubscribe e-mail to:
=On 12 Jun 2015 at 18:39, Gordon Burgess-Parker , users wrote:
From:=Michael D. Setzer iimi...@kuentos.guam.net
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:
Hi,
I have a series of future dates calculated according to certain criteria.
I would like to:
1. Add a formula in a cell that says if this date is a Saturday,
subtract one day, if this date is a Sunday subtract 2 days, if this date
is a weekday, do nothing
2. I don't know if this is even
On 12/06/15 09:51, Andrea Venturoli wrote:
When she opens some XLSX file (which contains from a few to a lot of
sheets), sometimes one of the sheet is blank (i.e. all the cells are
empty as if it was a new sheet).
XLSX files are always tricky, as they change for every version of MS
Office.
Am 12.06.2015 um 10:39 schrieb Michael D. Setzer II:
On 12 Jun 2015 at 8:49, Gordon Burgess-Parker wrote:
Date sent:Fri, 12 Jun 2015 08:49:35 +0100
From:Gordon burgess-parkergordo...@mail.com
To:users@global.libreoffice.org
Subject:Re: [libreoffice-users] Calc date formulae
On
Hello everyone :-)
is there a way to export a chart from Calc as EPS containing text for
later work with LaTeX's pstool/psfrag?
I've tried the EPS (...) TextMode oor:type=xs:int
oor:nillable=falsevalue2/value tweak (changing the value from 0
to 2) in LibreOffice 4\share\registry\main.xcd as
Better answer here:
http://stackoverflow.com/questions/13951800/export-a-libreoffice-calc-chart-to-pdf-witouth-margins-and-empty-space
Select and copy (ctrl+c) your graph.
Open LibreOffice Draw
Paste your graph from Calc into Draw
Select the graph, and go to File -- Export,
Writer2LaTeX, Writer2BibTeX, Writer2xhtml and Calc2xhtml
This may help http://writer2latex.sourceforge.net/ I don't really know
much about LaTex.
Writer2LaTeX, Writer2BibTeX, Writer2xhtml and Calc2xhtml
It implies that a Calc chart might be copied into Writer and output for
LaTex.
Best
15 matches
Mail list logo