Issue with Creating a Pictorial Directory in WORD with Mail Merge
I have spent hours learning and discussing this issue with your tech people but don't have a solution. I am trying to include pictures in a WORD directory. I can't get the pictures to show no matter what I do. I am working in Office 365. I am using the INCLUDEPICTURE quick part. Thank you.
Can Excel =filter function include a 'criteria range' for multiple criteria of one column?
Hello Everyone, I am trying to use =filter formula to filter multiple criteria for a single column as below, by using a "criteria range": However it is not working and return an #N/A I'd like to use the =filter to return an dynamic array by using "criteria range", as if what the 'advanced filter' can do to filter multiple criteria of a particular column: I know that =filter can do multiple criteria, by including each criteria in the formula one-by-one: however, comparing to a single 'criteria range/ array', this method is far too troublesome especially when there is a long list of criteria for a particular column. Did I make any mistakes in the =filter formula with a 'criteria range'?; or the =filter formula is just not capable to do that? Thank you!Double sided printing problem in Office 365
I have Office 365 and use Excel for most of my work. When have a file that has multiple pages, the settings for single sided printing / double sided printing are giving me grief. When I want to print multiple pages single sided, the printer keeps printing double sided (but not all of the sheets). For example - if I set it to "Print Entire Workbook" and then select the option to "Print One Sided", the first few sheets of the workbook come out single sided and then the rest start coming out double sided. In a different scenario, if I select multiple sheets, I'll select "Print Active Sheets" and then verify that it is set to "Print One Sided" however only the first active sheet comes out single sided -- the rest come out double sided. I've verified in the printer device settings that the default is set to "None" under the double sided printing settings, is there somewhere else that I need to change this? I didn't have this issue with the previous version of Excel that I was using, this has only started happening since I started using 365 -- I end up wasting a lot of paper because I can't get it to stop printing double sided.
Invalid procedure call or argument (VBA Error 5 Excel) in Build 19011.20000
Version 2507 (Build 19011.20000) gives the following VBA error in Excel: "Invalid procedure call or argument (Error 5)" It stops at the following line in VBA: === qv_wiel = WorksheetFunction.Min(3 * wiellast / (2 * Pi * Sqr(Sqr((x_wiel - x0) ^ 2 + (y_wiel - y0) ^ 2) ^ 2 + H_eq ^ 2) ^ 2) * Cos(WorksheetFunction.Radians(WorksheetFunction.Degrees(Atn(Sqr((x_wiel - x0) ^ 2 + (y_wiel - y0) ^ 2) / H_eq)))) ^ 3, wiellast * 4 * (1 / 4 - 1 / (2 * Pi) * (WorksheetFunction.Asin(2 * H_eq * Sqr((4 * H_eq ^ 2 + L_strook ^ 2 + B_strook ^ 2) / ((4 * H_eq ^ 2 + L_strook ^ 2) * (4 * H_eq ^ 2 + B_strook ^ 2)))) - 2 * H_eq * L_strook * B_strook / Sqr(4 * H_eq ^ 2 + L_strook ^ 2 + B_strook ^ 2) * (1 / (4 * H_eq ^ 2 + L_strook ^ 2) + 1 / (4 * H_eq ^ 2 + B_strook ^ 2)))) / (B_strook * L_strook)) === This issue didn't exist in Version 2506 (May 2025) and lower.
HFM formula does not work in Automatic Calculation options mode
We are encountering an issue when saving Excel workbooks that contain HFM (Hyperion Financial Management) formulas using Aspose.Cells. The behavior varies depending on the calculation mode configured within the workbook: Manual Calculation Mode: The HFM formulas are preserved correctly upon saving. The data remains visible, although in some cases, it appears with strikethrough formatting. Automatic Calculation Mode: The formulas are either lost or fail to retain their expected values after saving, resulting in missing or incorrect data. We have attached two sample workbooks for your reference: One opened in Excel 2016, where the data displays correctly. The same file opened in Office 365, where the HFM data is not displayed as expected. Here is an example of one of the HFM formulas used in the file: This formula is used to retrieve data from HFM via Smart View. In Manual mode, the formula persists and displays data (albeit sometimes with strikethrough). However, in Automatic mode, the formula either disappears or does not function as intended. We would appreciate any guidance or insights you can provide on how to preserve these formulas correctly across different calculation modes and Office versions when using Aspose.Cells. Both excels are in this shared drive, https://drive.google.com/drive/folders/1WgTKSL-W4tuBT1U4nqJW18xUHzJ4K73o?usp=sharing We also observed Automatic Calculation options work or not work in this combination
