![]() When I simple copying, a manuel modified XY chart with related data range, this will also lead to a chart with own data table and messed data. How can I manipulate the data and only refresh the values, without the complete recreating of the chart ? I think when the macro execute the line "tData(newData3)" the whole diagramm will be recreated with default settings that mean only one data column for X value? Select Format Page from the main menu Select the Sheet tab in the dialog that appears Select the Scaling Mode and a scale Click OK Use Page Preview (instructions above) to see a preview of what will print. In the end only the first column in the shown data array(0) (oData3) will be stored as X value in the table, for each Y value and the other columns with X values turns to Y-values, when you write the data back. The problem is that the data appear new arranged after they was written back to the chart, it seems there is a automatic converting process before the data really was written in charts object ?Įspecially for XY charts, it seems, that the X values which are shown in the data table for each Y value, ![]() The code you have proposed, I could successfully implement, it means, I was able to manipulate the data and write it back in the data table.īut the chart changes from a chart with embedded data area to a chart with its own data table, like a already copied chart, but that is not really the problem. ![]() I try it immediately to figure out it is what I'm seeking ) I'm not really sure where to go from here.It brings me a little further, but until now it is not the solution which I am looking for I haven't seen anything in our logs or in the system log to tell me what's going on. I verified that NETWORK SERVICE has write access to the destination directory, read access to the source file, and again I verified that I can run the command manually in a command window. However, when NETWORK SERVICE tries to run it from the web app, it spawns up a soffice.exe*32 and an soffice.bin*32 and just hangs for several minutes until it times out. We tried upgrading to OpenOffice 4.2.1, installed the macro and verified that the macro runs correctly when I run it in a command line as a normal user. That was working without issue using OpenOffice Portable version 3.2. If you now right click on the chart, the context menu will include a Data Ranges option. If you double click on the chart to put it in edit mode, you should see the data cells highlighted with a colored border. NET MVC web application running as NETWORK SERVICE.\soffice.exe -invisible macro:///(sourceFile,destinationFile) I suspect that during the copying process the link between the chart and the cells containing the data broke. Dont miss to download the new release and find out yourself. In the Release Notes you can read about all new bugfixes, improvements and languages. ![]() We run a command like the following in a. 7 February 2021: The Apache OpenOffice project announces the official release of version 4.1.9. 30 December 2017: The Apache OpenOffice project announces the official release of version 4.1.5. Get the option to update Sheet B when sheet is opened, but when updated, all linked entries show 0. Using two spreadsheets, linking numbers from cells in sheet A to cells in sheet B. We've been using OpenOffice Portable to convert. After updating from 4.1.2 to 4.1.4, my linked cells no longer update.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |