Forum Widgets
Latest Discussions
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 combinationmeghnabilimoria-insightsoftwareJun 23, 2025Occasional Reader4Views0likes0CommentsHelp with Excel 'Format copy' does not include 'new line (Alt Enter) within a cell.
Hello, Note that Excel 'format copy' does not copy over the 'new line (Alt Enter)' within a cell. Is there another way to copy format of a cell that includes the 'new line' formatting?pspisarJun 23, 2025Occasional Reader2Views0likes0CommentsHelp with Excel report creation for review results from multiple worksheets...
Windows 11 MS Office 365 Cloud Accessed from Citrix desktop I've been working on this project for a while and have a tracking spreadsheet for several review categories, each on its own worksheet tab. I have a results page that gives me the data I need. The table on the RESULTS tab contains the results for the reviews and marks them as either having 'Not Met', 'Met' or 'Exceeded' the goal for each category. The final piece of the project is giving us problems. I received a great deal of help with it from @HansVodelaar here on the forum and he got very close to solving it. I've included the spreadsheet with the final attempted 'Result' tab. Here is what I'm trying to do now... Automatically generate a simple report Based on the generated date on 'RESULTS' for the selected Rep That lists all records, Labeled by review category (see review tabs), From the designated start date to designated end date, Only for the categories with scores designating them as either 'Not Met' or 'Exceeding' the goal. So far, the 'Report' tab works to list the records. However, there are a couple of problems with it. I can't seem to successfully copy the formula to the master workbook, which holds the same structure, but is not redacted. The returned data, as is, only separates the categories by a blank line, but does not identify to which review tabs (categories) the results belong. Any help offered is greatly appreciated. Hans suggested that the solution may require use of Power Query. So, if anyone has an idea of how I can accomplish this report without having to go into each tab to filter, sort, format and print, it would be totally awesome!!Marcus_BoothJun 23, 2025Copper Contributor99Views0likes15CommentsExcel FILTER function not working with some formulas
Hey all, Very weird issue: The FILTER function doesn't return anything when the target cell contains certain (but not all) formulas. For example, it would work if I manually type 0.1 but it will NOT work if I have a =11.9-11.8 formula. It DOES work however on =0.05+0.05 or = 2.9-2.8. I tried formatting the cells every possible way - general, number, indentation, etc and no go. Attaching some screenshots. Could you help me out?BreakingBadlyJun 23, 2025Occasional Reader22Views0likes1CommentSpreadsheet refuses to change Date Serial number to mm/dd/yy format
I have tried changing the column formatting, and using text to column copying and DATEVALUE formulae, and copying the columns to a blank spreadsheet & back. Nothing. What's wrong?ronjohnson2redcrossJun 23, 2025Copper Contributor9Views0likes0CommentsAdding an end time to existing row using VBA
I have the VBA set up to enter the date and time for when they start an order, but I need help for when they finish an order. When they finish the order and click the "Finish" button, I need the VBA to look for the original transfer number in the Data tab then return the end date and time (yellow). I realized that with the VAB I have now, it is starting a new line and entering the end time. Attaching the file. Thank you in advance.CatherineMaddenJun 23, 2025Copper Contributor120Views0likes3CommentsExcel page break not working
I've created page breaks in Excel spreadsheets many times, but all of a sudden the feature isn't working in Excel 365. Any suggestions? I go to Page Break Preview, where everything is on the one page. I then position the cursor about halfway down the sheet in Column A, go the Page Layout and click on Insert Page Break. Absolutely nothing happens. Even if I select the Remove Page Breaks option beforehand it still doesn't work. Is there a bug in Excel 365? How can I overcome it?SolvedSpydahJun 23, 2025Copper Contributor123KViews1like21CommentsSuddenly excel slows down or crashes with history files
Good morning, I am a italian A1 volleyball data analyst (female) and I use Excel to create my match sheets. Opening one of my files in the last few days the file blocks the application or slows it down so much that it is not possible to use them. I have w11 and Office 365 personal updated to the latest versions. I have already uninstalled and reinstalled Office 365 but the problem persists. Opening the file from "Libre Office" there are absolutely no problems and I have been using these files for at least 3 years in Excel.gustavo_gallottiJun 23, 2025Copper Contributor13Views0likes1CommentIssue with INDIRECT formula
Hi Guys i am having an issue with running a Indirect formula to take intersect a column and a row of a "skill vs will" matrix to give an intersecting answer. I have created from a selection in the name manager section in formulas, have set drop down lists for each column and used the formula =INDIRECT(I18) INDIRECT(J18) It is only affecting 2 rows from the matrix but other than that it works Anyone got any tips?Frostyboy86Jun 23, 2025Copper Contributor28Views0likes1Comment
Resources
Tags
- excel42,846 Topics
- Formulas and Functions24,858 Topics
- Macros and VBA6,442 Topics
- office 3656,087 Topics
- Excel on Mac2,666 Topics
- BI & Data Analysis2,399 Topics
- Excel for web1,938 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,655 Topics