Jump to content
You must now use your email address to sign in [click for more info] ×

adrianlambert

Members
  • Posts

    61
  • Joined

  • Last visited

Posts posted by adrianlambert

  1. 7 minutes ago, Hangman said:

    Hi @adrianlambert,

    It works as per @anto's screen recording... you don't need to make any special adjustments because you basically have two overlapping fields in your data merge but also empty cells in your source data depending on which column the data is coming from so it works really well...

    Yes but how does AP know how to split the text style for each column when it's all populating the same repeating field?

     

  2. 1 hour ago, anto said:

    It works for me too on Windows.

    But I would organize the calendar a little differently. I would make the numbers that do not apply to the current month gray.
    There's no need for line breaks. Use top, middle, and bottom alignment.
    Put frame on frame, specify a different column in Libreoffice, and you can make your calendar in different colors.

     

     

    I'm wondering how the <Date> field would deal with the two columns? It looks to me that I'd need to manually specify a bunch of dates and set the fields to be <date_prev>, and that the number of days would vary month to month. Or is there a way that the field in AP could spot an unpopulated cell and refer to the data in another cell?

  3. 1 hour ago, Hangman said:

    Hi @adrianlambert,

    Change the Layer order within your Group so the Month appears below your Data Merge Layer... I had to update the CSV file in the Data Merge panel but I think that's only because it didn't automatically link the file when I opened your Publisher document so you may not need to do that...

    LayerOrder.png.4e99621ed206c6a795f92a3c439a05e2.png

    Thanks @Hangman, I'm on it now.

     

  4. 1 hour ago, anto said:

    It works for me too on Windows.

    But I would organize the calendar a little differently. I would make the numbers that do not apply to the current month gray.
    There's no need for line breaks. Use top, middle, and bottom alignment.
    Put frame on frame, specify a different column in Libreoffice, and you can make your calendar in different colors.

     

     

    Thanks, great idea!

  5. I've followed the instruction and advice and created a calendar for 2024 which is spot on except one odd issue. If I preview the first row I see the month appear where it previously showed <MONTH>. As I expected. But when I tap 'generate' where the preview showed January, I see February instead, but I see the dates and holidays for January. The month title is out of step all the way down until December where nothing is showing bar the year (<MONTH> 2024).

    Is this operator error? Or a bug?

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.